Exam 1: Introduction to Database Management

In transaction processing,inconsistency in the database is a concern of the user,not the DBMS processing the transaction.

A crucial function of DBMSs,______________________ allows geographically dispersed computers to cooperate when providing data access.

To be considered a true DBMS,a database product should be able to obtain access to data without writing a specialized computer program.

With regards to the Three Schema Architecture,the _____________________ provides the knowledge to convert a request using an external view into a request using the tables in the conceptual schema.

In the early DBMSs,there was not a very close connection between the database and the computer programs that accessed it,so as a result the database definition was separate from the computer programs that accessed the database.

In most commercial DBMSs,collections of entities are stored in files.

The external level of the Three Schema Architecture allows for each group of users to have a separate view of a database tailored to that group's specific needs.

COBOL and Visual Basic are both examples of a nonprocedural language.

The three-schema architecture is strongly related to the following feature of database systems:

Nonprocedural languages do not include looping statements because the user specifies what parts of the database to retrieve,not how retrieval occurs.

Per the author,with the growing importance of the internet and network computing,transaction processing is becoming a crucial function of DBMSs.

Since the database administrator has technical responsibilities such as designing and tuning databases,which requires extensive training and expertise,they typically occupy a higher level in the organization than the data administrator.

File processing systems can manage only one entity.

A database table consists of the following columns: employee's name, SS#, job-title, hiring-date, years-in-job, base-salary. A bonus calculation program, a personnel promotion application program, and a payroll application program all use this table. To implement a policy change in personnel promotion, the following column is added to the table: highest-college-degree. This new column is not used by the payroll program or by the bonus calculation program. -The ability to add the new column without requiring changes to all of the application programs strongly relates to the following feature of modern database systems:

In the Three Schema Architecture model,the ____________ schema defines the entities and the relationships among them.

___________________ ,which allows users with limited computing skills to submit queries to a database,can provide reduced software development costs and increased software productivity.

Tools included in DBMSs that are used to monitor and improve database performance are called ____________________ tools.

Which one of the following is the least likely to be viewed as a transaction?

On a typical client/server architecture system that consists of one server and three clients:

In a typical organization,a(n)______________________ is a support position that specializes in managing DBMSs.