Database Management System - DBMS Multiple Choice Questions and Answers

91. ……………… clause is an additional filter that is applied to the result.

1. Having
2. Select
3. Group-by
4. Order by

92. In which model of database data is stored in tables:

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

93. The .................... is essentially used to search for patterns in target string.

1. In Predicate
2. Like Predicate
3. Null Predicate
4. Out Predicate

94. ……………… defines rules regarding the values allowed in columns and is the standard mechanism for enforcing database integrity.

1. Index
2. Column
3. Constraint
4. Trigger

95. ……………….contains information that defines valid values that are stored in a column or data type.

1. Index
2. View
3. Rule
4. Default

96. The data in the database at a particular moment in time is called a ………………

1. Initial state
2. Database state
3. Valid state
4. Empty state

97. ACID properties of transactions are

1. Isolation
2. Atomicity
3. Consistency
4. Durability

98. If several concurrent transactions are executed over the same data set and the second transaction updates the database before the first transaction is finished, the ____ property is violated and the database is no longer consistent.

1. isolation
2. atomicity
3. consistency
4. Durability

99. An attribute is a(n):

1. key of a table
2. two dimensional table
3. row of a table
4. column of a table

100. Retrieval of data is done by using a………………

1. Linked list
2. Stack
3. Query
4. All of these