Database Management System - DBMS MCQs Quiz Multiple Choice Questions & Answers

1. If an attribute of a composite key is dependent on an attribute of the other composite key, normalization called ----------------- is needed

1. Fourth
2. DKNF
3. BCNF
4. Third

2. A relation is in this form if it is in BCNF and has no multivalued dependencies:

1. Fourth normal form.
2. Second normal form.
3. Third normal form
4. Domain/key normal form.

3. ……………..specifies a search condition for a group or an aggregate.

1. FROM Clause
2. GROUP BY Clause
3. HAVING Clause
4. WHERE Clause

4. ……………..specifies a search condition for a group or an aggregate.

1. FROM Clause
2. GROUP BY Clause
3. HAVING Clause
4. WHERE Clause

5. ………………….operator is basically a join followed by a project on the attributes of first relation.

1. Full Join
2. Join
3. Semi-Join
4. Inner Join

6. FD stands for:

1. Functional data
2. Functional dependency
3. Facilitate dependency
4. Facilitate data

7. The different classes of relations created by the technique for preventing modification anomalies are called:

1. Functional dependencies.
2. Normal forms.
3. Referential integrity constraints.
4. None of the above

8. ……………… clause is an additional filter that is applied to the result.

1. Having
2. Select
3. Group-by
4. Order by

9. In which model of database data is stored in tables:

1. Hierarchical model
2. Network model
3. Relational model
4. None of these

10. The .................... is essentially used to search for patterns in target string.

1. In Predicate
2. Like Predicate
3. Null Predicate
4. Out Predicate

11. ……………… defines rules regarding the values allowed in columns and is the standard mechanism for enforcing database integrity.

1. Index
2. Column
3. Constraint
4. Trigger

12. ……………….contains information that defines valid values that are stored in a column or data type.

1. Index
2. View
3. Rule
4. Default

13. The data in the database at a particular moment in time is called a ………………

1. Initial state
2. Database state
3. Valid state
4. Empty state

14. ACID properties of transactions are

1. Isolation
2. Atomicity
3. Consistency
4. Durability

15. If several concurrent transactions are executed over the same data set and the second transaction updates the database before the first transaction is finished, the ____ property is violated and the database is no longer consistent.

1. isolation
2. atomicity
3. consistency
4. Durability

16. An attribute is a(n):

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

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

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

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

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

19. In which ways two tables may be related:

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

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

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

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

31. Which of the following is a Data Model?

1. Object-Based data model
2. Entity-Relationship model
3. Relational data model
4. All of the above

32. The main interface that a naive user uses is a form interface using………………

1. OLAP
2. DDL
3. GUI
4. DML

33. In a ……………… lock, the DBMS will lock an entire disk page.

1. page-level
2. database-level
3. table-level
4. row-level

34. PJNF stands form:

1. Pages –join normal form
2. Practically –join normal form
3. Project –join normal form
4. programming –join normal form

35. …………….is the complex search criteria in the where clause.

1. Predict
2. Substring
3. Drop Table
4. Predicate

36. …………..defines the structure of a relation which consists of a fixed set of attribute-domain pairs.

1. Program
2. Instance
3. Schema
4. Super Key

37. DBMS is a collection of ………… that enables user to create and maintain a database.

1. Programs
2. Keys
3. Translators
4. Language Activity

38. Which of the following is not unary operation?

1. Project
2. Select
3. Union
4. Rename

39. In a relational schema, each tuple is divided into fields called

1. Queries
2. Relations
3. Domains
4. All of the above

40. Which of the following is Database Language?

1. Query Language
2. Data Definition Language
3. Data Manipulation Language
4. All of the above

41. When a program is abnormally terminated, the equivalent of a ……………… command occurs.

1. QUIT
2. COMMIT
3. ROLLBACK
4. EXIT

42. The method of access which uses key transformation is known as

1. Random
2. Direct
3. Hashing
4. Sequential

43. Which rules are defined in relational models they from as an essential part of any relation database:

1. Record
2. Integrity rules
3. Database
4. Memory

44. When the values in one or more attributes being used as a foreign key must exist in another set of one or more attributes in another table, we have created a(n):

1. Referential integrity constraint.
2. Transitive dependency
3. Insertion anomaly.
4. Normal form

45. A top-to-bottom relationship among the items in a database is established by a

1. Relational Schema
2. Hierarchical schema
3. Network schema
4. All of the above

46. A functional dependency is a relationship between or among:

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

47. In RDBMS, Data is presented as a collection of ............

1. Relations
2. Table
3. Attributes
4. Entities

48. In RDBMS, Data is presented as a collection of............

1. Relations
2. Table
3. Attributes
4. Entities

49. The relational model is based on the concept that data is organized and stored in two-dimensional tables called ……………………….

1. Relations
2. Fields
3. Records
4. Keys

50. In an ER model, …………… is described in the database by storing its data.

1. Relationship
2. Entity
3. Attribute
4. Notation