Question 1

Database administrators:

Accepted Answer

A)  Have technical responsibilities 
B)  Have non technical responsibilities 
C)  Participate in database design 
D)  All of the above 
A)  Have technical responsibilities 
B)  Have non technical responsibilities 
C)  Participate in database design 
D)  All of the above

Question 2

____________________ is an industry standard language that can be used for database definition and manipulation.

Accepted Answer

Structured

Question 3

Data is said to be interrelated when all of the data is stored in the same database and multiple users can access it at the same time.

Accepted Answer

A) True 
 B)False

Question 4

Which of the following is a characteristic of databases?

Accepted Answer

A)  Many users can use the same database at the same time 
B)  Different database entities can be connected to provide more information 
C)  Relevant business data are stored in a database 
D)  All of the above 
A)  Many users can use the same database at the same time 
B)  Different database entities can be connected to provide more information 
C)  Relevant business data are stored in a database 
D)  All of the above

Question 5

____________________ is the concept that a database should have an identity separate from the applications that use it.

Accepted Answer

The answer of ____________________ is the concept that a database...

Question 6

Which one is not a typical position of the data administrator in an organization?

Accepted Answer

A)  Just below the MIS director 
B)  At a lower level than the database administrator 
C)  At the same level as the MIS director 
D)  At a higher level than the database administration 
A)  Just below the MIS director 
B)  At a lower level than the database administrator 
C)  At the same level as the MIS director 
D)  At a higher level than the database administration

Question 7

Which of the following assertions is not true about DBMS market domination?

Accepted Answer

A)  Oracle dominates the Unix environment 
B)  DB2 dominates the IBM mainframe environment 
C)  Open source DBMS products have begun to challenge the commercial DBMS products at the high end of the enterprise DBMS market. 
D)  Microsoft Access dominates the desktop environment 
A)  Oracle dominates the Unix environment 
B)  DB2 dominates the IBM mainframe environment 
C)  Open source DBMS products have begun to challenge the commercial DBMS products at the high end of the enterprise DBMS market. 
D)  Microsoft Access dominates the desktop environment

Question 8

A procedural language interface is necessary because nonprocedural access and application development tools are sometimes not efficient enough or do not provide the level of control necessary for application development.

Accepted Answer

A) True 
 B)False

Question 9

In a client/server architecture the client software typically not responsible for:

Accepted Answer

A)  accepting user input 
B)  displaying results 
C)  locating remote databases 
D)  all of the above 
A)  accepting user input 
B)  displaying results 
C)  locating remote databases 
D)  all of the above

Question 10

In a passive interaction with a database,a(n)______________ user is given a report or some other data extracted from a database.

Accepted Answer

The answer of In a passive interaction with a database,a(n)______________...

Question 11

Many organizations now have a(n)_____________________ ,which is a management position responsible for planning the development of new databases.

Accepted Answer

The answer of Many organizations now have a(n)_____________________ ,which is...

Question 12

A DBMS provides software that can execute:

Accepted Answer

A)  On the client 
B)  On the server 
C)  On both the client and the server 
D)  None of the above 
A)  On the client 
B)  On the server 
C)  On both the client and the server 
D)  None of the above

Question 13

The database characteristic of ______________ means that data is stored on a stable medium as long as it is relevant to a business purpose.

Accepted Answer

The answer of The database characteristic of ______________ means that...

Question 14

In the evolution of database technology,third-generation systems are known as ______________ DBMSs because their foundation is based on mathematical relations and associated operators.

Accepted Answer

The answer of In the evolution of database technology,third-generation systems...

Question 15

A(n)________________ is a unit of work that should be processed reliably without interference from other users and without loss of data.

Accepted Answer

The answer of A(n)________________ is a unit of work that...

Question 16

Which one of the following is not a nonprocedural access to data in a database?

Accepted Answer

A)  The user types and executes a SQL query 
B)  The user writes and executes a Cobol program 
C)  The bank teller types the name of a customer into a form to retrieve this customer's bank account 
D)  The sales manager executes a report showing a salesperson's sales for the current week 
A)  The user types and executes a SQL query 
B)  The user writes and executes a Cobol program 
C)  The bank teller types the name of a customer into a form to retrieve this customer's bank account 
D)  The sales manager executes a report showing a salesperson's sales for the current week

Question 17

Which of the following orientation features does not qualify a system as using true database technology?

Accepted Answer

A)  Relational 
B)  Object 
C)  Network navigation 
D)  File orientation 
A)  Relational 
B)  Object 
C)  Network navigation 
D)  File orientation

Question 18

When a database can be used by multiple users at one time,the database is said to be ______________.

