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

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 are the after triggers ?

  • (A) Triggers generated after a particular operation
  • (B) These triggers run after an insert, update or delete on a table
  • (C) These triggers run after an insert, views, update or delete on a table
  • (D) Both b and c

A

Admin • 833.24K Points
Coach

Q. The variables in the triggers are declared using

  • (A) -
  • (B) @
  • (C) /
  • (D) /@

A

Admin • 833.24K Points
Coach

Q. Which of the following is NOT an Oracle-supported trigger?

  • (A) BEFORE
  • (B) DURING
  • (C) AFTER
  • (D) INSTEAD OF

A

Admin • 833.24K Points
Coach

Q. Which of the following is true concerning triggers?

  • (A) We do not create them with SQL.
  • (B) They execute against only some applications that access a database.
  • (C) They have an event, condition, and action.
  • (D) They cannot cascade (cause another trigger to fire).

A

Admin • 833.24K Points
Coach

Q. Which type of entity represents a logical generalization whose actual occurrence is represented by a second, associated entity?

  • (A) Supertype entity
  • (B) Subtype entity
  • (C) Archetype entity
  • (D) Instance entity

A

Admin • 833.24K Points
Coach

Q. Which of the following is the preferred way to recover a database after a transaction in progress terminates abnormally?

  • (A) Rollback
  • (B) Rollforward
  • (C) Switch to duplicate database
  • (D) Reprocess transactions

A

Admin • 833.24K Points
Coach

Q. Concurrency control is important for which of the following reasons?

  • (A) To ensure data integrity when updates occur to the database in a multiuser environment
  • (B) To ensure data integrity when updates occur to the database in a single-user environment
  • (C) To ensure data integrity while reading data occurs to the database in a multiuser environment
  • (D) To ensure data integrity while reading data occurs to the database in a singleuser environment

A

Admin • 833.24K Points
Coach

Q. The transaction log includes which of the following?

  • (A) The before-image of a record
  • (B) The after-image of a record
  • (C) The before and after-image of a record
  • (D) The essential data of the record

A

Admin • 833.24K Points
Coach

Q. What is the type of Oracle backup in which all uncommitted changes have been removed from the datafiles?

  • (A) Full backup
  • (B) Consistent backup
  • (C) Inconsistent backup
  • (D) Differential backup

A

Admin • 833.24K Points
Coach

Q. Which of the following is true concerning a procedure?

  • (A) You do not create them with SQL.
  • (B) They do not need to have a unique name.
  • (C) They include procedural and SQL statements.
  • (D) They are the same thing as a function.

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.