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

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. Disadvantages of File systems to store data is:

  • (A) data redundancy and inconsistency
  • (B) data isolation
  • (C) all of the options
  • (D) difficulty in accessing data

A

Admin • 833.24K Points
Coach

Q. Which of the following is not a Storage Manager Component?

  • (A) transaction manager
  • (B) buffer manager
  • (C) file manager
  • (D) logical manager

A

Admin • 833.24K Points
Coach

Q. Data Manipulation Language (DML) is not to

  • (A) insertion of new information into the database
  • (B) modification of information in the database
  • (C) create information table in the database
  • (D) deletion of information in the database

A

Admin • 833.24K Points
Coach

Q. Which of the following in true regarding Referential Integrity?

  • (A) every primary-key value must match a primary-key value in an associated table
  • (B) every primary-key value must match a foreign-key value in an associated table
  • (C) every foreign-key value must match a foreign-key value in an associated table
  • (D) every foreign-key value must match a primary-key value in an associated table

A

Admin • 833.24K Points
Coach

Q. Which of the following option is use to retrieval of data?

  • (A) stack
  • (B) data structure
  • (C) linked list
  • (D) query

A

Admin • 833.24K Points
Coach

Q. ODBC stands for ______

  • (A) none of above
  • (B) open database connection
  • (C) offline database connection
  • (D) oriented database connection

A

Admin • 833.24K Points
Coach

Q. Which of the following is an unary operation?

  • (A) selection operation
  • (B) primitive operation
  • (C) projection operation
  • (D) generalized selection

A

Admin • 833.24K Points
Coach

Q. Which SQL Query is use to remove a table and all its data from the database?

  • (A) none of these
  • (B) drop table
  • (C) create table
  • (D) alter table

A

Admin • 833.24K Points
Coach

Q. In precedence of set operators the expression is evaluated from:

  • (A) left to right
  • (B) right to left
  • (C) left to left
  • (D) right to right

A

Admin • 833.24K Points
Coach

Q. In DBMS, FD stands for _______

  • (A) facilitate data
  • (B) functional data
  • (C) facilitate dependency
  • (D) functional dependency

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.