DBMS-Enhanced Entity-Relationship (EER) Model Questions and Answers

Practice Mode
Showing 10 of 57 questions
Q51
The conceptual database design is the process of
  • A deriving the physical structure of the database
  • B creating a conceptual and external schemas for the high-level data model
  • C analysing overall data requirements.
  • D None of these.
Answer: Option C
Q52
Which of the following design is both hardware and software independent ?
  • A physcal database design
  • B logical database design
  • C conceptual database design
  • D none of these
Answer: Option C
Q53
Which of the following design is both hardware and software independent ?
  • A physical database design
  • B logical database design
  • C conceptual database design
  • D none of these
Answer: Option C
Q54
Which of the following design is both hardware and software independent ?
  • A physical database design
  • B logical database design
  • C conceptual database design
  • D none of these
Answer: Option C
Q55
The bottom-up database design approach starts at the
  • A fundamental level of attributes
  • B development of data models that contains high-level abstractions
  • C indentification of set of major entities
  • D all of these
Answer: Option A
Q56
The top-down database design approach starts at the
  • A fundamental level of attributes
  • B development of data models that contains high-level abstractions.
  • C identification of seet of major entities.
  • D all of these
Answer: Option B
Q57
A functional dependency (FD) is a property of the information represented by the relation.
  • A TRUE
  • B FALSE
Answer: Option A
Database
Back to Database
Questions and Answers for Competitive Exams Various Entrance Test