DBMS MCQ Questions and Answers

Practice Mode
Showing 10 of 527 questions
Q291
Number of tuples present in a table at any instance is called as?
  • A intension
  • B extension
  • C integrity
  • D None of the above
Answer: Option B
Q292
Tables derived from the ERD
  • A Are totally normalized
  • B Are always in 1NF
  • C Can be further denormalised
  • D May have multi-valued attributes
Answer: Option B
Q293
What is degree of a Relation?
  • A It is the number of attribute of its relation schema
  • B It is an association among two or more entities
  • C The collection (or set) of similar relationships
  • D None of the above
Answer: Option A
Q294
What is Relationship?
  • A It is the number of attribute of its relation schema
  • B The collection (or set) of similar relationships
  • C None of the above
  • D It is an association among two or more entities
Answer: Option D
Q295
The particular property which describes the entity is called as
  • A Integrity
  • B Table
  • C Database
  • D Attribute
Answer: Option D
Q296
Which language of database specifies user views and their mappings to the conceptual schema
  • A SDL (Storage Definition Language)
  • B VDL (View Definition Language)
  • C DDL (Data Definition Language)
  • D Data Storage - Definition Language
Answer: Option B
Q297
Which translates DML statements in a query language?
  • A DDL Interpreter
  • B Query evaluation engine
  • C DML Compiler
  • D None of the above
Answer: Option C
Q298
Which abstraction existing in the DBMS?
  • A Physical level
  • B Logical level
  • C View level
  • D All the above
Answer: Option D
Q299
The 'thing' in the real world with an independent existence is called as.
  • A Entity set
  • B attributes
  • C degree
  • D entity
Answer: Option D
Q300
A database with single table structure is called a _________
  • A Hierarchical data model
  • B Relational data model
  • C Flat file structure
  • D Network data model
Answer: Option C

📚 More from Database

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