151 DBMS MCQ Questions and Answer

A relational database consists of a collection ofa) Tablesb) Fieldsc) Recordsd) Keyse) none of these A __ in a table represents a relationship among a set of values.a) Columnb) Keyc) Rowd) Entrye) none of these b The term _ is used to refer to a row.a) Attributeb) Tuplec) Fieldd) Instancee) none of these The term … Read more

DBMS GATE Questions 2018

In this article you will get DBMS GATE Questions 2018 with answers. 1. In an Entity-Relationship (ER) model, suppose R is a many-to-one relationship from entity set E1 to entity set E2. Assume that E1 and E2 participate totally in R and that the cardinality of E1 is greater than the cardinality of E2. Which one … Read more

DBMS GATE Questions 2019

In this article you will get DBMS GATE Questions 2019 with answers. 1. Which one of the following statements is NOT correct about the B+ tree data structure used for creating an index of a relational database table? a. Each leaf node has a pointer to the next leaf nodeb. Non-leaf nodes have pointers to data recordsc. … Read more