Exam 66: Database Tools

One of the first steps in creating a database is to build queries and reports that can pull information from the data that is stored.

Query wizards and ____ automate the process of writing SQL commands in a relational database.

A database schema can stand alone as a single file or be part of a database.

The ____ data manipulation language is used to build databases in both mainframe and personal computers.

Database tools include software and techniques for analyzing,maintaining,and manipulating data in a database.

A data dictionary typically includes which of the following?

A database ____ is a graphical representation of the structure of a database.

The data manipulation language ____ is a popular tool when querying a relational database.

A schema illustrates the ____ and ____ in a database and the relationships among them.

In 1986,the American National Standards Institute (ANSI)adopted ____ as the standard query language for relational databases.

SQL is one example of a data manipulation language.

A data dictionary provides a detailed description of each field and table in a database.

A popular database software program called ____ offers a wizard and QBE tool to help build and generate SQL queries.

A data definition language is used to define the ____ of a database.

Data integrity refers to the quality of data: the degree to which it is accurate and up to date.

Inaccurate input entered into a database resulting in incorrect output is also known as ____.

When a database problem occurs,its tables may be split up during the ____ process to correct a data problem.