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

51. The three basic techniques to control deadlocks are: deadlock ………………, deadlock detection, and deadlock avoidance.

1. rollback
2. prevention
3. prohibition
4. Commits

52. A tuple is a(n):

1. row of a table
2. column of a table
3. two dimensional table
4. key 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.

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

54. The number of tuples in a relation is called its ………… While the number of attributes in a relation is called its ………………..

1. Rows, Columns
2. Degree, Cardinality
3. Cardinality, Degree
4. Columns, Rows

55. Which of the following in not a function of DBA?

1. Schema Definition
2. Network Maintenance
3. Routine Maintenance
4. Authorization for data access

56. After conversion of high level queries into low level commands for file access and is called compiled………………

1. SDL
2. DDL
3. DML
4. VDL

57. Which are the not features of a DBMS which provide a number of advantages for data management:

1. SDL
2. DML
3. DDL
4. None of these

58. Consequently R.Boyce-Codd jointly launched powerful definition for the third normal form called………………

1. Second normal form
2. Boyce-Codd normal form
3. First normal form
4. All of these

59. ................ requires that data should be made available to only authorized users.

1. Security
2. Data integrity
3. Privacy
4. None of the above

60. The statement in SQL which allows to change the definition of a table is

1. Select
2. Create
3. Alter
4. Update

61. What is used to retrieve tuples from the relation.

1. Select
2. Create
3. Drop
4. All of the above

62. To select all column from the table the syntax is:

1. Select from table_name
2. Select all from table_name
3. Select * from table_name
4. Non of the above

63. To select all columns from the table the syntax is:

1. Select from table_name
2. Select all from table_name
3. Select * from table_name
4. Non of the above

64. The SQL statement to create a view is:

1. SELECT VIEW
2. CREATE VIEW
3. MAKE VIEW
4. INSERT VIEW

65. System analyst and application programmers are commonly referred to as …………………….

1. Software engineers
2. Naïve users
3. Casual users
4. Programmers

66. Which are the not user in End-user:

1. Sophisticated user
2. Naïve users
3. Casual users
4. All of these

67. Who access the database occasionally and have different needs each time:

1. Sophisticated user
2. Naïve users
3. Casual users
4. All of these

68. Who interact with the system by invoking one of the permanent application program:

1. Sophisticated user
2. Naïve users
3. Casual users
4. All of these

69. Who interact with the system without writing a program:

1. Sophisticated user
2. Naïve users
3. Casual users
4. All of these

70. …………………… is the process of organizing data into related tables.

1. Specialization
2. Normalization
3. Generalization
4. None of the above

71. ………………… is a full form of SQL.

1. Structured query language
2. Standard query language
3. Sequential query language
4. Server side query language

72. FDs are the types of constraints that are based on………………

1. Superset key
2. Key
3. Key revisited
4. None of these

73. ……………… table store information about database or about the system.

1. System
2. SQL
3. Nested
4. None of these

74. What is a virtual table

1. Table
2. Stored procedure
3. View
4. Rules

75. SQL outputs a single table known as the………………

1. Tablespace
2. View
3. Column
4. Result set

76. What SQL structure is used to limit column values of a table?

1. The VALUE constraint
2. The LIMIT constraint
3. The CHECK constraint
4. None of the above is correct.

77. A ................. normal form, normalization will be needed where all attributes in a relation tuple are not functionally dependent only on the key attribute.

1. Third
2. First
3. Second
4. Fourth

78. A .................normal form, normalization will be needed where all attributes in a relation are not functionally dependent only on the key attribute.

1. Third
2. First
3. Second
4. Fourth

79. In the ..........normal form, a composite attribute is converted to individual attributes.

1. Third
2. First
3. Second
4. Fourth

80. In the.......... Normal form, a composite attribute is converted to individual attributes.

1. Third
2. First
3. Second
4. Fourth

81. Which one is based on multi-valued dependency:

1. Third
2. First
3. Second
4. Fourth

82. In decomposition technique of splitting a relation into ……………… relation:

1. THREE or MORE
2. ONE or MORE
3. TWO or MORE
4. FOUR or MORE

83. ………………… is preferred method for enforcing data integrity

1. Triggers
2. Constraints
3. Stored Procedure
4. Cursors

84. Which are the dependencies types:

1. Trivial functional dependency
2. Full functional dependency
3. Partial dependency
4. All of these

85. The number of entities associated in relationship is called as its.....................

1. Tuples
2. Cardinality
3. Degree
4. Entity

86. A relation is considered a:

1. Two dimensional table
2. Column
3. One dimensional table
4. Three dimensional table

87. Identify the criteria for designing database from the point of view of user

1. Uniformity in naming & definitions of the data items
2. No redundancy
3. No inapplicable attributes
4. All of the above

88. Identify the criteria for designing database from the point of view of user

1. Uniformity in naming & definitions of the data items
2. No redundancy
3. No inapplicable attributes
4. All of the above

89. The ........... operator preserves unmatched rows of the relations being joine

1. Union
2. Inner join
3. Outer join
4. Union join

90. The DML is called:

1. VDL
2. Sublanguages
3. Host languages
4. DDL

91. The DROP TABLE statement:

1. works whether or not referential integrity constraints would be violated
2. Deletes the table structure only
3. Deletes the table structure along with the table data
4. is not an SQL statement

92. How many levels of abstraction in DBMS:

1. 4
2. 2
3. 3
4. 5

93. There are ................ number of Normal forms that has been defined

1. 4
2. 5
3. 6
4. 3

94. E. F. Codd developed the normalization process in the which early:

1. 1971
2. 1969
3. 1970
4. 1972

95. Which forms are based on the concept of functional dependency

1. 3NF
2. 1NF
3. 2NF
4. 4NF

96. Which forms every non-prime attribute is fully dependent functionally on the candidate key of a relational schema:

1. 3NF
2. 1NF
3. 2NF
4. 5NF

97. Which forms simplifies and ensures that there is minimal data aggregates and repetitive groups:

1. 3NF
2. 1NF
3. 2NF
4. All of these

98. Which of the following is/are the DDL statements?

1. Alter
2. Create
3. Drop
4. All of the above

99. Which of the following is NOT a type of SQL constraint?

1. ALTERNATE KEY
2. PRIMARY KEY
3. FOREIGN KEY
4. UNIQUE

100. Which of the following is not a binary operator in relational algebra?

1. Assignment
2. Join
3. Semi-Join
4. Project