Exam 11: Databases

The item indicated in the figure above is an example of a SQL query.

Case 3 There is the database designer and the people who enter the data. Sometimes this is the same person, but in Kate's large banking firm, the actual database entries are not made by the people who designed the database. A data entry operator might enter a telephone number as 555-555-7777, (555) 555-7777, or 1-555-555-7777. If multiple data entry operators enter telephone numbers in different reports, it becomes difficult to produce nicely formatted reports or locate a particular telephone number. Kate can set up a ____ to make sure that data entry operators cannot enter a dollar amount of less than $0 in the database.

Database ____ software provides database users with an easy-to-use interface that can be used to enter search specifications or update data.

Which of the following can be used to delineate the data entry area in a user interface?

AND is sometimes indicated by ____.

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

____ analytics refers to a branch of data mining that focuses on predicting future probabilities and trends.

The term ____________________ refers to software that is designed to manage data stored in a database.

By convention, the ____ key provides a quick way to move through the fields in order when using a data entry screen.

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

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

The relationship shown in the first row of the above figure is a one-to-many relationship.

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

A(n) ____________________ database is one which is stored on several computers, on multiple networks, or in different geographical locations.

In the context of object-oriented databases, a(n) ____________________ defines a group of objects by specifying the attributes and methods these objects share.

Physical access to a database can be limited to authorized personnel by housing the computer in a locked data center.

The ____ operator specifies that both of the search criteria must be true for the record to be selected.

Keywords such as WHERE usually begin an SQL clause that contains the ____ for a command.