Quiz 2
SQL has been implemented only in the mainframe and midrange environments. True or False
False
In order to update data in SQL, one must inform the DBMS which relation, columns, and rows are involved. True or False
True
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.
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
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
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
