DBMS Quizzes | Trivia Quiz for Practice

76. A B-tree of order m has maximum of _____________ children

1. m-1
2. m/2
3. m
4. m+1

77. 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. (m+n)/2
2. 2(m+n)
3. mn
4. m+n

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

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

79. SET concept is used in :

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

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

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

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

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

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

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

83. ODBC stands for

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

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

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

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

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

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

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

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

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

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

1. conceptual level
2. view level.
3. physical level.
4. logical level.