DBMS MCQ Multiple Choice Questions Answers - Page 2 | Quiz for Practice

Q: 16. An entity set that does not have sufficient attributes to form a primary key is a

Correct Answer is: weak entity set.

Q: 17. A DBMS query language is designed to

Correct Answer is: all of the above.

Q: 18. The DBMS language component which can be embedded in a program is

Correct Answer is: The data manipulation language (DML).

Q: 19. Which one of the following statements is false?

Correct Answer is: Data elements in the database can be modified by changing the data dictionary.

Q: 20. A subschema expresses

Correct Answer is: the external view.

Q: 21. A data dictionary is a special file that contains:

Correct Answer is: All of the above.

Q: 23. Hierarchical model is also called

Correct Answer is: Tree structure

Q: 26. Architecture of the database can be viewed as

Correct Answer is: three levels.

Q: 28. Cross Product is a:

Correct Answer is: Binary Operator

Q: 29. Which of the following operations need the participating relations to be unon compatible?

Correct Answer is: All of the above

DBMS MCQ Questions for Practice

16. An entity set that does not have sufficient attributes to form a primary key is a

weak entity set.
simple entity set.
primary entity set.
strong entity set.

17. A DBMS query language is designed to

support in the development of complex applications software.
specify the structure of a database.
all of the above.
support end users who use English-like commands.

18. The DBMS language component which can be embedded in a program is

The data manipulation language (DML).
The database administrator (DBA).
A query language.
The data definition language (DDL).

19. Which one of the following statements is false?

Data elements in the database can be modified by changing the data dictionary.
The data dictionary contains the name and description of each data element.
The data dictionary is a tool used exclusively by the database administrator.
The data dictionary is normally maintained by the database administrator.

20. A subschema expresses

the physical view.
the external view.
all of the above.
the logical view.

21. A data dictionary is a special file that contains:

The width of all fields in all files.
The data type of all fields in all files.
All of the above.
The name of all fields in all files.

22. NULL is

the same as blank for character
the same as 0 for integer and blank for character
not a value
the same as 0 for integer

23. Hierarchical model is also called

Plex Structure
Normalize Structure
Table Structure
Tree structure

24. The RDBMS terminology for a row is

relation.
attribute
degree
tuple.

25. In a relational model, relations are termed as

Attributes
Tables.
Rows.
Tuples.

26. Architecture of the database can be viewed as

four levels.
three levels.
one level.
two levels.

27. What is a relationship called when it is maintained between two entities?

Binary
Ternary
Quaternary
Unary

28. Cross Product is a:

Ternary Operator
Binary Operator
Not an operator
Unary Operator

29. Which of the following operations need the participating relations to be unon compatible?

INTERSECTION
DIFFERENCE
All of the above
UNION

30. To delete a particular column in a relation the command used is:

DROP
ALTER
DELETE
UPDATE