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

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. What is ACID properties of Transactions?

  • (A) atomicity, consistency, isolation, database
  • (B) atomicity, consistency, isolation, durability
  • (C) atomicity, consistency, inconsistent, durability
  • (D) automatically, concurrency, isolation, durability

A

Admin • 833.24K Points
Coach

Q. If every non-key attribute is functionally dependent on the primary key, the relation will be in

  • (A) first normal form
  • (B) second normal form
  • (C) third normal form
  • (D) fourth formal form

A

Admin • 833.24K Points
Coach

Q. Database locking concept is used to solve the problem of

  • (A) lost update
  • (B) uncommitted dependency
  • (C) inconsistent data
  • (D) all of the above

A

Admin • 833.24K Points
Coach

Q. UML is stands for

  • (A) universal modeling language
  • (B) unified modeling language
  • (C) united modeling language
  • (D) uni modeling language

A

Admin • 833.24K Points
Coach

Q. Data Manipulation Language (DML) is not to

  • (A) create information table in the database
  • (B) insertion of new information into the database
  • (C) deletion of information in the database
  • (D) modification 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 primary-key value in an associated table
  • (D) every foreign-key value must match a foreign-key value in an associated table

A

Admin • 833.24K Points
Coach

Q. ODBC stands for ______

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

A

Admin • 833.24K Points
Coach

Q. Which algebra is widely used in DBMS?

  • (A) relational algebra
  • (B) arithmetic algebra
  • (C) both
  • (D) none

A

Admin • 833.24K Points
Coach

Q. Which of the following is an unary operation?

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

A

Admin • 833.24K Points
Coach

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

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

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.