DBMS MCQ Questions and Answers Quiz

41. Consider the join of a relation R with relation S. If R has m tuples and S has n tuples, then the maximum size of join is:

  1. mn
  2. m+n
  3. (m+n)/2
  4. 2(m+n)

42. The way a particular application views the data from the database that the applicationuses is a

  1. module.
  2. relational model.
  3. schema.
  4. sub schema.

43. SET concept is used in :

  1. Network Model
  2. Hierarchical Model
  3. Relational Model
  4. None of these

44. Which of the following is record based logical model?

  1. Network Model
  2. Object oriented model
  3. E-R Model
  4. None of these

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

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

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

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

47. ODBC stands for

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

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

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

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

MCQ Multiple Choice Questions and Answers on DBMS

DBMS Question and Answer