DBMS Test1
Settings
-
+
This is a test for DBMS fundamentals
- 1.-------------------------------responsible for authorizing access to the database, for co-ordinating 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 data base
- 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 data base 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.
- 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 ER model ---------------------------denote derived attributes
- A.
Double ellipse
- B.
Diamond
- C.
Reactangle
- D.
None of the above
- 15.--------------------attributes can be divided into parts (Write the answer in lowercase)
- 16.Foreign Key can be null
- A.
TRUE
- B.
FALSE
- 17.All primary keys should be super keys.
- A.
TRUE
- B.
FALSE
- 18.In Relational database Data is stored as record types and the relationship is represented by set types
- A.
True
- B.
False
- 19.In 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 relational model we design conceptual database design
- A.
True
- B.
False
- 21.Conceptual data model is the source of information for logical design phase
- A.
True
- B.
False
- 22.Logical database design describes 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
- 26.Duplication of data is the disadvantage of DBMS
- A.
True
- B.
False
- 27.Candidate key can have a null value
- A.
True
- B.
False
- 28.Each program maintains its own set of data. So users of one program may be unaware of potentially useful data held by other programs this leads to Duplication of data
- A.
True
- B.
False
- 29.A traditional database stores just data – with no procedures
- A.
True
- B.
False
- 30.Simple Attribute composed of multiple components, each with an independent existence.
- A.
True
- B.
False
- 31.Cardinality specifies how many instances of an entity relate to one instance of another entity.
- A.
True
- B.
False
Back to top