Accepted Answer

The answer of When a database can be used by...

Question 19

Which one of the following is true of a procedural language interface to a database?

Accepted Answer

A)  It is faster to develop by a ratio of 10 than a nonprocedural interface 
B)  It is faster to develop by a ratio of 100 than a nonprocedural interface 
C)  It provides more processing capabilities than a nonprocedural interface 
D)  It is usually developed with the sole use of a language such as SQL 
A)  It is faster to develop by a ratio of 10 than a nonprocedural interface 
B)  It is faster to develop by a ratio of 100 than a nonprocedural interface 
C)  It provides more processing capabilities than a nonprocedural interface 
D)  It is usually developed with the sole use of a language such as SQL

Question 20

The schema mapping between the conceptual and internal levels shows how entities are stored in files.

Accepted Answer

A) True 
 B)False

Database administrators:

____________________ is an industry standard language that can be used for database definition and manipulation.

Data is said to be interrelated when all of the data is stored in the same database and multiple users can access it at the same time.

Which of the following is a characteristic of databases?

____________________ is the concept that a database should have an identity separate from the applications that use it.

Which one is not a typical position of the data administrator in an organization?

Which of the following assertions is not true about DBMS market domination?

A procedural language interface is necessary because nonprocedural access and application development tools are sometimes not efficient enough or do not provide the level of control necessary for application development.

In a client/server architecture the client software typically not responsible for:

In a passive interaction with a database,a(n)______________ user is given a report or some other data extracted from a database.

Many organizations now have a(n)_____________________ ,which is a management position responsible for planning the development of new databases.

A DBMS provides software that can execute:

The database characteristic of ______________ means that data is stored on a stable medium as long as it is relevant to a business purpose.

In the evolution of database technology,third-generation systems are known as ______________ DBMSs because their foundation is based on mathematical relations and associated operators.

A(n)________________ is a unit of work that should be processed reliably without interference from other users and without loss of data.

Which one of the following is not a nonprocedural access to data in a database?

Which of the following orientation features does not qualify a system as using true database technology?

When a database can be used by multiple users at one time,the database is said to be ______________.

Which one of the following is true of a procedural language interface to a database?

The schema mapping between the conceptual and internal levels shows how entities are stored in files.

Introduction to Database Development

The Relational Data Model

Query Formulation With SQL

Understanding Entity Relations

Developing Data Models for Business Databases

Normalization of Relational Tables

Physical Database Design

Advanced Query Formulation With SQL

Application Development With Views

Stored Procedures and Triggers

View Design and Integration

Data and Database Administration

Transaction Management

Data Warehouse Technology and Management

Client-Server Processing and Distributed Databases

Object Database Management Systems

Filters

Exam 1: Introduction to Database Management

Database administrators:

____________________ is an industry standard language that can be used for database definition and manipulation.

Data is said to be interrelated when all of the data is stored in the same database and multiple users can access it at the same time.

Which of the following is a characteristic of databases?

____________________ is the concept that a database should have an identity separate from the applications that use it.

Which one is not a typical position of the data administrator in an organization?

Which of the following assertions is not true about DBMS market domination?

A procedural language interface is necessary because nonprocedural access and application development tools are sometimes not efficient enough or do not provide the level of control necessary for application development.

In a client/server architecture the client software typically not responsible for:

In a passive interaction with a database,a(n)______________ user is given a report or some other data extracted from a database.

Many organizations now have a(n)_____________________ ,which is a management position responsible for planning the development of new databases.

A DBMS provides software that can execute:

The database characteristic of ______________ means that data is stored on a stable medium as long as it is relevant to a business purpose.

In the evolution of database technology,third-generation systems are known as ______________ DBMSs because their foundation is based on mathematical relations and associated operators.

A(n)________________ is a unit of work that should be processed reliably without interference from other users and without loss of data.

Which one of the following is not a nonprocedural access to data in a database?

Which of the following orientation features does not qualify a system as using true database technology?

When a database can be used by multiple users at one time,the database is said to be ______________.

Which one of the following is true of a procedural language interface to a database?

The schema mapping between the conceptual and internal levels shows how entities are stored in files.

Introduction to Database Development

The Relational Data Model

Query Formulation With SQL

Understanding Entity Relations

Developing Data Models for Business Databases

Normalization of Relational Tables

Physical Database Design

Advanced Query Formulation With SQL

Application Development With Views

Stored Procedures and Triggers

View Design and Integration

Data and Database Administration

Transaction Management

Data Warehouse Technology and Management

Client-Server Processing and Distributed Databases

Object Database Management Systems

Filters