Quiz 2

The benefits of a standardized relational language include: • application longevity. • reduced training costs. • cross-system communication. • All of these.

All of these

A database is maintained and queried using the data mapping language (DML). True or False

False

DCL is used to update the database with new records. True or Flase

False

Indexes generally slow down access speed in most RDMS. True or False

False

SQL has been implemented only in the mainframe and midrange environments. True or False

False

A database table is defined using the data definition language (DDL). True or False

True

A major benefit of SQL as a standard is reduced training costs. True or False

True

An insert command does not need to have the fields listed. True or False

True

In order to update data in SQL, one must inform the DBMS which relation, columns, and rows are involved. True or False

True

One of the original purposes of the SQL standard was to provide a vehicle for portability of database definition and application modules between conforming DBMSs. True or Flase

True

SQL is both an American and international standard for database access. True or False

True

In an SQL statement, which of the following parts states the conditions for row selection? • Select • From • Where • Group by

Where

Given a table named store with 5 fields: store_id, address, city, state, zipcode, why would the following insert command not work? insert into store values ('234 Park Street') • It would work just fine. • You must specify the fields to insert if you are only inserting some of the fields. • There is no table keyword. • None of these.

You must specify the fields to insert if you are only inserting some of the fields.

Any create command may be reversed by using a ________ command. • truncate • drop • delete • unpack

drop

Indexes are created in most RDBMSs to: • provide a quicker way to store data. • decrease the amount of disk space utilized. • provide rapid random and sequential access to base-table data. • increase the cost of implementation.

provide rapid random and sequential access to base-table data.