Site MapHelpFeedbackMultiple Choice Quiz
Multiple Choice Quiz
(See related pages)



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.
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.
3

The SQL database language includes statements for:
A)Database definition.
B)Database manipulation.
C)Database control.
D)All of the above.
4

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.
5

With regards to transaction processing, any DBMS should be capable of:
A)Ensuring that transactions are free from interference from other users.
B)Parts of a transaction are not lost due to a failure.
C)Transactions do not make the database inconsistent.
D)All of the above.
6

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

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.
8

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.
9

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.
10

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.





To learn more about the book this website supports, please visit its Information Center.
(c)2007 McGraw-Hill Higher Education
Any use is subject to the Terms of Use and Privacy Policy.
McGraw-Hill Higher Education is one of the many fine businesses of The McGraw-Hill Companies.


Mannino DB Design 3eOnline Learning Center with Powerweb

Home > Chapter 1 > Multiple Choice Quiz