The Database Environment - Database MCQ Questions and answers- Technical Aptitude

11

Which of the following is true for a relational database?

A) Data is represented by tables. B) It is difficult to access data. C) Complex programs have to be written for simple queries. D) All of the above.

Discuss

Answer & Solution

Answer: Option A

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

12

Some advantages of the database approach include all, but:

A) minimal data redundancy. B) improved data consistency. C) improved data sharing. D) program-data dependency.

Discuss

Answer & Solution

Answer: Option D

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

13

An enterprise database is which of the following?

A) A database designed to support only users external to an organization B) A database designed to support an entire organization C) A database designed to support a relatively small group D) A database designed to support a single PC

Discuss

Answer & Solution

Answer: Option B

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

14

Structured data may include which of the following?

A) Photo image B) Video clip C) Dates D) None of the above

Discuss

Answer & Solution

Answer: Option C

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

15

An extranet is which of the following?

A) The use of Internet protocols with limited access to company data by the company's customers and suppliers. B) The use of Internet protocols with unlimited access to company data by the company's customers and suppliers. C) The use of Internet protocols with limited access to company data by people within an organization. D) The use of Internet protocols with unlimited access to company data by people within an organization.

Discuss

Answer & Solution

Answer: Option A

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

16

All enterprise resource planning (ERP) systems are heavily dependent on databases to store the data required by the ERP applications.

A) True B) False

Discuss

Answer & Solution

Answer: Option A

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

17

Database management systems were first introduced in the 1950s.

A) True B) False

Discuss

Answer & Solution

Answer: Option B

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

18

Databases that contain historical and summarized information are usually called data warehouses.

A) True B) False

Discuss

Answer & Solution

Answer: Option A

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

19

An advantage of the database approach is the creation of maximum data redundancy.

A) True B) False

Discuss

Answer & Solution

Answer: Option B

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

20

An enterprise data model is a relational model that shows the high-level entities for the organization and associations among those entities.

A) True B) False

Discuss

Answer & Solution

Answer: Option B

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