DBMS MCQ Questions and Answers Quiz

81. In case of entity integrity, the primary key may be

  1. not Null
  2. Null
  3. both Null & not Null.
  4. any value.

82. In the relational modes, cardinality is termed as:

  1. Number of tuples.
  2. Number of attributes.
  3. Number of tables.
  4. Number of constraints.

83. ODBC stands for

  1. Object Database Connectivity.
  2. Oral Database Connectivity.
  3. Oracle Database Connectivity.
  4. Open Database Connectivity.

84. The language which has recently become the defacto standard for interfacing applicationprograms with relational database system is

  1. Oracle.
  2. SQL.
  3. DBase.
  4. 4GL.

85. A primary key is combined with a foreign key creates

  1. Parent-Child relation ship between the tables that connect them.
  2. Many to many relationship between the tables that connect them.
  3. Network model between the tables that connect them.
  4. None of the above.

86. A primary key if combined with a foreign key creates

  1. Parent-Child relationship between the tables that connect them.
  2. Many to many relationship between the tables that connect them.
  3. Network model between the tables that connect them.
  4. None of the above.

87. Which are the two ways in which entities can participate in a relationship?

  1. Passive and active
  2. Total and partial
  3. Simple and Complex
  4. All of the above

88. In the architecture of a database system external level is the

  1. physical level.
  2. logical level.
  3. conceptual level
  4. view level.
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....