DBMS Exam: MCQ Quiz! Trivia
(125).jpg "DBMS Exam: MCQ Quiz! Trivia")
.
- 1.-------------------------------responsible for authorizing access to the database, for coordinating and monitoring its use, acquiring software, and hardware resources, controlling its use, and monitoring efficiency of operations.
- A.
Authorization Manager
- B.
Storage Manager
- C.
File Manager
- D.
Transcation Manager
- E.
Buffer Manager
- 2.------------------------------is a property that describes various characteristics of an entity.
- A.
ER Diagram
- B.
Column
- C.
Relationship
- D.
Attribute
- 3.---------------------- level describes what data is stored in the database and the relationships among the data.
- A.
Physical Level
- B.
Logical Level
- C.
Conceptual Level
- D.
None of the above
- 4.------------------------ denote derived attributes.
- A.
Double ellipse
- B.
Dashed ellipse
- C.
Squared ellipse
- D.
Ellipse with attribute name underlined
- 5.A_____________is an association between entities.
- A.
Relation
- B.
One to One
- C.
Generalization
- D.
Specialization
- 6.--------------------------- stores metadata about the structure of the database.
- A.
Physical data base
- B.
Query Analyzer
- C.
Data Dictionary
- D.
Data Catalog
- 7.___________is a collection of operations that perform s single logical function in a database application.
- A.
Transaction
- B.
Concurrent operation
- C.
Atomocity
- D.
Durability
- 8.The problem that is compounded when constraints involve several data items from different files are called _____________
- A.
Transaction Control Management Problem
- B.
Security Problem
- C.
Integrity Problem
- D.
Durability Problem
- 9.Ensuring atomicity is the responsibility of the --------------------------component.
- A.
File Manager
- B.
Buffer Manager
- C.
DBA
- D.
Transation Manager
- 10.-------------------manages the allocation of the space on the disk storage and the database structure used to represent information stored on disk.
- A.
Disk Manager
- B.
File Manager
- C.
Buffer Manager
- D.
Memory Manager
- E.
None of the above
- 11.----------------------------is the minimal super key.
- A.
Primary Key
- B.
Candidate Key
- C.
Surrogate Key
- D.
Unique Key
- E.
Alternate Key
- 12.The -----------------------------engine executes low-level instructions generated by the DML compiler.
- A.
DDL Analyzer
- B.
Query Interpreter
- C.
Database Engine
- D.
None of the above
- 13.--------------------------responsible to define the content, the structure, the constraints, and functions or transactions against the database.
- A.
Transcation Manager
- B.
Query Analyzer
- C.
DBA
- D.
All the above
- E.
None of the above
- 14.In the ER model ---------------------------denote derived attributes.
- A.
Double ellipse
- B.
Diamond
- C.
Reactangle
- D.
None of the above
- 15.--------------------attributes can be divided into parts.
- 16.Foreign Key can be null.
- A.
TRUE
- B.
FALSE
- 17.All primary keys should be super keys.
- A.
TRUE
- B.
FALSE
- 18.In a Relational database, Data is stored as record types and the relationship is represented by set types.
- A.
True
- B.
False
- 19.In a Hierarchical database to get to a low-level table, you start at the root and work your way down the tree until you reach your target data.
- A.
True
- B.
False
- 20.Using the relational model we design conceptual database design.
- A.
True
- B.
False
- 21.The conceptual data model is the source of information for the logical design phase.
- A.
True
- B.
False
- 22.Logical database design describes base relations, file organizations, and indexes that are used to achieve efficient access to data.
- A.
True
- B.
False
- 23.Conceptual data modeling uses a high-level data modeling concept of E-R Models.
- A.
True
- B.
False
- 24.Tables are required to have at least one column.
- A.
True
- B.
False
- 25.Logical data independence: Refers to the separation of the external views from the conceptual view.
- A.
True
- B.
False
Back to top