Q.1

Which of the following database activities determines the entities, attributes, and relationships of data?

  • Conceptual data modeling
  • Logical database design
  • Physical database design and definition
  • Database implementation
Q.2

CASE tools do not include which of the following features?

  • Help to draw data models
  • Help to generate code
  • Help to manage people
  • Create an information repository
Q.3

Which of the following database activities allow for the actual retrieval and use of a database?

  • Enterprise modeling
  • Logical database design
  • Physical database design and definition
  • Database implementation
Q.4

The use of packaged data models can offer which of the following benefits?

  • Reduce implementation time and costs
  • Higher quality models
  • Both A and B.
  • Neither A nor B.
Q.5

In enterprise data modeling, which is incorrect?

  • You review current systems.
  • You implement the new database.
  • You describe the data needed at a very high level of abstraction.
  • You plan one or more database development projects.
Q.6

The three-schema components include all, but:

  • internal schema.
  • conceptual schema.
  • programming schema.
  • external schema.
Q.7

The Enterprise tier of the three-tiered database architecture includes:

  • managing the data.
  • managing the User-system interface.
  • processing HTTP protocol.
  • processing scripting tasks.
Q.8

Which of the following database activities require a specific knowledge of a DBMS?

  • Enterprise modeling
  • Conceptual data modeling
  • Logical database design
  • Physical database design and definition
Q.9

User views are included as part of which schema?

  • Internal
  • Conceptual
  • External
  • None of the above.
Q.10

Which is not a type of data management technology?

  • Relational
  • Rational
  • Object-oriented
  • Dimensional
Q.11

Which is not a relevant feature of CASE tools?

  • The ability to help draw data models using entity-relationship notations
  • The ability to generate code
  • An information repository
  • Access to a DB via the Internet
Q.12

An entity type is which of the following?

  • A major category of data about people, place, and things
  • The various departments of an organization
  • The application software
  • The business processes the support the mission of an organization
Q.13

Whose role is it to determine the requirements and design for a database?

  • Database analysts
  • Database administrators
  • Both A and B.
  • Neither A or B.
Q.14

The first step in database development is which of the following?

  • Enterprise data modeling
  • Logical database design
  • Physical database design and definition
  • Database Implementation
Q.15

Strategic Planning factors do not include which of the following?

  • Organizational goals
  • Critical success factors
  • Information engineering
  • Problem areas
0 h : 0 m : 1 s