Database Management System (DBMS)

11. Which level of database is viewed by user:

  1. Internal level
  2. External Level
  3. Conceptual Level
  4. All of these

Correct answer: (B)
External Level

12. Internal level has:

  1. Individual Users View of the database
  2. Community view of the database
  3. Physical Representation of the database
  4. All of these

Correct answer: (C)
Physical Representation of the database

13. Which is the component of database management system:

  1. Query Language
  2. Database Manager
  3. File manager
  4. All of these

Correct answer: (D)
All of these

14. ___________ is the structure of the database.

  1. Table
  2. Relation
  3. Schema
  4. None of these

Correct answer: (C)
Schema

15. Schema is usually stored in ___________ .

  1. Tables
  2. Data Dictionary
  3. Both
  4. None of these

Correct answer: (B)
Data Dictionary

16. Schema is defined by:

  1. DML
  2. DDL
  3. DCL
  4. DQL

Correct answer: (B)
DDL

17. DML language is used to:

  1. Define schema
  2. Define internal level
  3. Access Data
  4. All of these

Correct answer: (C)
Access Data

18. DBMS is the bridge between operating system and ___________ .

  1. User
  2. Database administrator
  3. Application program
  4. None of these

Correct answer: (C)
Application program

19. Which is the most popular database model:

  1. Network Model
  2. Relational Model
  3. Hierarchical Model
  4. Object Oriented

Correct answer: (B)
Relational Model

20. Which is the schema object:

  1. Database links and clusters
  2. Packages and Indexes
  3. Procedures and functions
  4. All of these

Correct answer: (D)
All of these

Page 2 of 45