1. Storing data and meta-data separately makes RDBMS general-purpose and flexible.
- True
- False
Answer :- A
2. “Data Model” is nothing but a data structure where data is stored.
- True
- False
Answer :- B
3. An RDBMS can typically manage more than one database.
- True
- False
Answer :- A
4. A database can not be created unless an RDBMS is used.
- True
- False
Answer :- B
5. Relational data model provides the concept of “Entity”.
- True
- False
Answer :- B
6. ER Model is NOT a representational-level data model.
- True
- False
Answer :- A
7. Three-schema architecture is part of the Entity-Relationship Data Model.
- True
- False
Answer :- B
8. Transaction Manager takes control of the system when it recovers after a failure.
- True
- False
Answer :- B
9. People who make use of application programs need to know the logical schema of the database completely.
- True
- False
Answer :- B
10. People who develop the application programs need not know the physical schema of the database.
- True
- False
Answer :- B
11. People who develop the application programs need to know the logical schema of the database completely.
- True
- False
Answer :- A
12. A “log” in the RDBMS keeps track of update operations of all transactions.
- True
- False
Answer :- A
13. Complete the sentence: Logical Data Independence is the ability to modify…
- physical-level schema without affecting the logical-level schema
- the logical-level schema with no effect on view-level schema.
- view-level schema without affecting logical-level schema.
- logical-level schema without affecting physical-level schema.
Answer :- B (the logical-level schema with no effect on view-level schema.)
14. Complete the sentence: Physical Data Independence is the ability to modify…
- physical-level schema without affecting the logical-level schema
- the logical-level schema with no effect on view-level schema.
- view-level schema without affecting logical-level schema.
- logical-level schema without affecting physical-level schema.
Answer :- A (physical-level schema without affecting the logical-level schema)
15. An Entity-Relationship (ER) Model represents:
- The various entity types of interest and the relationships among them in the domain being modeled.
- Various tables and links among them in the domain being modeled.
- The various entity types of interest and the relationships among them in the domain being modeled along with operations to be performed on data.
- Various tables and links among them in the domain being modeled along with operations to be performed on data.
Answer :- A (The various entity types of interest and the relationships among them in the domain being modeled.)
16. A person who develops a high-level language program that meets a functional requirement of the database is usually called:
- A naive user
- An application programmer
- A data analyst
- A DB administrator
Answer :- B (An application programmer)
17. The people playing the following role need NOT have an understanding of the complete logical schema of the database:
- Data-entry Operator
- Application Programmer
- Data Analyst
- Database Administrator
Answer :- A (Data-entry Operator)
18.Consider the following statements:
S1: A view usually provides access to a part of the data relevant to a group of users
S2: A view usually provides access to the complete database
S3: The feature of defining views is to be compulsorily provided by the RDBMS
S4: The feature of defining views may not be provided by an RDBMS.
Choose the correct option:
- S1 and S3 are TRUE
- S1 and S4 are TRUE
- S2 and S3 are TRUE
- S2 and S4 are TRUE
Answer :- B (S1 and S4 are TRUE)
19.Consider the following sets:
M = { p: RDBMS Run-time System; q: Transaction Manager; r: Buffer Manager;
s: Recovery Manager}
F = { w: Transaction Error Handling; x: Concurrency Control; y: Query Execution; z: Paging}
What is the most appropriate matching between sets M and F?
- p — y; q — x; r — z; s — w;
- p — z; q — w; r — y; s — x;
- p — y; q — z; r — x; s — w;
- p — w; q — x; r — z; s — y;
Answer :- p -- y; q -- x; r -- z; s -- w;