DBMS MCQ Questions and Answers

Practice Mode
Showing 10 of 527 questions
Q361
In a relation, an instance is stored as
  • A a Column
  • B a Row
  • C as a Many to many relationship
  • D as an index
Answer: Option B
Q362
The process of combining entity types from an ER diagram into a single relation in a relational database is to
  • A specialise
  • B generalise
  • C consume
  • D assume
Answer: Option B
Q363
The Data Dictionary provides which of the following features?
  • A Transaction deadlock detection.
  • B Support for the SQL interface to the database.
  • C Costings for future database changes.
  • D None of the above.
Answer: Option B
Q364
Consider the development process for the "Three level model". Select the statement which is most generally TRUE.
  • A "Data Model" concerns the external users' view of the data.
  • B "Physical Design" is used to produce an ER model.
  • C "Physical Design" may refer to indexes.
  • D An ER model is required prior to "Conceptual Design".
Answer: Option C
Q365
In the ANSI/SPARC three level database model, the external view is best described by which one of the following options?
  • A It is the place where the storage structures link to the database.
  • B It is not part of the model.
  • C It is dependent on the underlying DBMS product used (e.g. Oracle, DBASE).
  • D It is the place where the users interface to the DBMS.
Answer: Option D
Q366
A dominant entity is the entity
  • A on the N side in a 1 : N relationship
  • B on the 1 side in a 1 : N relationship
  • C on either side in a 1 : 1 relationship
  • D nothing to do with 1 : 1 or 1 : N relationship
Answer: Option B
Q367
________________ guarantees that the spurious tuple generation does not occur with respect to relation schemas after decomposition.
  • A A lossless join property.
  • B lossy join property
  • C join property
  • D none.
Answer: Option A
Q368
relational algebra is ________
  • A structured query language
  • B procedural query language.
  • C programmed query language.
  • D none.
Answer: Option B
Q369
___________ defines a set of associations or a relationship set among a given set of entity
  • A relation ship type
  • B degree of the relation
  • C both A & B
  • D none
Answer: Option A
Q370
__________is an association among two or more entities.
  • A entity set
  • B strong entity set
  • C weak entity set
  • D relationship
Answer: Option D

📚 More from Database

← All Topics 🎯 Practice ⏱️ Take Test 🔍 Search
Database
Back to Database
Other Subjects
Questions and Answers for Competitive Exams Various Entrance Test