Question 1

What must you define before adding any information to a relational database?

Accepted Answer

When you create a workbook,you can immediately begin typing in information and creating formulas and functions.You can't do that with a database.You must define its logical structure before you can begin typing in any information.

Question 2

Which data manipulation tool allows you to graphically design the answer to your business questions?

Accepted Answer

Query-by-example (QBE)tools help you graphically design the answer to a question.

Question 3

Which data manipulation tool allows you to see the contents of a database file and make whatever changes you want?

Accepted Answer

The data manipulation subsystem of a DBMS helps you add,change,and delete information in a database and query it for valuable information.

Question 4

A database management system contains five important software components.Which of the following components accepts and processes requests from the other four database components?

Accepted Answer

The DBMS engine accepts logical requests from the various other DBMS subsystems,converts them into their physical equivalent,and actually accesses the database and data dictionary as they exist on a storage device.

Question 5

_____ is the process of reinstalling the backup information in the event the information was lost.

Accepted Answer

Recovery is the process of reinstalling the backup information in the event the information was lost.

Question 6

A _____ is simply a copy of the information stored on a computer.

Accepted Answer

A backup is simply a copy of the information stored on a computer.

Question 7

Which data administration facility allows you to control who has access to what information and what type of access those people have?

Accepted Answer

Security management facilities-allow you to control who has access to what information and what type of access those people have.Always remember CRUD-Create,Read,Update,and Delete.Identifying who can perform those functions on various database information is vitally important.

Question 8

SQL is:

Accepted Answer

Structured query language (SQL)is a standardized fourth-generation query language found in most DBMSs.SQL performs the same function as QBE,except that you perform the query by creating a statement instead of pointing,clicking,and dragging.

Question 9

A database management system contains five important software components.Which of the following components allows you to create and maintain the data dictionary?

Accepted Answer

The data definition subsystem of a DBMS helps you create and maintain the data dictionary and define the structure of the files in a database.

Question 10

Which database management subsystem is responsible for backup and recovery,security management,query optimization,concurrency control,and change management?

Accepted Answer

The data administration subsystem of a DBMS helps you manage the overall database environment by providing facilities for backup and recovery,security management,query optimization,concurrency control,and change management.

Question 11

Which of the following data administration facilities continually maintain statistics concerning how the DBMS engine physically accesses information?

Accepted Answer

Reorganization facilities-continually maintain statistics concerning how the DBMS engine physically accesses information and reorganizes how information is physically stored.For example,if you frequently access a file by a specific order,the reorganization facilities may maintain the file in that presorted order by creating an index that maintains the sorted order in that file.

Question 12

If you were a programmer and needed to view information as it was stored by the database,what type of database view would you see?

Accepted Answer

The physical view of information deals with how information is physically arranged,stored,and accessed on some type of storage device such as a hard disk.

Question 13

If you were able to quickly pull information from student records with course records to build students' schedules,you would be using a _____ tool.

Accepted Answer

Query-by-example (QBE)tools help you graphically design the answer to a question.

Question 14

Which of the following DBMS components allows you to quickly develop computer routines or tasks that will process your business transactions?

Accepted Answer

The application generation subsystem of a DBMS contains facilities to help you develop transaction-intensive applications.

Question 15

Application generation facilities are most often used by what group of employees?

Accepted Answer

As with SQL,application generation facilities are most often used by IT specialists.As a knowledge worker,it is recommended that they leave application generation to IT specialists as much as they can.

Question 16

If you were looking at information in a database and you are able to see only the information you needed in the format you wanted,what type of database view is it?

Accepted Answer

The logical view of information,on the other hand,focuses on how you as a knowledge worker need to arrange and access information to meet your particular business needs.

Question 17

Which of the following DBMS components allows you to add,change,and delete information in a relational database?

Accepted Answer

The data manipulation subsystem of a DBMS helps you add,change,and delete information in a database and query it for valuable information.

Question 18

_____ facilities find the "shortest route" to the information you want so you don't have to.

Accepted Answer

Query optimization facilities-often take queries from users (in the form of SQL statements of QBEs)and restructure them to minimize response times.Basically,these facilities find the "shortest route" to the information you want so you don't have to.

Question 19

_____ ensure the validity of database updates when multiple users attempt to access and change the same information.

Accepted Answer

Concurrency control facilities-ensure the validity of database updates when multiple users attempt to access and change the same information.

Question 20

Which data manipulation tool allows you to quickly define the formats of needed business reports from information stored in a database?

Accepted Answer

Report generators help you quickly define formats of reports and what information you want to see in a report.

Quiz 3: Databases and Data Warehouses: Supporting the Analytics-Driven Organization

What must you define before adding any information to a relational database?

Which data manipulation tool allows you to graphically design the answer to your business questions?

Which data manipulation tool allows you to see the contents of a database file and make whatever changes you want?

A database management system contains five important software components.Which of the following components accepts and processes requests from the other four database components?

_____ is the process of reinstalling the backup information in the event the information was lost.

A _____ is simply a copy of the information stored on a computer.

Which data administration facility allows you to control who has access to what information and what type of access those people have?

SQL is:

A database management system contains five important software components.Which of the following components allows you to create and maintain the data dictionary?

Which database management subsystem is responsible for backup and recovery,security management,query optimization,concurrency control,and change management?

Which of the following data administration facilities continually maintain statistics concerning how the DBMS engine physically accesses information?

If you were a programmer and needed to view information as it was stored by the database,what type of database view would you see?

If you were able to quickly pull information from student records with course records to build students' schedules,you would be using a _____ tool.

Which of the following DBMS components allows you to quickly develop computer routines or tasks that will process your business transactions?

Application generation facilities are most often used by what group of employees?

If you were looking at information in a database and you are able to see only the information you needed in the format you wanted,what type of database view is it?

Which of the following DBMS components allows you to add,change,and delete information in a relational database?

_____ facilities find the "shortest route" to the information you want so you don't have to.

_____ ensure the validity of database updates when multiple users attempt to access and change the same information.

Which data manipulation tool allows you to quickly define the formats of needed business reports from information stored in a database?