Database Management System - DBMS Objective Question and Answer
Database Management System - DBMS MCQ Multiple Choice Questions - Page 2 for Practice
Database Management System - DBMS MCQ Questions for Practice
31. Which of the following is a Data Model?
Correct Answer is: All of the above
32. The main interface that a naive user uses is a form interface using………………
Correct Answer is: GUI
33. In a ……………… lock, the DBMS will lock an entire disk page.
Correct Answer is: page-level
34. PJNF stands form:
Correct Answer is: Project –join normal form
35. …………….is the complex search criteria in the where clause.
Correct Answer is: Predicate
36. …………..defines the structure of a relation which consists of a fixed set of attribute-domain pairs.
Correct Answer is: Schema
37. DBMS is a collection of ………… that enables user to create and maintain a database.
Correct Answer is: Programs
38. Which of the following is not unary operation?
Correct Answer is: Union
39. In a relational schema, each tuple is divided into fields called
Correct Answer is: Domains
40. Which of the following is Database Language?
Correct Answer is: All of the above
41. When a program is abnormally terminated, the equivalent of a ……………… command occurs.
Correct Answer is: COMMIT
42. The method of access which uses key transformation is known as
Correct Answer is: Hashing
43. Which rules are defined in relational models they from as an essential part of any relation database:
Correct Answer is: Integrity rules
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):
Correct Answer is: Referential integrity constraint.
45. A top-to-bottom relationship among the items in a database is established by a
Correct Answer is: Hierarchical schema
46. A functional dependency is a relationship between or among:
Correct Answer is: Attributes
47. In RDBMS, Data is presented as a collection of ............
Correct Answer is: Relations
48. In RDBMS, Data is presented as a collection of............
Correct Answer is: Relations
49. The relational model is based on the concept that data is organized and stored in two-dimensional tables called ……………………….
Correct Answer is: Relations
50. In an ER model, …………… is described in the database by storing its data.
Correct Answer is: Entity
51. The three basic techniques to control deadlocks are: deadlock ………………, deadlock detection, and deadlock avoidance.
Correct Answer is: prevention
52. A tuple is a(n):
Correct Answer is: row of a table
53. The……………… lock allows concurrent transactions to access the same row as long as they require the use of different fields within that row.
Correct Answer is: field-level
54. The number of tuples in a relation is called its ………… While the number of attributes in a relation is called its ………………..
Correct Answer is: Cardinality, Degree
55. Which of the following in not a function of DBA?
Correct Answer is: Network Maintenance
56. After conversion of high level queries into low level commands for file access and is called compiled………………
Correct Answer is: DML
57. Which are the not features of a DBMS which provide a number of advantages for data management:
Correct Answer is: None of these
58. Consequently R.Boyce-Codd jointly launched powerful definition for the third normal form called………………
Correct Answer is: Boyce-Codd normal form
59. ................ requires that data should be made available to only authorized users.
Correct Answer is: Security
60. The statement in SQL which allows to change the definition of a table is
