Database Management System - DBMS Objective Question and Answer
Database Management System - DBMS MCQ Multiple Choice Questions - Page 4 for Practice
91. ……………… clause is an additional filter that is applied to the result.
Correct Answer is: Having
92. In which model of database data is stored in tables:
Correct Answer is: Relational model
93. The .................... is essentially used to search for patterns in target string.
Correct Answer is: Like Predicate
94. ……………… defines rules regarding the values allowed in columns and is the standard mechanism for enforcing database integrity.
Correct Answer is: Constraint
95. ……………….contains information that defines valid values that are stored in a column or data type.
Correct Answer is: Index
96. The data in the database at a particular moment in time is called a ………………
Correct Answer is: Database state
97. ACID properties of transactions are
Correct Answer is: 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.
Correct Answer is: isolation
99. An attribute is a(n):
Correct Answer is: column of a table
100. Retrieval of data is done by using a………………
Correct Answer is: Query
101. Which of the following is not a level of data abstraction?
Correct Answer is: Critical Level
102. In which ways two tables may be related:
Correct Answer is: All of these
103. A data dictionary is a repository that manages ………………
Correct Answer is: Metadata
104. …………… database is used as template for all databases
Correct Answer is: Master
105. The DBMS utility..................... allows reconstructing the correct state of database from the backup and history of transactions.
Correct Answer is: Recovery
106. The DBMSutility,………………allows to reconstruct the correct state of database from the backup and history of transactions.
Correct Answer is: Recovery
107. An outstanding functionality of SQL is its support for automatic ………… to the target data.
Correct Answer is: Navigation
108. A ……………… does not have a distinguishing attribute if its own and mostly are dependent entities, which are part of some another entity.
Correct Answer is: Weak entity
109. Which is proper subset designed to support ‘views belonging to different classes of users in order to hid or protect information:
Correct Answer is: Subschema
110. For some relations, changing the data can have undesirable consequences called:
Correct Answer is: Modification anomalies.
111. Which is a bottom-up approach to database design that design by examining the relationship between attributes:
Correct Answer is: Normalization
112. Which is the process of breaking a relation into multiple relations:
Correct Answer is: Decomposition
113. …………… is used to determine whether of a table contains duplicate rows.
Correct Answer is: Unique predicate
114. Which of the following is a Data Model?
Correct Answer is: All of the above
115. The main interface that a naive user uses is a form interface using………………
Correct Answer is: GUI
116. In a ……………… lock, the DBMS will lock an entire disk page.
Correct Answer is: page-level
117. PJNF stands form:
Correct Answer is: Project –join normal form
118. …………….is the complex search criteria in the where clause.
Correct Answer is: Predicate
119. …………..defines the structure of a relation which consists of a fixed set of attribute-domain pairs.
Correct Answer is: Schema
120. DBMS is a collection of ………… that enables user to create and maintain a database.
