Question 1

A popular database software program called ____ offers a wizard and QBE tool to help build and generate SQL queries.&#10;A) MS Excel&#10;B) MS Data Manager&#10;C) MS Access&#10;D) ANSI

Accepted Answer

MS Access is the popular database software program that offers a wizard and QBE tool to help build and generate SQL queries. MS Excel is a spreadsheet software, MS Data Manager is not a valid program, and ANSI is not a software program but a standard for SQL.

Question 2

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

Accepted Answer

A database schema can be a standalone file or it can be part of a larger database.

Question 3

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

Accepted Answer

A data dictionary serves as a comprehensive reference guide to the data contained within a database, including descriptions of each field and the relationships between tables.

Question 4

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

Accepted Answer

Data integrity is defined as the accuracy, completeness, and reliability of data throughout its lifecycle. It is an essential component of data quality, and it ensures that the data is trustworthy, consistent and accurate. Therefore, Option A is correct.

Question 5

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.

Accepted Answer

The first step in creating a database is actually to design the structure and layout of the tables that will hold the data. Only after the tables are created can queries and reports be built to pull information from the data.

Question 6

The ____ data manipulation language is used to build databases in both mainframe and personal computers.&#10;A) SLQ&#10;B) DDL&#10;C) SQL&#10;D) DLD

Accepted Answer

SQL (Structured Query Language) is a standardized language used for managing and manipulating databases on a wide range of platforms, including mainframes and personal computers. It allows users to create, modify, and query databases, making it an essential tool for database management. The other options (SLQ, DDL, DLD) are not valid data manipulation languages.

Question 7

A data dictionary typically includes which of the following?&#10;A) the names of data items&#10;B) a copy of the actual data&#10;C) an alphabetical listing of records&#10;D) the digital certificate

Accepted Answer

A data dictionary typically includes the names of data items and their definitions, but does not typically include a copy of the actual data, an alphabetical listing of records, or the digital certificate.

Question 8

Query wizards and ____ automate the process of writing SQL commands in a relational database.&#10;A) DDL&#10;B) PHP&#10;C) Query by Example (QBE)&#10;D) DML

Accepted Answer

Query by Example (QBE) is a visual way of creating SQL commands by selecting tables, fields, and conditions from a graphical user interface. QBE is used in query wizards to simplify the process of writing SQL commands.

Question 9

SQL is one example of a data manipulation language.

Accepted Answer

SQL, or Structured Query Language, is specifically designed for working with relational databases and is used to manipulate and manage data within them. As such, it is a widely used data manipulation language.

Question 10

A data definition language is used to define the ____ of a database.&#10;A) QBE&#10;B) data and relationships&#10;C) size&#10;D) model

Accepted Answer

A data definition language (DDL) is used to define the data and relationships within a database. It is used to create, alter, and delete tables, indexes, and constraints within a database. QBE (Query By Example) is a graphical user interface for performing database queries, it is not a DDL. Size is not defined by a DDL, but can be affected by the definition of the data and relationships within the database. The model can refer to the overall design or structure of the database, but the DDL specifically focuses on defining the data and relationships.

Question 11

A schema illustrates the ____ and ____ in a database and the relationships among them.&#10;A) records and fields&#10;B) bits and bytes&#10;C) tables and fields&#10;D) rows and columns

Accepted Answer

The answer of A schema illustrates the ____ and ____...

Question 12

The data manipulation language ____ is a popular tool when querying a relational database.&#10;A) SQL&#10;B) C++&#10;C) HTML&#10;D) CSS

Accepted Answer

The answer of The data manipulation language ____ is a...

Question 13

Inaccurate input entered into a database resulting in incorrect output is also known as ____.&#10;A) data failure&#10;B) GIGO&#10;C) data redundancy&#10;D) normalized data

Accepted Answer

The answer of Inaccurate input entered into a database resulting...

Question 14

A database ____ is a graphical representation of the structure of a database.&#10;A) schema&#10;B) index&#10;C) data type&#10;D) DDL

Accepted Answer

The answer of A database ____ is a graphical representation...

Question 15

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

Accepted Answer

The answer of Database tools include software and techniques for...

Question 16

In 1986,the American National Standards Institute (ANSI)adopted ____ as the standard query language for relational databases.&#10;A) QBE&#10;B) DDL&#10;C) Schema&#10;D) SQL

Accepted Answer

The answer of In 1986,the American National Standards Institute (ANSI)adopted...

Question 17

When a database problem occurs,its tables may be split up during the ____ process to correct a data problem.&#10;A) GIGO&#10;B) visualization&#10;C) normalization&#10;D) data integrity

Accepted Answer

The answer of When a database problem occurs,its tables may...

Deck 66: Database Tools