Database Management System - DBMS Questions and Answers in Quiz Form 7 for Practice

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

101. Which of the following is NOT a basic element of all versions of the E-R model?

1. Attributes
2. Entities
3. Relationships
4. Primary key

102. Which is a duplicate copy of a file program that is stored on a different storage media than the original location:

1. Backup
2. Concurrency
3. Deadlock
4. Recovery

103. Which is refers to a stalemate situation due to which no further progress is possible as computer await response of each other:

1. Backup
2. Concurrency
3. Deadlock
4. Recovery

104. Which refers to a property of computer to run several operation simultaneously and possible as computers await response of each other:

1. Backup
2. Concurrency
3. Deadlock
4. Recovery

105. This is not a date type in SQL Server 2000

1. Bigint
2. Char
3. String
4. Decimal