Database Management System - DBMS Objective Question and Answer
Database Management System - DBMS MCQ Multiple Choice Questions - Page 5 for Practice
121. Which of the following is not unary operation?
Correct Answer is: Union
122. In a relational schema, each tuple is divided into fields called
Correct Answer is: Domains
123. Which of the following is Database Language?
Correct Answer is: All of the above
124. When a program is abnormally terminated, the equivalent of a ……………… command occurs.
Correct Answer is: COMMIT
125. The method of access which uses key transformation is known as
Correct Answer is: Hashing
126. Which rules are defined in relational models they from as an essential part of any relation database:
Correct Answer is: Integrity rules
127. When the values in one or more attributes being used as a foreign key must exist in another set of one or more attributes in another table, we have created a(n):
Correct Answer is: Referential integrity constraint.
128. A top-to-bottom relationship among the items in a database is established by a
Correct Answer is: Hierarchical schema
129. A functional dependency is a relationship between or among:
Correct Answer is: Attributes
130. In RDBMS, Data is presented as a collection of ............
Correct Answer is: Relations
131. In RDBMS, Data is presented as a collection of............
Correct Answer is: Relations
132. The relational model is based on the concept that data is organized and stored in two-dimensional tables called ……………………….
Correct Answer is: Relations
133. In an ER model, …………… is described in the database by storing its data.
Correct Answer is: Entity
134. The three basic techniques to control deadlocks are: deadlock ………………, deadlock detection, and deadlock avoidance.
Correct Answer is: prevention
135. A tuple is a(n):
Correct Answer is: row of a table
136. The……………… lock allows concurrent transactions to access the same row as long as they require the use of different fields within that row.
Correct Answer is: field-level
137. The number of tuples in a relation is called its ………… While the number of attributes in a relation is called its ………………..
Correct Answer is: Cardinality, Degree
138. Which of the following in not a function of DBA?
Correct Answer is: Network Maintenance
139. After conversion of high level queries into low level commands for file access and is called compiled………………
Correct Answer is: DML
140. Which are the not features of a DBMS which provide a number of advantages for data management:
Correct Answer is: None of these
141. Consequently R.Boyce-Codd jointly launched powerful definition for the third normal form called………………
Correct Answer is: Boyce-Codd normal form
142. ................ requires that data should be made available to only authorized users.
Correct Answer is: Security
143. The statement in SQL which allows to change the definition of a table is
Correct Answer is: Alter
144. What is used to retrieve tuples from the relation.
Correct Answer is: Select
145. To select all column from the table the syntax is:
Correct Answer is: Select * from table_name
146. To select all columns from the table the syntax is:
Correct Answer is: Select * from table_name
147. The SQL statement to create a view is:
Correct Answer is: CREATE VIEW
148. System analyst and application programmers are commonly referred to as …………………….
Correct Answer is: Software engineers
149. Which are the not user in End-user:
Correct Answer is: All of these
150. Who access the database occasionally and have different needs each time:
