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

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. The result of unknown is unknown.

  • (A) xor
  • (B) or
  • (C) and
  • (D) not

A

Admin • 833.24K Points
Coach

Q. Aggregate functions are functions that take a as input and return a single value.

  • (A) collection of values
  • (B) single value
  • (C) aggregate value
  • (D) both collection of values & single value

A

Admin • 833.24K Points
Coach

Q. A Boolean data type that can take values true, false, and

  • (A) 1
  • (B) 0
  • (C) null
  • (D) unknown

A

Admin • 833.24K Points
Coach

Q. In case of any shut down during transaction before commit which of the following statement is done automatically?

  • (A) view
  • (B) commit
  • (C) rollback
  • (D) flashback

A

Admin • 833.24K Points
Coach

Q. In order to maintain the consistency during transactions, database provides

  • (A) commit
  • (B) atomic
  • (C) flashback
  • (D) retain

A

Admin • 833.24K Points
Coach

Q. A transaction completes its execution is said to be

  • (A) committed
  • (B) aborted
  • (C) rolled back
  • (D) failed

A

Admin • 833.24K Points
Coach

Q. Which of the following is used to get back all the transactions back after rollback?

  • (A) commit
  • (B) rollback
  • (C) flashback
  • (D) redo

A

Admin • 833.24K Points
Coach

Q. will undo all statements up to commit?

  • (A) transaction
  • (B) flashback
  • (C) rollback
  • (D) abort

A

Admin • 833.24K Points
Coach

Q. Which of the following is not an integrity constraint?

  • (A) not null
  • (B) positive
  • (C) unique
  • (D) check ‘predicate’

A

Admin • 833.24K Points
Coach

Q. Domain constraints, functional dependency and referential integrity are special forms of

  • (A) foreign key
  • (B) primary key
  • (C) assertion
  • (D) referential constraint

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.