24.
A database management system contains five important software
components. Which of the following components allows you to create and
maintain the data dictionary?
25.
What must you define before adding any information to a relational
database?
26.
Which of the following DBMS components allows you to add, change, and
delete information in a relational database?
27.
Which data manipulation tool allows you to see the contents of a database
file and make whatever changes you want?
28.
Which data manipulation tool allows you to quickly define the formats of
needed business reports from information stored in a database?
29.
Which data manipulation tool allows you to graphically design the answer to
your business questions?
30.
If you were able to quickly pull information from student records with
course records to build students’ schedules, you would be using a _____
tool.
31.
SQL is:
32.
Which of the following DBMS components allows you to quickly develop
computer routines or tasks that will process your business transactions?
33.
Application generation facilities are most often used by what group of
employees?
34.
Which database management subsystem is responsible for backup and
recovery, security management, query optimization, concurrency control,
and change management?
35.
A _____ is simply a copy of the information stored on a computer.
36.
_____ is the process of reinstalling the backup information in the event the
information was lost.
37.
Which data administration facility allows you to control who has access to
what information and what type of access those people have?
38.
_____ facilities find the “shortest route” to the information you want so you
don’t have to.
39.
Which of the following data administration facilities continually maintain
statistics concerning how the DBMS engine physically accesses
information?
40.
_____ ensure the validity of database updates when multiple users attempt
to access and change the same information.
41.
A data warehouse is:
42.
What does it mean for a data warehouse to be multidimensional?
43.
A hypercube is:
44.
Data warehouses exist to support: