Top 1000+ Solved DataBase Management System (DBMS) MCQ Questions Answer
Q. Which of the following is a database element?
a. Data
b. Relationships
c. Constraints and Schema
d. All of the above
Q. What defines how and where data are organized in physical data storage?
a. Internal schema
b. External schema
c. Conceptual schema
d. None of the above
Q. What defines a view or views of the database for particular users?
a. Internal schema
b. External schema
c. Conceptual schema
d. None of the above
Q. To access information from a database, you need a ___________
a. EIS
b. DBMS
c. MIS
d. None of the above
Q. Which of the following is an advantage of a database?
a. Reduction in Redundancy
b. Avoidance of inconsistency
c. Security enforcement
d. All of the above
Q. Which of the following is an example of a database application?
a. Computerized library systems
b. ATMs
c. Flight reservation systems
d. All of the above
Q. DBMS stands for________________?
a. Data blocking and Management Systems
b. Database Management Systems
c. Database Business Management Systems
d. None of the above
Q. What is the name of the system database that contains descriptions of the data in thedatabase?
a. Metadata
b. Data dictionary
c. Table
d. None of the above
Q. IMS stands for ___________
a. Information Management System
b. Internal Mechanical Security
c. International Managers Society
d. None of the above
Q. Which of the following is the oldest database model?
a. Hierarchical
b. Network
c. Relational
d. Object Oriented
Q. Which category of users need not be aware of the presence of the database system?
a. DBA
b. Naive
c. Casual
d. Application Programmers
Q. Database __________ , which is the logical design of the database, and the database _______,which is a snapshot of the data in the database at a given instant in time.
a. Instance, Schema
b. Relation, Schema
c. Relation, Domain
d. Schema, Instance
Q. Course(course_id,sec_id,semester) Here the course_id,sec_id and semester are __________ and course is a _________ .
a. Relations, Attribute
b. Attributes, Relation
c. Tuple, Relation
d. Tuple, Attributes