Exam 5: Introduction to SQL

The following two SQL statements will produce the same results. SELECT last_name, first_name FROM customer WHERE credit_limit > 99 AND credit_limit < 10001; SELECT last_name, first_name FROM customer WHERE credit_limit BETWEEN 100 and 10000;

Requiring a CustomerID to exist in a Primary table before it can exist in a foreign table is an example of:

The SQL command ________ adds one or more new columns to a table.

________ is a set of commands used to control a database, including security.

What are some of the standard SQL functions that can be used in the SELECT clause?

How is the HAVING clause different from the WHERE clause?

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

The following two SQL statements will produce different results. SELECT last_name, first_name FROM customer WHERE state = 'MA' OR state = 'NY' OR state = 'NJ' OR state = 'NH' OR state = 'CT'; SELECT last_name, first_name FROM customer WHERE state in ('MA','NY','NJ','NH','CT');

DCL is used to update the database with new records.

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

What result will the following SQL statement produce? SELECT Avg(Standard_Price) as average from Product_V;

In databases, null values are equivalent to zero.

Which of the following is true of the order in which SQL statements are evaluated?

The following query totals sales for each salesperson. SELECT salesperson_id, sum(sales) FROM salesperson GROUP BY salesperson_id;

What will be returned when the following SQL statement is executed? SELECT driver_no,count(*) as num_deliveries FROM deliveries GROUP BY driver_no;

To eliminate duplicate rows in a query, the ________ qualifier is used in the SQL Select command.

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

Which of the following is the wildcard operator in SQL statements?

The DROP command deletes rows from a table individually or in groups.

A catalog is the structure that contains object descriptions created by a user.