Exam 11: Databases

____ refers to the number of associations that can exist between two record types.

Databases are NOT vulnerable to ____.

-In the SQL query in the accompanying figure,how many tables will be accessed?

Which of the following SQL operators designates records that meet either one of a set of two criteria or both?

____ is a query language.

The hyperlink data type is used to store data that can have one of two values.

A(n)____________________ key is a field that contains data unique to a record.

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

If a name field contains an entire name,it is difficult to individually manipulate the first name,last name,and middle initial.

A(n)____ file uses a uniform format to store data for each person or thing in the file.

A(n)____________________ is a database management system that is optimized for handling data that exists in XML format.

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

MATCHING Identify the letter of the choice that best matches the phrase or definition. -Establishes which fields and records a particular user is allowed to access

In business, the goal is to choose the best data management tool to meet the needs of the business. Margaret is taking over the task of managing her company's information needs. She knows that the best tool depends on several factors, including cost, versatility, and ease of use. -One of Margaret's first tasks is to create the company's electronic customer address book.Which software tool would be easy,require minimal setup,and likely have the needed fields predefined?

-In the accompanying figure,the relationship shown in the top row is a one-to-many relationship.

Discuss in detail the two general safeguards that access controls provide.

What is the SQL command used to introduce a brand-new database or table?

____________________ Web publishing is a process that generates customized Web pages as needed,or "on the fly."

Which of the following has the least versatility?

The goal of normalization is to minimize data ____.