Exam 2: Introduction to Structured Query Language SQL

Given the table CUSTOMER(CustID,Name,PhoneNumber,AccountBalance),write the standard SQL query to retrieve the Name and Phone Number of customers whose name begins with 'S'.

When one SQL query is embedded in another SQL query,the second SQL query is embedded in the ________ of the first query.

The Microsoft Access wildcard character "_" (underscore)indicates a single,unspecified character in a specific location in a Microsoft Access SQL query.

In an SQL query,which SQL keyword is used with GROUP BY to select groups meeting specified criteria?

When people use the term "join" they normally mean an "equijoin."

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

In an SQL query,which SQL keyword is used to specify the table(s)to be used?

In an SQL query,which SQL keyword is used to state the condition that specifies which rows are to be selected?

Arithmetic in SQL statements is limited to the operations provided by the built-in functions.

In an SQL query,which SQL keyword is used to specify the names of tables to be joined?

In an SQL query,which SQL keyword is used to sort the result table by the values in one or more columns?

In an SQL query,which SQL keyword actually creates the query?

The condition in WHERE clauses can refer to a set of values by using the IN operator.

Every subquery can be alternatively expressed by a join.

In addition to being a data sublanguage,SQL is also a programming language,like Java or C#.

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

In an SQL query,which of the following symbols is used by ANSI SQL to represent all the columns in a single table?

In an SQL query,which built-in function is used to total numeric columns?

A WHERE clause can contain another SELECT statement enclosed in parentheses.

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