McqMate
Chapters
1101. |
Consequently R.Boyce-Codd jointly launched powerful definition for the third normal form called______: |
A. | Boyce-Codd normal form |
B. | First normal form |
C. | Second normal form |
D. | All of these |
Answer» A. Boyce-Codd normal form |
1102. |
BCNF stands for: |
A. | Basic -Codd normal form |
B. | Build -Codd normal form |
C. | Boyce-Codd normal form |
D. | None of these |
Answer» C. Boyce-Codd normal form |
1103. |
Which forms simplifies and ensures that there is minimal data aggregates and repetitive groups: |
A. | 1NF |
B. | 2NF |
C. | 3NF |
D. | All of these |
Answer» A. 1NF |
1104. |
Which forms every non-prime attribute is fully dependent functionally on the candidate key of a relational schema: |
A. | 1NF |
B. | 2NF |
C. | 3NF |
D. | 5NF |
Answer» B. 2NF |
1105. |
PJNF stands form: |
A. | Practically –join normal form |
B. | Project –join normal form |
C. | Pages –join normal form |
D. | programming –join normal form |
Answer» B. Project –join normal form |
1106. |
Which forms are based on the concept of functional dependency |
A. | 1NF |
B. | 2NF |
C. | 3NF |
D. | 4NF |
Answer» C. 3NF |
1107. |
The DBMS utility, ____________ allows to reconstruct the correct state of database from the backup and history of transactions. |
A. | Backup |
B. | Recovery |
C. | Monitoring |
D. | Data loading |
Answer» B. Recovery |
1108. |
In the ........... normal form, a composite attribute is converted to individual attributes. |
A. | First |
B. | Second |
C. | Third |
D. | Fourth |
Answer» A. First |
1109. |
In RDBMS, Data is presented as a collection of ............ |
A. | Table |
B. | Attributes |
C. | Relations |
D. | Entities |
Answer» C. Relations |
1110. |
A .................. normal form, normalization will be needed where all attributes in a relation are not functionally dependent only on the key attribute. |
A. | First |
B. | Second |
C. | Third |
D. | Fourth |
Answer» C. Third |
1111. |
To select all column from the table the syntax is: |
A. | Select all from table_name |
B. | Select * from table_name |
C. | Select from table_name |
D. | Non of the above |
Answer» B. Select * from table_name |
1112. |
For using a specific database …………… command is used. |
A. | use database |
B. | databasename use |
C. | Both A &B |
D. | None of them |
Answer» A. use database |
1113. |
………………… is a special type of integrity constraint that relates two relations & maintains consistency across the relations. |
A. | Entity Integrity Constraints |
B. | Referential Integrity Constraints |
C. | Domain Integrity Constraints |
D. | Key Constraints |
Answer» B. Referential Integrity Constraints |
1114. |
____ ensures that once transaction changes are done, they cannot be undone or lost, even in the event of a system failure. |
A. | Atomicity |
B. | Consistency |
C. | Durability |
D. | Isolation |
Answer» C. Durability |
1115. |
Deadlocks are possible only when one of the transactions wants to obtain a(n) ____ lock on a data item. |
A. | binary |
B. | exclusive |
C. | shared |
D. | Complete |
Answer» B. exclusive |
1116. |
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. |
A. | atomicity |
B. | consistency |
C. | isolation |
D. | Durability |
Answer» C. isolation |
1117. |
A DBMS uses a transaction ____ to keep track of all transactions that update the database |
A. | log |
B. | table |
C. | block |
D. | Statement |
Answer» A. log |
1118. |
When a program is abnormally terminated, the equivalent of a ____ command occurs. |
A. | COMMIT |
B. | ROLLBACK |
C. | QUIT |
D. | EXIT |
Answer» A. COMMIT |
1119. |
In a(n) ____ backup of the database, only the last modifications to the database are copied. |
A. | full |
B. | incomplete |
C. | differential |
D. | transaction log |
Answer» C. differential |
1120. |
Although the ____ locking approach improves the availability of data, its management requires high overhead. |
A. | database-level |
B. | table-level |
C. | page-level |
D. | row-level |
Answer» D. row-level |
1121. |
A(n) ____ lock exists when concurrent transactions are granted Read access on the basis of a common lock. |
A. | binary |
B. | field-level |
C. | shared |
D. | Exclusive |
Answer» C. shared |
1122. |
A ____ database state is one in which all data integrity constraints are satisfied. |
A. | fixed |
B. | complete |
C. | consistent |
D. | Secure |
Answer» C. consistent |
1123. |
The ____ statement is used to end a successful transaction. |
A. | COMMIT |
B. | DONE |
C. | END |
D. | QUIT |
Answer» A. COMMIT |
1124. |
____ means that the data used during the execution of a transaction cannot be used by a second transaction until the first one is completed. |
A. | Atomicity |
B. | Consistency |
C. | Durability |
D. | Isolation |
Answer» D. Isolation |
1125. |
The three basic techniques to control deadlocks are: deadlock ____, deadlock detection, and deadlock avoidance. |
A. | prevention |
B. | prohibition |
C. | rollback |
D. | Commits |
Answer» A. prevention |
1126. |
All transactions are controlled and executed by the DBMS (subject to some limitations) to guarantee database ____. |
A. | integrity |
B. | uniqueness |
C. | consistency |
D. | Design |
Answer» A. integrity |
1127. |
In a ____ lock, the DBMS will lock an entire disk page. |
A. | database-level |
B. | table-level |
C. | page-level |
D. | row-level |
Answer» C. page-level |
1128. |
According to the ANSI SQL standard, when does a transaction begin? |
A. | with use of the START command |
B. | when the first SQL statement is encountered |
C. | with the BEGIN command |
D. | with the BEGIN TRANSACTION command |
Answer» B. when the first SQL statement is encountered |
1129. |
The ____ lock allows concurrent transactions to access the same row as long as they require the use of different fields within that row. |
A. | table-level |
B. | page-level |
C. | row-level |
D. | field-level |
Answer» D. field-level |
1130. |
What is ACID properties |
A. | Atomicity |
B. | Consistency |
C. | Isolation |
D. | All of the above |
Answer» D. All of the above |
1131. |
Which refers to a property of computer to run several operation simultaneously and possible as computers await response of each other: |
A. | Concurrency |
B. | Deadlock |
C. | Backup |
D. | Recovery |
Answer» A. Concurrency |
1132. |
Which is refers to a stalemate situation due to which no further progress is possible as computer await response of each other: |
A. | Concurrency |
B. | Deadlock |
C. | Backup |
D. | Recovery |
Answer» B. Deadlock |
1133. |
Which is a duplicate copy of a file program that is stored on a different storage media than the original location: |
A. | Concurrency |
B. | Deadlock |
C. | Backup |
D. | Recovery |
Answer» C. Backup |
1134. |
............... joins are SQL server default |
A. | Outer |
B. | Inner |
C. | Equi |
D. | None of the above |
Answer» B. Inner |
1135. |
The ..................... is essentially used to search for patterns in target string. |
A. | Like Predicate |
B. | Null Predicate |
C. | In Predicate |
D. | Out Predicate |
Answer» A. Like Predicate |
1136. |
................. requires that data should be made available to only authorized users. |
A. | Data integrity |
B. | Privacy |
C. | Security |
D. | None of the above |
Answer» C. Security |
1137. |
.............. is a combination of two of more attributes used as a primary key |
A. | Composite Key |
B. | Alternate Key |
C. | Candidate Key |
D. | Foreign Key |
Answer» A. Composite Key |
1138. |
To delete a database ................... command is used |
A. | delete database database_name |
B. | Delete database_name |
C. | drop database database_name |
D. | drop database_name |
Answer» C. drop database database_name |
1139. |
Some of the utilities of DBMS are ............. i) Transaction ii) Backup iii) File organization iv) Process Organization |
A. | i, ii, and iv only |
B. | i, ii and iii only |
C. | ii, iii and iv only |
D. | All i, ii, iii, and iv |
Answer» C. ii, iii and iv only |
1140. |
There are _________ number of Normal forms that has been defined |
A. | 5 |
B. | 6 |
C. | 4 |
D. | 3 |
Answer» B. 6 |
1141. |
The primary key must be |
A. | Unique |
B. | Not Null |
C. | Both A & B |
D. | None of these |
Answer» C. Both A & B |
1142. |
Which of the following is not unary operation? |
A. | Select |
B. | Union |
C. | Project |
D. | Rename |
Answer» B. Union |
1143. |
Which is relation calculus: |
A. | Tuple relational calculus |
B. | Domain relational calculus |
C. | Both |
D. | None |
Answer» C. Both |
1144. |
Which calculus is based on specifying a number of tuple variables: |
A. | Tuple relation calculus |
B. | Domain relational calculus |
C. | Both |
D. | None |
Answer» A. Tuple relation calculus |
1145. |
SQL outputs a single table known as the ______: |
A. | View |
B. | Column |
C. | Tablespace |
D. | Result set |
Answer» D. Result set |
1146. |
Which of the following is related to information? |
A. | Data |
B. | Communication |
C. | Knowledge |
D. | All of these |
Answer» A. Data |
1147. |
Data is: |
A. | A piece of fact |
B. | Metadata |
C. | Information |
D. | None of these. |
Answer» A. A piece of fact |
1148. |
Which of the following is element of the database? |
A. | Data |
B. | Constraints and schema |
C. | Relationships |
D. | All of these. |
Answer» D. All of these. |
1149. |
What represent a correspondence between the various data elements? |
A. | Data |
B. | Constraints |
C. | Relationships |
D. | Schema |
Answer» C. Relationships |
1150. |
Which of the following is an advantage of using database system? |
A. | Security enforcement |
B. | Avoidance of redundancy |
C. | Reduced inconsistency |
D. | All of these. |
Answer» D. All of these. |
1151. |
Which of the following is characteristic of the data in a database? |
A. | Independent |
B. | Secure |
C. | Shared |
D. | All of these. |
Answer» D. All of these. |
1152. |
Relationships could be of the following type: |
A. | One-to-one relationship |
B. | One-to-many relationships |
C. | Many-to-many relationships |
D. | All of these. |
Answer» D. All of these. |
1153. |
In a file-oriented system there is: |
A. | Data inconsistency |
B. | Duplication of data |
C. | Data independence |
D. | Al of these. |
Answer» D. Al of these. |
1154. |
In a database system there is: |
A. | Increased productivity |
B. | Improved security |
C. | Economy of scale |
D. | All of these. |
Answer» D. All of these. |
1155. |
VDL is used to specify: |
A. | Internal schema |
B. | External schema |
C. | Conceptual schema |
D. | None of these. |
Answer» D. None of these. |
1156. |
The DML provides following functional access to the database: |
A. | Retrieve data and/or records |
B. | Add (or insert) records |
C. | Delete records from database files |
D. | All of these |
Answer» B. Add (or insert) records |
1157. |
4GL has the following components inbuilt in it: |
A. | Query languages |
B. | Report generators |
C. | Spreadsheets |
D. | All of these. |
Answer» D. All of these. |
1158. |
Which of the following is database element? |
A. | Data |
B. | Constraints and schema |
C. | Relationships |
D. | All of these. |
Answer» D. All of these. |
1159. |
What separates the physical aspects of data storage from the logical aspects of data representation? |
A. | Data |
B. | Schema |
C. | Constraints |
D. | Relationships |
Answer» D. Relationships |
1160. |
What scheme defines how and where the data are organized in a physical data storage? |
A. | External |
B. | Internal |
C. | Conceptual |
D. | None of these. |
Answer» A. External |
1161. |
Which of the following schemas defines the stored data structures in terms of the database model used? |
A. | External |
B. | Conceptual |
C. | Internal |
D. | None of these |
Answer» B. Conceptual |
1162. |
Which of the following schemas defines a view or views of the database for particular users? |
A. | External |
B. | Conceptual |
C. | Internal |
D. | None of these |
Answer» B. Conceptual |
1163. |
A collection of data designed to be used by different people is called. |
A. | Database |
B. | RDBMS |
C. | DBMS |
D. | None of these |
Answer» A. Database |
1164. |
Which of the following is an object-oriented feature? |
A. | Inheritance |
B. | Abstraction |
C. | Polymorphism |
D. | All of these |
Answer» B. Abstraction |
1165. |
A physical data models are used to |
A. | Specify overall logical structure of the database |
B. | Describe data and its relationships |
C. | Higher-level description of storage structure and access mechanism |
D. | All of these |
Answer» D. All of these |
1166. |
Which data model organizes the data in the form of tables and relations? |
A. | Relational Model |
B. | Hierarchical Model |
C. | Network Model |
D. | none of the above |
Answer» A. Relational Model |
1167. |
Which company has developed the hierarchical model? |
A. | Oracle |
B. | IBM |
C. | Sun MicroSystems |
D. | Microsoft |
Answer» B. IBM |
1168. |
The name of the system database that contains descriptions of data in the database is |
A. | Data dictionary |
B. | Metadata |
C. | Table |
D. | None of these |
Answer» B. Metadata |
1169. |
System catalog is a system-created database that describes: |
A. | Database objects |
B. | Data dictionary information |
C. | User access information |
D. | All of these |
Answer» D. All of these |
1170. |
Following is the type of metadata: |
A. | Operational |
B. | EDW |
C. | Data mart |
D. | All of these |
Answer» D. All of these |
1171. |
What is refined data? |
A. | Knowledge |
B. | Information |
C. | Statistics |
D. | None of the above |
Answer» B. Information |
1172. |
Which of the following is a database element? |
A. | Data |
B. | Relationships |
C. | Constraints and Schema |
D. | All of the above |
Answer» D. All of the above |
1173. |
What defines how and where data are organized in physical data storage? |
A. | Internal schema |
B. | External schema |
C. | Conceptual schema |
D. | None of the above |
Answer» A. Internal schema |
1174. |
What defines a view or views of the database for particular users? |
A. | Internal schema |
B. | External schema |
C. | Conceptual schema |
D. | None of the above |
Answer» B. External schema |
1175. |
To access information from a database, you need a ___________ |
A. | EIS |
B. | DBMS |
C. | MIS |
D. | None of the above |
Answer» B. DBMS |
1176. |
Which of the following is an advantage of a database? |
A. | Reduction in Redundancy |
B. | Avoidance of inconsistency |
C. | Security enforcement |
D. | All of the above |
Answer» D. All of the above |
1177. |
Which of the following is an example of a database application? |
A. | Computerized library systems |
B. | ATMs |
C. | Flight reservation systems |
D. | All of the above |
Answer» D. All of the above |
1178. |
DBMS stands for________________? |
A. | Data blocking and Management Systems |
B. | Database Management Systems |
C. | Database Business Management Systems |
D. | None of the above |
Answer» B. Database Management Systems |
1179. |
What is the name of the system database that contains descriptions of the data in the database? |
A. | Metadata |
B. | Data dictionary |
C. | Table |
D. | None of the above |
Answer» B. Data dictionary |
1180. |
IMS stands for ___________ |
A. | Information Management System |
B. | Internal Mechanical Security |
C. | International Managers Society |
D. | None of the above |
Answer» A. Information Management System |
1181. |
Which of the following is the oldest database model? |
A. | Hierarchical |
B. | Network |
C. | Relational |
D. | Object Oriented |
Answer» A. Hierarchical |
1182. |
Which category of users need not be aware of the presence of the database system? |
A. | DBA |
B. | Naive |
C. | Casual |
D. | Application Programmers |
Answer» B. Naive |
1183. |
Database __________ , which is the logical design of the database, and the database _______,which is a snapshot of the data in the database at a given instant in time. |
A. | Instance, Schema |
B. | Relation, Schema |
C. | Relation, Domain |
D. | Schema, Instance |
Answer» D. Schema, Instance |
1184. |
Course(course_id,sec_id,semester) Here the course_id,sec_id and semester are __________ and course is a _________ . |
A. | Relations, Attribute |
B. | Attributes, Relation |
C. | Tuple, Relation |
D. | Tuple, Attributes |
Answer» B. Attributes, Relation |
1185. |
Department (dept name, building, budget) and Employee (employee_id , name, deptname,salary) Here the dept_name attribute appears in both the relations .Here using common attributes in relation schema is one way of relating ___________ relations. |
A. | Attributes of common |
B. | Tuple of common |
C. | Tuple of distinct |
D. | Attributes of distinct |
Answer» C. Tuple of distinct |
1186. |
A domain is atomic if elements of the domain are considered to be ____________ units. |
A. | Different |
B. | Indivisbile |
C. | Constant |
D. | Divisible |
Answer» B. Indivisbile |
1187. |
Which of the following products was an early implementation of the relational model developed by E.F. Codd of IBM? |
A. | IDMS |
B. | DB2 |
C. | dBase-II |
D. | R:base |
Answer» B. DB2 |
1188. |
The following are components of a database except ________ |
A. | user data |
B. | Metadata |
C. | Reports |
D. | Indexes |
Answer» C. Reports |
1189. |
An application where only one user accesses the database at a given time is an example of a(n) ________ . |
A. | single-user database application |
B. | multiuser database application |
C. | e-commerce database application |
D. | data mining database application |
Answer» A. single-user database application |
1190. |
An on-line commercial site such as Amazon.com is an example of a(n) ________ . |
A. | single-user database application |
B. | multiuser database application |
C. | e-commerce database application |
D. | data mining database application |
Answer» C. e-commerce database application |
1191. |
SQL stands for ________ . |
A. | Structured Query Language |
B. | Sequential Query Language |
C. | Structured Question Language |
D. | Sequential Question Language |
Answer» A. Structured Query Language |
1192. |
Because it contains a description of its own structure, a database is considered to be ________ |
A. | Described |
B. | metadata compatible |
C. | self-describing |
D. | an application program |
Answer» C. self-describing |
1193. |
The following are functions of a DBMS except ________ . |
A. | creating and processing forms |
B. | creating databases |
C. | processing data |
D. | administrating databases |
Answer» A. creating and processing forms |
1194. |
Helping people keep track of things is the purpose of a(n) ________ . |
A. | Database |
B. | Table |
C. | Instance |
D. | Relationship |
Answer» A. Database |
1195. |
A DBMS that combines a DBMS and an application generator is ________ . |
A. | Microsoft's SQL Server |
B. | Microsoft's Access |
C. | IBM's DB2 |
D. | Oracle Corporation's Oracle |
Answer» B. Microsoft's Access |
1196. |
Let us consider phone_number ,which can take single or several values . Treating phone_numberasan _________ permits instructors to have several phone numbers (including zero) associated with them. |
A. | Entity |
B. | Attribute |
C. | Relation |
D. | Value |
Answer» C. Relation |
1197. |
Given the basic ER and relational models, which of the following is INCORRECT? |
A. | An attribute of an entity can have more than one value |
B. | An attribute of an entity can be composite |
C. | In a row of a relational table, an attribute can have more than one value |
D. | In a row of a relational table, an attribute can have exactly one value or a NULL value |
Answer» A. An attribute of an entity can have more than one value |
1198. |
In an object-oriented model, one object can access data of another object by passing: |
A. | Instance variable |
B. | Message |
C. | Variable |
D. | None of these |
Answer» B. Message |
1199. |
A view of database that appears to an application program is known as: |
A. | Schema |
B. | Subschema |
C. | virtual table |
D. | none of the above |
Answer» B. Subschema |
1200. |
An abstraction concept for building composite object from their component object is called: |
A. | Specialization |
B. | Normalization |
C. | Generalization |
D. | Aggregation |
Answer» D. Aggregation |
Done Reading?