Database Management System (DBMS) MCQs with answers Page - 154

Here, you will find a collection of MCQ questions on Database Management System (DBMS). Go through these questions to enhance your preparation for upcoming examinations and interviews.

To check the correct answer, simply click the View Answer button provided for each question.

Have your own questions to contribute? Click the button below to share your MCQs with others!

+ Add Question

A

Admin • 833.24K Points
Coach

Q. Different levels of access are assigned to personnel records in the health and fitness gym. Only the system manager is able to create delete or edit records. Certain other personnel are allowed to view all the records, whereas others are not permitted to view complete records. The levels of access are controlled by

  • (A) Password
  • (B) User id’s
  • (C) Status
  • (D) None of the above

A

Admin • 833.24K Points
Coach

Q. You can switch back and forth between design and datasheet view by clicking the

  • (A) queries object tab
  • (B) switch command on the view menu
  • (C) view button
  • (D) select query title bar

A

Admin • 833.24K Points
Coach

Q. A set of programs that handle a firm's database responsibilities is called

  • (A) database management system (dbms)
  • (B) data management system (dms)
  • (C) all of the options
  • (D) database processing system (dbps)

A

Admin • 833.24K Points
Coach

Q. A DBMS that combines a DBMS and an application generator is ________ .

  • (A) Microsoft's SQL Server
  • (B) Microsoft's Access
  • (C) IBM's DB2
  • (D) Oracle Corporation's Oracle

A

Admin • 833.24K Points
Coach

Q. Every relation in BCNF is also in

  • (A) 3NF
  • (B) 2NF
  • (C) 1NF
  • (D) Unnormalized Form

A

Admin • 833.24K Points
Coach

Q. A table that contains one or more repeating groups is in which normal form?

  • (A) 1NF
  • (B) 2NF
  • (C) 3NF
  • (D) ii and iv

A

Admin • 833.24K Points
Coach

Q. A relation is said to be in 3 NF if (i) it is in 2 NF (ii) non-key attributes are independent of one another (iii) key attribute is not dependent on part of a composite key (iv) has no multi-valued dependency

  • (A) i and iii
  • (B) i and iv
  • (C) i and ii
  • (D) it has more than 3 non-key attributes

A

Admin • 833.24K Points
Coach

Q. Given the following relation it is not 3 NF because Student (roll no, name, course no, course max. marks, year of study, address)

  • (A) it is not in 2 NF
  • (B) it does not have composite key
  • (C) non-key attributes course no and course max. marks are functionally dependent
  • (D) student (roll no, name, address) course (course no, course max. marks, year of study)

A

Admin • 833.24K Points
Coach

Q. Given the following relation Student (roll no, name, course no, course max. marks, year of study, address) The corresponding 3 NF relations are

  • (A) student (roll no, name, year of study, address) course (course no, course max. marks)
  • (B) student ( roll no, name, year of study, address) student (roll no, course no) course (course no, course max. marks)
  • (C) student (roll no , name, address) year (roll no, year of study) course (course no, course max. marks)
  • (D) there are two possible keys and they are dependent on one another

A

Admin • 833.24K Points
Coach

Q. BoyeCodd Normal Form (BCNF) is needed when

  • (A) two non-key attributes are dependent
  • (B) there is more then one possible composite key
  • (C) there are two or more possible composite overlapping keys and one attributeof a composite key is dependent on an attribute of another composite key
  • (D) it has no overlapping composite keys which have related attributes

Add MCQ in this Category

If you want to share an MCQ question in this category, it's a great idea! It will be helpful for many other students using this website.

Share Your MCQ

Browse Categories

Click on category to learn MCQs of that category.