Which of the following database activities allow for the actual retrieval and use of a database?
A. Enterprise modeling
B. Logical database design
C. Physical database design and definition
D. Database implementation
Select an option to see the answer and solution.
The three-schema components include all, but:
A. internal schema.
B. conceptual schema.
C. programming schema.
D. external schema.
Select an option to see the answer and solution.
Which is not a type of data management technology?
A. Relational
B. Rational
C. Object-oriented
D. Dimensional
Select an option to see the answer and solution.
Which is not a relevant feature of CASE tools?
A. The ability to help draw data models using entity-relationship notations
B. The ability to generate code
C. An information repository
D. Access to a DB via the Internet
Select an option to see the answer and solution.
The first step in database development is which of the following?
A. Enterprise data modeling
B. Logical database design
C. Physical database design and definition
D. Database Implementation
Select an option to see the answer and solution.
Which of the following database activities determines the entities, attributes, and relationships of data?
A. Conceptual data modeling
B. Logical database design
C. Physical database design and definition
D. Database implementation
Select an option to see the answer and solution.
The use of packaged data models can offer which of the following benefits?
A. Reduce implementation time and costs
B. Higher quality models
C. Both A and B.
D. Neither A nor B.
Select an option to see the answer and solution.
The Enterprise tier of the three-tiered database architecture includes:
A. managing the data.
B. managing the User-system interface.
C. processing HTTP protocol.
D. processing scripting tasks.
Select an option to see the answer and solution.
An entity type is which of the following?
A. A major category of data about people, place, and things
B. The various departments of an organization
C. The application software
D. The business processes the support the mission of an organization
Select an option to see the answer and solution.
Strategic Planning factors do not include which of the following?
A. Organizational goals
B. Critical success factors
C. Information engineering
D. Problem areas
Select an option to see the answer and solution.
CASE tools do not include which of the following features?
A. Help to draw data models
B. Help to generate code
C. Help to manage people
D. Create an information repository
Select an option to see the answer and solution.
In enterprise data modeling, which is incorrect?
A. You review current systems.
B. You implement the new database.
C. You describe the data needed at a very high level of abstraction.
D. You plan one or more database development projects.
Select an option to see the answer and solution.
Which of the following database activities require a specific knowledge of a DBMS?
A. Enterprise modeling
B. Conceptual data modeling
C. Logical database design
D. Physical database design and definition
Select an option to see the answer and solution.
User views are included as part of which schema?
A. Internal
B. Conceptual
C. External
D. None of the above.
Select an option to see the answer and solution.
Whose role is it to determine the requirements and design for a database?
A. Database analysts
B. Database administrators
C. Both A and B
D. Neither A or B
Select an option to see the answer and solution.
There is one physical schema for each logical schema.
Select an option to see the answer and solution.
The most important reason for data architecture is reliability.
Select an option to see the answer and solution.
The systems development life cycle cannot be used with database implementation.
Select an option to see the answer and solution.
Enterprise data modeling typically occurs during information systems planning.
Select an option to see the answer and solution.
During logical database design, the conceptual data model is transformed into a logical data model which describes the data in terms of a specific data management technology.
Select an option to see the answer and solution.