Quiz 2 (Week 201)

DML (Data manipulation language)

-IMPLEMENTATION core commands of SQL -updating -inserting -modifying -querying the data in the database

DCL (Data control language)

-Maintenance and implementation -command to control database -admin privileges -committing (saving) data EX GRANT,ADD,REVOKE

standardized relational language SQL standard benefits

1. reduced training cost 2. productivity 3. Application portability 4. Application longevity 5.reduced dependence on single vendor 6. cross-system communication

Any create command may be reversed by using a ________ command. A. truncate B. drop C. delete D. unpack

B

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') A. It would work just fine. B. You must specify the fields to insert if you are only inserting some of the fields. C. There is no table keyword. D. None of these

B

In an SQL statement, which of the following parts states the conditions for row selection? A. SELECT B. WHERE C.GROUP BY

B.

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

C

Create command

DDL

A database is maintained and queried using the data manipulation language (DML) True False

False

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

False

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

False

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

False

DDL (Data definition language)

PHYSICAL DESIGN AND Maintenance -define the database -CREATE tables,indexes, views -Establish Foreign keys -manipulate the database SELECT

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

True

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

True

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

True

In order to update data in SQL, one must inform the DBMS which relation, columns, and rows are involved. True 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 False

True

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

True

SQL standard

provide directions for development of relational databases 1. specify syntax of SQL data definitions + manipulation languages 2. define data structures + basic operations for designing controlling etc SQL databases 3. portability of database definition and application modules between conforming DBMS 4. specify minimal Level 1 + complete level 2 standards ..allows different versions of products 5. to have an initial standard that can be altered later