Database Management System - DBMS MCQ Questions and Answers Quiz

31. BCNF stands for:

  1. Boyce-Codd normal form
  2. Basic -Codd normal form
  3. Build -Codd normal form
  4. None of these

32. Which of the following is not a Storage Manager Component?

  1. Buffer Manager
  2. Transaction Manager
  3. Logical Manager
  4. File Manager

33. ……………… is a combination of two of more attributes used as a primary key

  1. Candidate Key
  2. Composite Key
  3. Alternate Key
  4. Foreign Key

34. A Database Management System (DBMS) is

  1. Collection of data describing one particular enterprise
  2. Collection of interrelated data
  3. Collection of programs to access data
  4. All of the above

35. Which is the transformation of requests and results between different levels of abstraction:

  1. Compiler
  2. Evaluation
  3. Mapping
  4. Precompiler

36. Drop Table cannot be used to drop a table referenced by a …………… constraint.

  1. Composite Key
  2. Local Key
  3. Primary Key
  4. Foreign Key

37. Drop Table cannot be used to drop a table referenced by a …………… constraint.

  1. Composite Key
  2. Local Key
  3. Primary Key
  4. Foreign Key

38. In the relational model, relationships between relations or tables are created by using:

  1. Composite Keys
  2. Candidate keys
  3. Foreign keys
  4. Determinants

39. All transactions are controlled and executed by the DBMS (subject to some limitations to guarantee database ………………

  1. consistency
  2. integrity
  3. uniqueness
  4. Design

40. A ………………database state is one in which all data integrity constraints are satisfied

  1. consistent
  2. fixed
  3. complete
  4. Secure
Tags

MCQ Multiple Choice Questions and Answers on Database Management System - DBMS

Database Management System - DBMS Trivia Questions and Answers PDF

Database Management System - DBMS Question and Answer

Spreading Knowledge Across the World

USA - United States of America  Canada  United Kingdom  Australia  New Zealand  South America  Brazil  Portugal  Netherland  South Africa  Ethiopia  Zambia  Singapore  Malaysia  India  China  UAE - Saudi Arabia  Qatar  Oman  Kuwait  Bahrain  Dubai  Israil  England  Scotland  Norway  Ireland  Denmark  France  Spain  Poland  and many more....