This set of RDBMS online test focuses on “Transformation of Relational Expressions”. 1. If on every legal database instant, the two expressions generate the same set of tuples, the expressions are called as a) Equal b) Equivalent c) Similar d) Identical 2. State true or false: Selection operations are commutative a) True b) False 3. … Read more
This set of RDBMS Multiple Choice Questions & Answers (MCQs) focuses on “Evaluation of Expressions”. 1. If the results of one operation are passed on to the other, it is called as ________ a) Chain b) Pipeline c) Materialized d) Tree 2. The result of each intermediate operation are created and then are used for … Read more
This set of RDBMS Multiple Choice Questions & Answers (MCQs) focuses on “Join and Other Operations”. 1. A join of the form r ⨝r.A=s.B s is called as a) Equi join b) Left outer join c) Right outer join d) Full outer join 2. for each tuple tr in r do begin FOR each tuple … Read more
This set of RDBMS Multiple Choice Questions & Answers focuses on “Query Processing – Selection Operation & Sorting”. 1. Which of the following are steps in query processing? a) Parsing and translation b) Optimization c) Evaluation d) All of the mentioned 2. A relational algebra operation annotated with instructions on how to evaluate it is … Read more
This set of RDBMS Multiple Choice Questions & Answers (MCQs) focuses on “Bitmap Indices”. 1. A bitmap is _______ a) An array of bits b) An index of bits c) A function mapping all the bits of data d) None of the mentioned 2. A _________ on the attribute A of relation r consists of … Read more
This set of RDBMS Multiple Choice Questions & Answers (MCQs) focuses on “Dynamic Hashing”. 1. Dynamic hashing allows us to? a) Accommodate the growth of the database b) Accommodate the shrinkage of the database c) Allows modification of hash function d) All of the mentioned 2. Dynamic hashing is also called as _________ a) Extended … Read more
This set of RDBMS Multiple Choice Questions & Answers (MCQs) focuses on “Static Hashing”. 1. The term ______ is used to denote a unit of storage that can store one or more records a) Basket b) Bucket c) Unit d) Set 2. If K denotes the set of all the search key values, and B … Read more
This set of RDBMS Multiple Choice Questions & Answers (MCQs) focuses on “B+ Tree Index Files”. 1. State true or false: B+ trees are not always balanced trees. a) True b) False 2. What are the leaf nodes in a B+ tree? a) The topmost nodes b) The bottommost nodes c) The nodes in between … Read more
This set of RDBMS Multiple Choice Questions & Answers (MCQs) focuses on “Ordered Indices”. 1. The types of access that are supported efficiently are called as ________ a) Access modes b) Access types c) Access time d) Access overhead 2. The time it takes to find a particular data item is called as ___________ a) … Read more
This set of RDBMS MCQs focuses on “Organization of Records in Files”. 1. What is heap file organization? a) Any record can be placed wherever there is a space for the record b) Records are stored in a sequential order according to a search key c) A hash function is computed on some attribute and … Read more
