Database Management System - DBMS MCQ Questions and Answers Quiz

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
Tags

MCQ Multiple Choice Questions and Answers on Database Management System - DBMS

Database Management System - DBMS Trivia Questions and Answers PDF

Database Management System - 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....