Database Management System - DBMS Multiple Choice Questions and Answers for Practice

16. An attribute is a(n):

1. row of a table
2. column of a table
3. key of a table
4. two dimensional table

17. Retrieval of data is done by using a………………

1. Query
2. All of these
3. Linked list
4. Stack

18. Which of the following is not a level of data abstraction?

1. Critical Level
2. View Level
3. Logical Level
4. Physical Level

19. In which ways two tables may be related:

1. One-many
2. All of these
3. Many-many
4. One-one

20. A data dictionary is a repository that manages ………………

1. Memory
2. All of these
3. Metadata
4. Database

21. …………… database is used as template for all databases

1. Master
2. Tempdb
3. Model
4. Create

22. The DBMS utility..................... allows reconstructing the correct state of database from the backup and history of transactions.

1. Recovery
2. Data loading
3. Monitoring
4. Backup

23. The DBMSutility,………………allows to reconstruct the correct state of database from the backup and history of transactions.

1. Recovery
2. Data loading
3. Monitoring
4. Backup

24. An outstanding functionality of SQL is its support for automatic ………… to the target data.

1. Functioning
2. Notification
3. Navigation
4. Programming

25. A ……………… does not have a distinguishing attribute if its own and mostly are dependent entities, which are part of some another entity.

1. Strong entity
2. Dependent entity
3. Non attributes entity
4. Weak entity

26. Which is proper subset designed to support ‘views belonging to different classes of users in order to hid or protect information:

1. Subschema
2. None-subschema
3. Non-schema
4. Schema

27. For some relations, changing the data can have undesirable consequences called:

1. Modification anomalies.
2. Transitive dependencies.
3. Normal forms.
4. Referential integrity constraints.

28. Which is a bottom-up approach to database design that design by examining the relationship between attributes:

1. Database modeling
2. Decomposition
3. Normalization
4. Functional dependency

29. Which is the process of breaking a relation into multiple relations:

1. Database modeling
2. Decomposition
3. Normalization
4. Functional dependency

30. …………… is used to determine whether of a table contains duplicate rows.

1. Like Predicate
2. In predicate
3. Null predicate
4. Unique predicate