DBMS Multiple Choice Questions and Answers for Practice

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

1. strong entity set.
2. weak entity set.
3. simple entity set.
4. primary entity set.

17. A DBMS query language is designed to

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

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

1. The data definition language (DDL).
2. The data manipulation language (DML).
3. The database administrator (DBA).
4. A query language.

19. Which one of the following statements is false?

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

20. A subschema expresses

1. the logical view.
2. the physical view.
3. the external view.
4. all of the above.

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

1. The name of all fields in all files.
2. The width of all fields in all files.
3. The data type of all fields in all files.
4. All of the above.

22. NULL is

1. the same as 0 for integer
2. the same as blank for character
3. the same as 0 for integer and blank for character
4. not a value

23. Hierarchical model is also called

1. Tree structure
2. Plex Structure
3. Normalize Structure
4. Table Structure

24. The RDBMS terminology for a row is

1. tuple.
2. relation.
3. attribute
4. degree

25. In a relational model, relations are termed as

1. Tuples.
2. Attributes
3. Tables.
4. Rows.

26. Architecture of the database can be viewed as

1. two levels.
2. four levels.
3. three levels.
4. one level.

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

1. Unary
2. Binary
3. Ternary
4. Quaternary

28. Cross Product is a:

1. Unary Operator
2. Ternary Operator
3. Binary Operator
4. Not an operator

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

1. UNION
2. INTERSECTION
3. DIFFERENCE
4. All of the above

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

1. UPDATE
2. DROP
3. ALTER
4. DELETE