Immediately after the SELECT clause
Before the WHERE clause
Before the FROM clause
After the ORDER BY clause
After the WHERE clause
第1题:
A. The SQL statement displays the desired results.
B. The column in the WHERE clause should be changed to display the desired results.
C. The operator in the WHERE clause should be changed to display the desired results.
D. The WHERE clause should be changed to use an outer join to display the desired results.
第2题:
Evaluate this SQL statement: SELECT e.emp_name, d.dept_name FROM employees e JOIN departments d USING (department_id) WHERE d.department_id NOT IN (10,40) ORSER BY dept_name; The statement fails when executed. Which change fixes the error? ()
第3题:
You need to display the last names of those employees who have the letter "A" as the second character in their names.Which SQL statement displays the required results?()
第4题:
Where can subqueries be used?()
第5题:
Which clause would you use in a SELECT statement to limit the display to those employees whose salary is greater then 5000? ()
第6题:
field names in the SELECT statement
the FROM clause in the SELECT statement
the HAVING clause in the SELECT statement
the GROUP BY clause in the SELECT statement
the WHERE clause in only the SELECT statement
the WHERE clause in SELECT as well as all DML statements
第7题:
The sort is in ascending by order by default.
The sort is in descending order by default.
The ORDER BY clause must precede the WHERE clause.
The ORDER BY clause is executed on the client side.
The ORDER BY clause comes last in the SELECT statement.
The ORDER BY clause is executed first in the query execution.
第8题:
in the INTO clause of an INSERT statement
in the FROM clause of a SELECT statement
in the GROUP BY clause of a SELECT statement
in the WHERE clause of a SELECT statement
in the SET clause of an UPDATE statement
in the VALUES clause of an INSERT statement
第9题:
remove the ORDER BY clause
remove the table alias prefix from the WHERE clause
remove the table alias from the SELECT clause
prefix the column in the USING clause with the table alias
prefix the column in the ORDER BY clause with the table alias
replace the condition d.department_id NOT IN (10,40) in the WHERE clause with d.department_id <> 10 AND d.department_id <> 40
第10题:
The SQL statement displays the desired results.
The column in the WHERE clause should be changed to display the desired results.
The operator in the WHERE clause should be changed to display the desired results.
The WHERE clause should be changed to use an outer join to display the desired results.
第11题:
In which four clauses can a subquery be used?()
第12题:
The accounts receivable department requested an accounts status to allow users to enter either a customer name, customer number, customer phone number and then display the customer out standing balance. You want to restrict the data retrieved based on values entered by the users. Which where clause would you write in the query to select statement to accomplish this task?()
第13题:
Which two statements are true regarding the ORDER BY clause? ()
第14题:
In a SELECT statement that includes a WHERE clause, where is the GROUP BY clause placed in the SELECT statement?()
第15题:
Which SQL statement accepts user input for the columns to be displayed, the table name, and the WHERE condition?()
第16题:
The statement executes successfully and returns the student ID and sum of all marks for each student who obtained more than the average mark in each subject.
The statement returns an error at the SELECT clause.
The statement returns an error at the WHERE clause.
The statement returns an error at the ORDER BY clause.
第17题:
The SQL statement displays the desired results.
The column in the WHERE clause should be changed to display the desired results.
The operator in the WHERE clause should be changed to display the desired results.
The WHERE clause should be changed to use an outer join to display the desired results.
第18题:
You can use aggregate functions in any clause of a SELECT statement.
You can use aggregate functions only in the column list of the select clause and in the WHERE clause of a SELECT statement.
You can mix single row columns with aggregate functions in the column list of a SELECT statement by grouping on the single row columns.
You can pass column names, expressions, constants, or functions as parameter to an aggregate function.
You can use aggregate functions on a table, only by grouping the whole table as one single group.
You cannot group the rows of a table by more than one column while using aggregate functions.
第19题:
The SQL statement displays the desired results.
The column in the WHERE clause should be changed to display the desired results.
The operator in the WHERE clause should be changed to display the desired results.
The WHERE clause should be changed to use an outer join to display the desired results.
第20题:
The SELECT statement is syntactically accurate.
The SELECT statement does not work because there is no HAVING clause.
The SELECT statement does not work because the column specified in the GROUP BY clause is not in the SELECT list.
The SELECT statement does not work because the GROUP BY clause should be in the main query and not in the subquery.