Top 1000+ Solved DataBase Management System (DBMS) MCQ Questions Answer
Q. Which mapping exists between the external and conceptual levels:
a. Conceptual
b. External
c. Both
d. None
Q. The related and interconnected software components of a DBMS are described by the _______:
a. Logical architecture
b. Physical architecture
c. Both
d. None
Q. Which are the types of physical DBMS architecture can be split :
a. Back end
b. Front end
c. Both
d. None
Q. The overall description of a database is called______:
a. Data definition
b. Data manipulation
c. Data integrity
d. Database schema
Q. Which is proper subset designed to support ‘views’ belonging to different classes of users in order tohid or protect information:
a. Schema
b. Subschema
c. Non-schema
d. None-subschema
Q. A data dictionary is a repository that manages _____:
a. Database
b. Memory
c. Metadata
d. All of these
Q. A tuple is a(n):
a. column of a table
b. two dimensional table
c. row of a table
d. key of a table
Q. An attribute is a(n):
a. two dimensional table
b. row of a table
c. key of a table
d. column of a table
Q. The method of access which uses key transformation is known as
a. Direct
b. Hashing
c. Random
d. Sequential
Q. The statement in SQL which allows to change the definition of a table is
a. Create
b. Alter
c. Select
d. Update
Q. Which of the following is NOT a basic element of all versions of the E-R model?
a. Entities
b. Relationships
c. Attributes
d. Primary key
Q. The SQL command to creating a table is:
a. Make table
b. Alter table
c. Create table
d. Define table