DBMS MCQ


DBMS MCQ SET 9

Q.1 Which of the following relational algebra operations do not require the participating tables to be union-compatible? (A)    Union                                             (B)    Intersection (C)    Difference                                       (D)    Join  Ans: (D)                                                 Q.2 Which of the following is not a property of transactions? (A)    Atomicity                                        (B)    Concurrency  (C)    Isolation                                         (D)    Durability Ans: (B) […]


DBMS MCQ SET 8

 1. In the relational modes, cardinality is termed as: (A)  Number of                                      (B)    Number of attributes. (C)   Number of tables.                         (D)    Number of constraints. Ans: A  2 .  Relational calculus is a (A)Procedural […]


DBMS MCQ SET 7 NET GATE

Q.1               Which of the following relational algebra operations do not require the participating tables to be union-compatible?                      (A)    Union                                             (B)    Intersection                      (C)    Difference                                       (D)    Join                      Ans: (D)                                                  Q.2               Which of the following is not a property of transactions? (A)    Atomicity                                        (B)    Concurrency                      […]


DBMS MCQ SET 6

  81. A data dictionary does not provide information about A. Where data is located B. who owns it C. size of disk storage device D. How the data is used Ans Correct Answer is C     82. Data item characteristics that are important in data management include A. […]


DBMS MCQ SET 5

  41. What property of the files prevents sharing of files and directories? A. Tree structure B. One level structure C. Two level structure D. Length Ans Correct Answer is A     42. E-R modeling technique is: A. Tree structure B. Top-down method C. Bottom-up method D. Right-left approach […]


DBMS MCQ SET 4

21.) The language which has recently become the defacto standard for interfacing application programs with relational database system is A) Oracle. B) SQL. C) DBase. D) 4GL. Answer: Option B 22.) In an E-R diagram an entity set is represent by a A) Rectangle. B) Ellipse. C) Diamond box. D) Circle. Answer: Option A […]


DBMS MCQ SET 3

In the __________ normal form, a composite attribute is converted to individual attributes. A) First B) Second C) Third D) Fourth Answer:A Explanation: The first normal form is used to eliminate the duplicate information. A table on the many side of a one to many ormany to many relationship must: a) […]


DBMS MCQ SET 2

26. ____________ is an index whose search key also define sequential order of the file.   A.    Stack index   B.    Clustering index   C.    Hash index   D.    Dense    Answer:  Option  B 27. Clustering index is also called as ____________.   A.    secondary index   B.    primary index   C.    hash index   D.    sparse   […]


DBMS MCQ SET 1

DBMS QUESTIONS 1. The DBMS acts as an interface between what two components of an enterprise-class database system? A. Database application and the database B. Data and the database C. The user and the database application D. Database application and SQL Answer: Option A 2. Which of the following products was an […]