Skip to content

Category Archives: DBMS Quiz

Which of the following related to snowflake schema is true? (A) Each dimension is represented by a single dimensional table (B) Maintenance efforts are less… Read More
Which of the following command is used to delete a table in SQL? (A) delete (B) truncate (C) remove (D) drop Answer: (D) Explanation: drop… Read More
The statement that is executed automatically by the system as a side effect of the modification of the database is (A) backup (B) assertion (C)… Read More
Which of the following concurrency control protocols ensure both conflict serialzability and freedom from deadlock? I. 2-phase locking II. Time-stamp ordering (A) I only (B)… Read More
Which of the following statements are TRUE about an SQL query? P : An SQL query can contain a HAVING clause even if it does… Read More
Relation R has eight attributes ABCDEFGH. Fields of R contain only atomic values. F = {CH -> G, A -> BC, B -> CFH, E… Read More
Consider the following relational schema. Students(rollno: integer, sname: string) Courses(courseno: integer, cname: string) Registration(rollno: integer, courseno: integer, percent: real) Which of the following queries are… Read More
An index is clustered, if (A) it is on a set of fields that form a candidate key. (B) it is on a set of… Read More