DBMS Design Process MCQs Quiz Online PDF Download

Learn dbms design process MCQs, database management system test for online learning courses, test prep to practice test. Database design and er model quiz has multiple choice questions (MCQ), dbms design process quiz questions and answers, constraints in dbms, entity relationship diagrams, dbms design process tutorials for online SQL group by courses distance learning.

Database management system practice test MCQ: mapping of conceptual schema using entity-relationship model into a relation schema, is achieved at stage with choices physical-design phase, contextual-design phase, virtual-design phase and logical-design phase for online competitive exams, certifications tests for financial aids, scholarships contests in universities. Free study guide is for online learning dbms design process quiz with MCQs to practice test questions with answers.

MCQs on DBMS Design Process Quiz PDF Download

MCQ: Mapping of conceptual schema using entity-relationship model into a relation schema, is achieved at stage

  1. Physical-design phase
  2. Contextual-design phase
  3. Virtual-design phase
  4. Logical-design phase

D

MCQ: Designer maps high-level conceptual schema onto implementation data model, at level

  1. Contextual-design phase
  2. Physical-design phase
  3. Logical-design phase
  4. Virtual-design phase

C

MCQ: In a database design, gathering data needs of prospective database users, comes at stage?

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

A

MCQ: An entity-relationship diagram provides a graphical representation of the

  1. Context
  2. Framework
  3. Schema
  4. Modules

C

MCQ: Initial phase of database design is to

  1. Choosing data model
  2. Conceptual design
  3. Characterize data needs
  4. Conceptual schema

C