Exam 11: Databases

MATCHING Identify the letter of the choice that best matches the phrase or definition. -Procedure that monitors and records user activity within a database

Relationships between record types can be graphically depicted using a(n)____.

-The accompanying figure shows an example of an SQL query.

Database ____ software is designed to manage billions of records and several hundred transactions per second.

The simplest model for storing data is the flat file.

Database ____ software allows a remote computer or network workstation to access data in a database.

A ____ validates an entry by searching for the same data in a file or database table.

Describe how user privileges and using a data view help to secure a database.

A(n)____________________ refers to a collection of data fields about one entity--a person,place,thing,or event.

____ is a markup language that allows field tags,data,and tables to be incorporated into a Web document.

A ____ establishes which fields and records a particular user may access.

WebMusic’s database designer, Janet, has hired an intern. She has requested that this intern create some SQL queries that would be useful to managers tracking the day-to-day operations of the store. -A customer would like a list of all of the CDs from their favorite group that are priced at $10.00 or less at WebMusic.Which of the following categories of operators would be used in order to perform the proper type of query for the customer?

The ____ data type is used to store true/false or yes/no data using minimal storage space.

The goal of normalization is to minimize data ____.

User privileges delineate what activities a user can perform within a database.

Modern database software is designed to support data dependence.

____ is a query language.

A technique called ____ Web publishing is a simple way to display the data in a database by converting a database report into an HTML document,which can be displayed as a Web page by a browser.

____ allows decision makers to quickly get answers to complex queries that encompass multiple factors.

A(n)____ allows you to create,update,and administer a relational database.