Exam 2: Introduction to Structured Query Language

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

To obtain all columns,use an asterisk (*)wildcard character instead of listing all the column names.

While many subqueries can be alternatively written as joins,correlated subqueries do work that cannot be duplicated as a join.

Given a table with the structure: EMPLOYEE (EmpNo,Name,Salary,HireDate),which of the following would find all employees whose name begins with the letter "S" using standard SQL?

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

The SQL built-in function AVG computes the average of values in numeric columns.

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

The INTERSECT of two relations A and B consists of all rows that are in relation B but are not in relation A.

An alternative to combining tables by a subquery is to use a join.

An ad-hoc SQL query is typically written within an application program.

In an SQL query,a join operation is achieved by specifying the equality of the respective column names as a condition in the WHERE clause.

Every subquery can be alternatively expressed by a join.

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 of the following symbols is used by Microsoft Access to represent a single unspecified character?

Outer joins can be either up joins or down joins.

Based on the tables below,which of the following ANSI SQL commands would return the average customer balance grouped by SalesRepNo? GENERAL SALES DATABASE: SALESREP CUSTOMER

The SQL keyword SELECT is used to specify the columns to be listed in the query results.

Columns can be sorted in descending sequence by using the SQL DESC keyword.

When two conditions must both be true for the rows to be selected,the conditions are separated by the SQL AND keyword.

In an SQL query,the built-in functions SUM and AVG work with columns containing data of which of the following data types?