Home › Quizzes › RDBMS Fundamentals

RDBMS Fundamentals

Covers core RDBMS concepts including transactions, normalization, concurrency control, and SQL operations

5 Questions Published
Play Quiz Practise this topic out loud

Questions

Question 1 Multiple Choice (Single Answer)

Which of the following is not a proper state of transaction?

  1. Partially aborted
  2. Partially committed
  3. Aborted
  4. Committed
  5. Rollback
Question 2 Multiple Choice (Single Answer)

Rollback of transactions is normally used to

  1. update the transaction
  2. repeat a transaction
  3. retrieve old transaction
  4. recover from transaction failure
  5. delete the transaction
Question 3 Multiple Choice (Single Answer)

A deadlock exists in the system if and only if the wait for graph

  1. has a path from first node to the last node
  2. has a cycle in it
  3. has a tree in it
  4. has a graph in it
  5. has a B+ tree in it
Question 4 Multiple Choice (Single Answer)

4NF is designed to cope up with

  1. multivalued dependency
  2. transitive dependency
  3. logical dependency
  4. join dependency
  5. full functional dependency
Question 5 Multiple Choice (Single Answer)

Which of the following is a valid join type?

  1. Natural join
  2. Full outer join
  3. On join
  4. Double join
  5. Middle join
← Back to Quizzes