The Database Development Process

Q1: 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

Q2: Which is not a type of data management technology?

A Relational

B Rational

C Object-oriented

D Dimensional

Q3: Strategic Planning factors do not include which of the following?

A Organizational goals

B Critical success factors

C Information engineering

D Problem areas

Q4: 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.

Q5: 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

Q6: User views are included as part of which schema?

A Internal

B Conceptual

C External

D None of the above.

Q7: 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

Q8: 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.

Q9: 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.

Q10: 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

Q11: 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

Q12: The three-schema components include all, but:

A internal schema.

B conceptual schema.

C programming schema.

D external schema.

Q13: 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

Q14: 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.

Q15: 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


img not found
img

For help Students Orientation
Mcqs Questions

One stop destination for examination, preparation, recruitment, and more. Specially designed online test to solve all your preparation worries. Go wherever you want to and practice whenever you want, using the online test platform.