Que: 1. Which of the following is not a level of data abstraction?
|
| a. Physical Level |
| b. Critical Level |
| c. Logical Level |
| d. View Level |
Que: 2. Which of the following is not an Schema?
|
| a. Database Schema |
| b. Physical Schema |
| c. Critical Schema |
| d. Logical Schema |
Ans: (c). Critical Schema
Que: 3. Which of the following is a Data Model?
|
| a. Entity-Relationship model |
| b. Relational data model |
| c. Object-Based data model |
| d. All of the above |
Ans: (d). All of the above
Que: 4. Logical design of database is called
|
| a. Database Instance |
| b. Database Snapshot |
| c. Database Schema |
| d. All of the above |
Ans: (c). Database Schema
Que: 5. Snapshot of the dta in the database at a given instant of time is called
|
| a. Database Schema |
| b. Database Instance |
| c. Database Snapshot |
| d. All of the above |
Ans: (b). Database Instance
Que: 6. Which of the following is the structure of the Database?
|
| a. Table |
| b. Schema |
| c. Relation |
| d. None of these |
Que: 7. A logical description of some portion of database that is required by a user to perform task is called as
|
| a. System View |
| b. User View |
| c. Logical View |
| d. Data View |
Que: 8. _____________ is a classical approach to database design?
|
| a. Left – Right approach |
| b. Right – Left approach |
| c. Top – Down approach |
| d. Bottom – Up approach |
Ans: (c). Top – Down approach
Que: 9. Which of the following is the oldest database model?
|
| a. Relational |
| b. Hierarchical |
| c. Physical |
| d. Network |
Que: 10. Which of the following indicates the maximum number of entities that can be involved in a relationship?
|
| a. Minimum cardinality |
| b. Maximum cardinality |
| c. ERD |
| d. Greater Entity Count (GEC) |
Ans: (b). Maximum cardinality