Database Management System - DBMS MCQ Multiple Choice Questions - Page 4 for Practice

Database Management System - DBMS MCQ Questions for Practice

91. The DROP TABLE statement:

92. How many levels of abstraction in DBMS:

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

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

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

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

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

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

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

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

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

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

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

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

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

106. A DBMS uses a transaction ……………… to keep track of all transactions that update the database

107. ……………… states that primary keys should not be null:

108. In which end is really just any application that runs on top of the DBMS and acts as a user interface:

109. In which the database can be restored up to the last consistent state after the system failure:

110. The related and interconnected software components of a DBMS are described by the………………

111. Which are the types of data independence:

112. Which are the types of integrity rule:

113. Which are the types of physical DBMS architecture can be split :

114. Which calculus is based on specifying a number of tuple variables:

115. Which command creates database objects like tables, views and indexes:

116. Which is a DBMS keeps back-up copies of the database:

117. Which is incorporated to create an appropriate physical database that is transformed by a logical data model:

118. Which is relation calculus:

119. Which mapping exists between the conceptual and internal levels:

120. Which mapping exists between the external and conceptual levels:

Tags

Multiple Choice Questions and Answers on Database Management System - DBMS

Database Management System - DBMS Multiple Choice Questions and Answers

Database Management System - DBMS Trivia Quiz

Database Management System - DBMS Question and Answer PDF Online