Database Management System - DBMS MCQ Questions and Answers Quiz

41. One solution to the multivalued dependency constraint problem is to:

  1. Create a new theme.
  2. split the relation into two relations, each with a single theme
  3. Change the theme.
  4. add a composite key

42. The SQL command to creating a table is:

  1. Create table
  2. Make table
  3. Alter table
  4. Define table

43. The following are functions of a DBMS except………………

  1. creating databases
  2. creating and processing forms
  3. processing data
  4. administrating databases

44. Which of the following is not a Schema?

  1. Critical Schema
  2. Database Schema
  3. Physical Schema
  4. Logical Schema

45. DCL stands for

  1. Data Console Level
  2. Data Control Language
  3. Data Console Language
  4. Data Control Level

46. One aspect that has to be dealt with by the integrity subsystem is to ensure that only valid values can be assigned to each data items. This is referred to as

  1. Data Control
  2. Data Security
  3. Domain access
  4. Domain Integrity

47. DFD stands for

  1. Data Flow Diagram
  2. Data Flow Document
  3. Data File Diagram
  4. Non of the above

48. DML is a language by which user accesses or manipulates the………………

  1. Data integration
  2. Data model
  3. Data consistency
  4. Data sharing

49. Minimal data redundancy means improved………………

  1. Data integration
  2. Data independence
  3. Data consistency
  4. Data sharing

50. The provision of …………….. is a major objective for database system:

  1. Data integration
  2. Data independence
  3. Data consistency
  4. Data sharing

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....