The Database Development Process - Database MCQ Questions and answers- Technical Aptitude

1

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

Discuss

Answer & Solution

Answer: Option D

No explanation is given for this question. Let's Discuss on Board

2

The three-schema components include all, but:

A) internal schema. B) conceptual schema. C) programming schema. D) external schema.

Discuss

Answer & Solution

Answer: Option C

No explanation is given for this question. Let's Discuss on Board

3

Which is not a type of data management technology?

A) Relational B) Rational C) Object-oriented D) Dimensional

Discuss

Answer & Solution

Answer: Option B

No explanation is given for this question. Let's Discuss on Board

4

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

Discuss

Answer & Solution

Answer: Option D

No explanation is given for this question. Let's Discuss on Board

5

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

Discuss

Answer & Solution

Answer: Option A

No explanation is given for this question. Let's Discuss on Board

6

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

Discuss

Answer & Solution

Answer: Option A

No explanation is given for this question. Let's Discuss on Board

7

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.

Discuss

Answer & Solution

Answer: Option C

No explanation is given for this question. Let's Discuss on Board

8

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.

Discuss

Answer & Solution

Answer: Option A

No explanation is given for this question. Let's Discuss on Board

9

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

Discuss

Answer & Solution

Answer: Option A

No explanation is given for this question. Let's Discuss on Board

10

Strategic Planning factors do not include which of the following?

A) Organizational goals B) Critical success factors C) Information engineering D) Problem areas

Discuss

Answer & Solution

Answer: Option C

No explanation is given for this question. Let's Discuss on Board