Exam 1: Introduction to Database Management

Which one of the following languages is not a procedural language?

The goal of information resource management is to use information technology as a tool for processing,distributing,and integrating information for isolated functions within an organization.

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 following application program will be modified to accommodate the change to the database table:

In the evolution of database technology,second-generation products were the first true DBMSs because they could manage multiple entity types and relationships.

Which one of the following is not included in the definition of a database?

A(n)______________ is a cluster of data usually about a single topic that can be accessed together.

Which of the following is not a level of the three-schema architecture?

In addition to application development tools,most DBMSs provide a(n)_________________________,which is a method to combine a nonprocedural language with a programming language.

A database is said to be shared when multiple users can access the same database for multiple uses,but must take turns accessing the database.

A(n)_______________ is a named,two-dimensional arrangement of data consisting of a heading part and a body part.

In the Three Schema Architecture,both the external and internal schemas represent the entire database.

Who is in charge of controlling information resources in an enterprise?

Database technology is vital to the functioning of modern organizations and dramatically affects most people's lives in many ways.

SQL can be used to define tables and the relationships among them,but a graphical interface must be used to define integrity constraints and authorization rights.

The Three Schema Architecture proposes that there are three levels of database description: internal,external and physical.

Which of the following is not a characteristic nor a feature of databases?

Which one of the following does not apply to a database?

Data is said to be persistent when it resides on stable storage and is never removed or archived for the life of the business.

The retrieval of summarized data to support long-range decisions is a dominant feature of data warehousing,whereas a mixture of updating and retrieving data is characteristic of databases that support the day to day operations of an organization.

The data administrator has primarily a planning role because they view the information resources in a broad context and must consider all kinds of data.