BSAN 726 Quiz 2

________ is a set of commands used to control a database, including security. Selected Answer:DPL DML DDL DCL

DCL

INSERT INTO is an example of ________ code. DDL TIO DCL DML

DML

The main concept of relational databases was published in 1970 by: Mills. E.F.Codd. Itzak Ben-Gan. Hoffer.

E.F.Codd

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

False

DCL is used to update the database with new records.

False

The ORDER BY clause is the first statement processed in an SQL command.

False

Which of the following will produce the minimum of all standard prices? - Select min(standard_price) from Product_V; - Select Standard_Price from min(Product_V); - Select standard_price from Product_V where Standard_Price = min; - Select min(Standard_Price) from Product_V where Standard_Price = min(Standard_Price);

Select min(standard_price) from Product_V;

What result will the following SQL statement produce? Select Avg(standard_price) as average from Product_V; - The average price of all products - The average Standard_Price of all products in Product_V - The average of all products in Product_V - The mode of all prices

The average Standard_Price of all products in Product_V

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

True

Adding the DISTINCT keyword to the query eliminates duplicates

True

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

True

The ALTER TABLE command is used to change a table definition.

True

The FROM clause is the first statement processed in an SQL command. True False

True

The ORDER BY clause sorts the final results rows in ascending or descending order.

True

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') - Insert into should be INSERT to - 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.

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(n) ________ command. delete drop unpack undo

drop