DBMS MCQ Questions and Answers Quiz

71. Which one of the following statements is false?

  1. The data dictionary is normally maintained by the database administrator.
  2. Data elements in the database can be modified by changing the data dictionary.
  3. The data dictionary contains the name and description of each data element.
  4. The data dictionary is a tool used exclusively by the database administrator.

72. A subschema expresses

  1. the logical view.
  2. the physical view.
  3. the external view.
  4. all of the above.

73. A data dictionary is a special file that contains:

  1. The name of all fields in all files.
  2. The width of all fields in all files.
  3. The data type of all fields in all files.
  4. All of the above.

74. NULL is

  1. the same as 0 for integer
  2. the same as blank for character
  3. the same as 0 for integer and blank for character
  4. not a value

75. Hierarchical model is also called

  1. Tree structure
  2. Plex Structure
  3. Normalize Structure
  4. Table Structure

76. The RDBMS terminology for a row is

  1. tuple.
  2. relation.
  3. attribute
  4. degree

77. In a relational model, relations are termed as

  1. Tuples.
  2. Attributes
  3. Tables.
  4. Rows.

78. Architecture of the database can be viewed as

  1. two levels.
  2. four levels.
  3. three levels.
  4. one level.

79. What is a relationship called when it is maintained between two entities?

  1. Unary
  2. Binary
  3. Ternary
  4. Quaternary

80. Cross Product is a:

  1. Unary Operator
  2. Ternary Operator
  3. Binary Operator
  4. Not an operator
Tags

MCQ Multiple Choice Questions and Answers on DBMS

DBMS Trivia Questions and Answers PDF

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