RDBMS Objective Questions

RDBMS Multiple Choice Questions on “Dynamic Hashing”. 1. Dynamic hashing allows us to? a) Accommodate the growth of the database […]

RDBMS Multiple Choice Questions on “Validation Based Protocols”. 1. The _________ requires each transaction executes in two or three different

RDBMS Multiple Choice Questions on “Set Operations”. 1. What is the function of the union operation? a) It combines the

RDBMS test on “Decomposition Using Functional Dependencies”. 1. An instance of a relation that satisfies all real world constraints is

RDBMS Multiple Choice Questions on “Bitmap Indices”. 1. A bitmap is _______ a) An array of bits b) An index

RDBMS Questions and Answers for Entrance exams on “Multiversion Schemes, Snapshot Isolation”. 1. In _______ schemes, each write operation creates

RDBMS Multiple Choice Questions on “Aggregate Functions”. 1. Which of the following is not a built in aggregate function in

RDBMS Multiple Choice Questions on “Functional Dependency Theory”. 1. A functional dependency f on R is _______ by a set

RDBMS Multiple Choice Questions & Answers on “Query Processing – Selection Operation & Sorting”. 1. Which of the following are

RDBMS Multiple Choice Questions on “Insert, Delete Operations and Predicate Reads”. 1. ________ deletes a data item from a database

RDBMS Multiple Choice Questions on “Nested SubQueries”. 1. What is a subquery? a) A subquery is a select-from-where expression that

RDBMS Multiple Choice Questions on “Decomposition Algorithms”. 1. What does the BCNF decomposition algorithm do? a) States a method to

RDBMS Multiple Choice Questions on “Join and Other Operations”. 1. A join of the form r ⨝r.A=s.B s is called

RDBMS Problems on “Failure Classification and Storage”. 1. Which of the following can cause a transaction failure a) Logical error

RDBMS Interview Questions and Answers on “Modification of Database”. 1. Insert the appropriate key word in the blank in the