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

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. Snapshot of the dta in the database at a given instant of time is called

  • (A) database schema
  • (B) database instance
  • (C) database snapshot
  • (D) all of the above

A

Admin • 833.24K Points
Coach

Q. Which of the following is not Unary operation?

  • (A) select
  • (B) project
  • (C) rename
  • (D) union

A

Admin • 833.24K Points
Coach

Q. A logical description of some portion of database that is required by a user to perform task is called as

  • (A) system view
  • (B) user view
  • (C) logical view
  • (D) data view

A

Admin • 833.24K Points
Coach

Q. ______________ is a classical approach to database design?

  • (A) left – right approach
  • (B) right – left approach
  • (C) top – down approach
  • (D) bottom – up approach

A

Admin • 833.24K Points
Coach

Q. _____________ refers to the correctness and completeness of the data in a database?

  • (A) data security
  • (B) data integrity
  • (C) data constraint
  • (D) data independence

A

Admin • 833.24K Points
Coach

Q. A table that displays data redundancies yields ____________ anomalies

  • (A) insertion
  • (B) deletion
  • (C) update
  • (D) all of the above

A

Admin • 833.24K Points
Coach

Q. A lock that allows concurrent transactions to access different rows of the same table is known as a

  • (A) field-level lock
  • (B) row-level lock
  • (C) table-level lock
  • (D) database-level lock

A

Admin • 833.24K Points
Coach

Q. A type of query that is placed within a WHERE or HAVING clause of another query is called

  • (A) super query
  • (B) sub query
  • (C) master query
  • (D) multi-query

A

Admin • 833.24K Points
Coach

Q. A transaction completes its execution is said to be

  • (A) saved
  • (B) loaded
  • (C) rolled
  • (D) committed

A

Admin • 833.24K Points
Coach

Q. A in a table represents a relationship among a set of values.

  • (A) column
  • (B) key
  • (C) row
  • (D) entry

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.