Database Management System - DBMS Quiz | Database Management System - DBMS Question and Answer for Practice

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