The Database Development Process(Database ) Questions and Answers

Question 1. The three-schema components include all, but:
  1.    internal schema.
  2.    conceptual schema.
  3.    programming schema.
  4.    external schema.
Explanation:-
Answer: Option C. -> programming schema.
Question 2. Which is not a type of data management technology?
  1.    Relational
  2.    Rational
  3.    Object-oriented
  4.    Dimensional
Explanation:-
Answer: Option B. -> Rational
Question 3. Which is not a relevant feature of CASE tools?
  1.    The ability to help draw data models using entity-relationship notations
  2.    The ability to generate code
  3.    An information repository
  4.    Access to a DB via the Internet
Explanation:-
Answer: Option D. -> Access to a DB via the Internet
Question 4. Which of the following database activities allow for the actual retrieval and use of a database?
  1.    Enterprise modeling
  2.    Logical database design
  3.    Physical database design and definition
  4.    Database implementation
Explanation:-
Answer: Option D. -> Database implementation
Question 5. The first step in database development is which of the following?
  1.    Enterprise data modeling
  2.    Logical database design
  3.    Physical database design and definition
  4.    Database Implementation
Explanation:-
Answer: Option A. -> Enterprise data modeling
Question 6. Which of the following database activities determines the entities, attributes, and relationships of data?
  1.    Conceptual data modeling
  2.    Logical database design
  3.    Physical database design and definition
  4.    Database implementation
Explanation:-
Answer: Option A. -> Conceptual data modeling
Question 7. The Enterprise tier of the three-tiered database architecture includes:
  1.    managing the data.
  2.    managing the User-system interface.
  3.    processing HTTP protocol.
  4.    processing scripting tasks.
Explanation:-
Answer: Option A. -> managing the data.
Question 8. The use of packaged data models can offer which of the following benefits?
  1.    Reduce implementation time and costs
  2.    Higher quality models
  3.    Both A and B.
  4.    Neither A nor B.
Explanation:-
Answer: Option C. -> Both A and B.
Question 9. An entity type is which of the following?
  1.    A major category of data about people, place, and things
  2.    The various departments of an organization
  3.    The application software
  4.    The business processes the support the mission of an organization
Explanation:-
Answer: Option A. -> A major category of data about people, place, and things
Question 10. Strategic Planning factors do not include which of the following?
  1.    Organizational goals
  2.    Critical success factors
  3.    Information engineering
  4.    Problem areas
Explanation:-
Answer: Option C. -> Information engineering
© Lakshya_Education.com, All Right Reserved.
Contact Us services