Exam 2: Introduction to Structured Query Language

SQL is a ________.

The clause SELECT COUNT (*)results in a table with a single row and a single column.

The following database will be used in this question: GENERAL SALES DATABASE: SALESREP CUSTOMER Explain the use of the SQL keyword LIKE.Include an example based on the CUSTOMER table from the General Sales database;use at least one wildcard.

What is SQL?

The SQL WHERE clause contains the condition that specifies which rows are to be selected.

In an SQL query,which built-in function is used to compute the number of rows in a table?

The SQL wildcard character "%" represents a series of one or more unspecified characters.

SQL is not a complete programming language.Rather it is a data sublanguage.

An asterisk (*)following the SELECT verb means that all columns are to be displayed.

In an SQL query,which of the following symbols is used by ANSI SQL to represent a single unspecified character?

Suppose your company stores EMPLOYEE and CUSTOMER data in separate tables.If you want to find all employees who are also customers,which SQL keyword would you most likely use?

In an SQL query,which SQL keyword is used to implement a subquery?

Joins that show the matching rows from the joined tables plus unmatched rows from one other table in their results are called outer joins.

To have SQL automatically eliminate duplicate rows from a result,use the keyword DISTINCT with the FROM keyword.

To sort the rows of the result table,the ORDER BY clause is specified.

In an SQL query,which built-in function is used to compute the average value of numeric columns?

The rows of the result table can be sorted by the values in one or more columns.

The SQL syntax JOIN ...ON can be used as an alternate way of writing an SQL join statement.

The SQL wildcard character "#" indicates a single,unspecified character in a specific location in an SQL query.

To refer to a set of values needed for a condition,use the SQL IN operator.