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

The digital dashboard is designed uniquely for each individual user.

Unlike SQL,QBE allows you to query by pointing,clicking,and dragging.

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

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

A(n)_____ displays key information gathered from several sources on a computer screen in a format tailored to the needs and wants of an individual knowledge worker.

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

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

_____ is the science of fact-based decision making.

You can create logical ties among various files only in the absence of foreign keys.

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

A relational database model uses a series of physically related two-dimensional tables or files to store information in the form of a database.

Data marts focus on the entire organization,while data warehouses focus on specific needs.

A(n)_____ is a collection of information that you organize and access according to the logical structure of that information.

_____ in your organization means that anyone,regardless of title or department,can access and use whatever information he or she needs.

In large organizations,both data administration and database administration are usually handled by steering committees rather than by a single individual.

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

A primary key from one file and a foreign key from another file are used to create a relationship between two files in a relational database.

Which of the following is true of data administration and database administration?

SQL is:

Query-and-reporting tools are similar to QBE tools,SQL,and report generators in the typical database environment.