Database Management System - DBMS MCQ Quiz - Multiple Choice Questions & Answers Page 3

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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