DBMS Multiple choice Questions and Answers-DBMS Basics

1.	Given the evolution of DBMSs, business data is now:
a.	Stored in main memory and stays resident there even after the application that uses it terminates.
b.	Stored only if it is relevant to business decisions.
c.	Stored indefinitely in case it's needed since storing it is much cheaper now.
d.	None of the above.

Discuss

Answer: (b).Stored only if it is relevant to business decisions.

2.	Which of the following is not true of a DBMS?
a.	It provides efficient storage and retrieval of data.
b.	It has evolved over the years into a fairly simple set of tools that are relatively easy to master.
c.	Marketplace demands and product innovation have led to the development of a broad range of features.
d.	None of the above.

Discuss

Answer: (b).It has evolved over the years into a fairly simple set of tools that are relatively easy to master.

3.	Nonprocedural access to a database:
a.	Can provide a dramatic improvement in software productivity.
b.	Allows a user to submit queries to a database without having to know how the data will be retrieved.
c.	Is supported by more than one tool in most DBMSs.
d.	All of the above.

Discuss

Answer: (d).All of the above.

4.	Which of the following statements is not true of a desktop DBMS?
a.	They usually run on personal computers or small servers.
b.	They have a much lower cost than other DBMSs.
c.	Although useful for processing ad hoc queries, they cannot perform transaction processing.
d.	They usually support databases used by work teams and small businesses.

Discuss

Answer: (c).Although useful for processing ad hoc queries, they cannot perform transaction processing.

5.	In the evolution of database technology, second-generation products are considered to be the first true DBMSs because:
a.	They were "navigational", i.e. the programmer had to write code to navigate through a network of linked records.
b.	Of their foundation on mathematical relations and associated operators.
c.	They supported sequential and random searching.
d.	They could manage multiple entities and relationships.

Discuss

Answer: (d).They could manage multiple entities and relationships.

6.	In the evolution of database technology, third-generation products supplanted second-generation systems because:
a.	Nonprocedural database access was an improvement over navigational access.
b.	IBM supported the CODASYL standard of database definition and manipulation.
c.	Nonprocedural languages were still not very efficient.
d.	All of the above.

Discuss

Answer: (a).Nonprocedural database access was an improvement over navigational access.

7.	Which statement is not true of the Three Schema Architecture?
a.	It is an official standard of the American Standards Institute (ANSI).
b.	It is an architecture for compartmentalizing database descriptions.
c.	Its details have been widely adopted in third- and fourth-generation DBMSs.
d.	None of the above.

Discuss

Answer: (c).Its details have been widely adopted in third- and fourth-generation DBMSs.

8.	Which of the following statements is not true of information resource management?
a.	It is very different and much more challenging than managing the other physical resources of an organization.
b.	Its goal is to use information technology as a tool for processing, distributing, and integrating information throughout an organization.
c.	Its emergence has created new management responsibilities.
d.	None of the above.

Discuss

Answer: (a).It is very different and much more challenging than managing the other physical resources of an organization.

9.	A Database Management System (DBMS) is
a.	Collection of interrelated data
b.	Collection of programs to access data
c.	Collection of data describing one particular enterprise
d.	All of the above

Discuss

Answer: (d).All of the above

10.	Data Manipulation Language enables users to
a.	Retrieval of information stored in database
b.	Insertion of new information into the database
c.	Deletion of information from the database
d.	All of the above

Discuss

Answer: (d).All of the above