Top 1000+ Solved DataBase Management System (DBMS) MCQ Questions Answer
Q. VDL is used to specify:
a. Internal schema
b. External schema
c. Conceptual schema
d. None of these.
Q. The DML provides following functional access to the database:
a. Retrieve data and/or records
b. Add (or insert) records
c. Delete records from database files
d. All of these
Q. 4GL has the following components inbuilt in it:
a. Query languages
b. Report generators
c. Spreadsheets
d. All of these.
Q. Which of the following is database element?
a. Data
b. Constraints and schema
c. Relationships
d. All of these.
Q. What separates the physical aspects of data storage from the logical aspects of datarepresentation?
a. Data
b. Schema
c. Constraints
d. Relationships
Q. What scheme defines how and where the data are organized in a physical data storage?
a. External
b. Internal
c. Conceptual
d. None of these.
Q. Which of the following schemas defines the stored data structures in terms of thedatabase model used?
a. External
b. Conceptual
c. Internal
d. None of these
Q. Which of the following schemas defines a view or views of the database for particularusers?
a. External
b. Conceptual
c. Internal
d. None of these
Q. A collection of data designed to be used by different people is called.
a. Database
b. RDBMS
c. DBMS
d. None of these
Q. Which of the following is an object-oriented feature?
a. Inheritance
b. Abstraction
c. Polymorphism
d. All of these
Q. A physical data models are used to
a. Specify overall logical structure of the database
b. Describe data and its relationships
c. Higher-level description of storage structure and access mechanism
d. All of these
Q. Which data model organizes the data in the form of tables and relations?
a. Relational Model
b. Hierarchical Model
c. Network Model
d. none of the above
Q. Which company has developed the hierarchical model?
a. Oracle
b. IBM
c. Sun MicroSystems
d. Microsoft
Q. The name of the system database that contains descriptions of data in the database is
a. Data dictionary
b. Metadata
c. Table
d. None of these
Q. System catalog is a system-created database that describes:
a. Database objects
b. Data dictionary information
c. User access information
d. All of these