a schema object
a subquery that can contain an ORDER BY clause
another name for a view that contains group functions
a subquery that is part of the FROM clause of another query
第1题:
Click the Exhibit button and examine the data in the EMPLOYEES table.Examine the subquery:SELECT last_nameFROM employeesWHERE salary IN (SELECT MAX(salary)FROM employeesGROUP BY department_id);Which statement is true?()
A.The SELECT statement is syntactically accurate.
B.The SELECT statement does not work because there is no HAVING clause.
C.The SELECT statement does not work because the column specified in the GROUP BY clause is not in the SELECT list.
D.The SELECT statement does not work because the GROUP BY clause should be in the main query and not in the subquery.
第2题:
Which of the following abilities does a view NOT provide?()
第3题:
Which two statements about subqueries are true? ()
第4题:
In which four clauses can a subquery be used? ()
第5题:
Which two statements are true regarding subqueries? ()
第6题:
Which best describes an inline view?()
第7题:
Top N analysis requires () and ().
第8题:
A main query can have more than one subquery.
A subquery can have more than one main query.
The subquery and main query must retrieve data from the same table.
The subquery and main query can retrieve data from different tables.
Only one column or expression can be compared between the subquery and main query.
Multiple columns or expression can be compared between the subquery and main query.
第9题:
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
第10题:
A single row subquery can retrieve data from only one table.
A SQL query statement cannot display data from table B that is referred to in its subquery, unless table B is included in the main query's FROM clause.
A SQL query statement can display data from table B that is referred to in its subquery, without including B in its own FROM clause.
A single row subquery can retrieve data from more than one table.
A single row subquery cannot be used in a condition where the LIKE operator is used for comparison.
A multiple-row subquery cannot be used in an INSERT statement to insert multiple rows at a time.
第11题:
A subquery that defines a view cannot include the GROUP BY clause
A view that is created with the subquery having the DISTINCT keyword can be updated
A view that is created with the subquery having the pseudo column ROWNUM keyword cannot be updated
A data manipulation language (DML) operation can be performed on a view that is created with the subquery having all the NOT NULL columns of a table
第12题:
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.
第13题:
Which three statements are true regarding subqueries?()
第14题:
Which two statements are true regarding views?()
第15题:
Which three statements about subqueries are true? ()
第16题:
You define a multiple-row subquery in the WHERE clause of an SQL query with a comparison operator "=". What happens when the main query is executed? ()
第17题:
Which two statements about subqueries are true?()
第18题:
Which two statements about views are true?()
第19题:
a schema object
a subquery that can contain an ORDER BY clause
another name for a view that contains group functions
a subquery that is part of the FROM clause of another query
第20题:
A view can be created as read only.
A view can be created as a join on two or more tables.
A view cannot have an ORDER BY clause in the SELECT statement.
A view cannot be created with a GROUP BY clause in the SELECT statement.
A view must have aliases defined for the column names in the SELECT statement.
第21题:
The main query executes with the first value returned by the subquery.
The main query executes with the last value returned by the subquery.
The main query executes with all the values returned by the subquery.
The main query fails because the multiple-row subquery cannot be used with the comparison operator.
You cannot define a multiple-row subquery in the WHERE clause of a SQL query.
第22题:
A subquery should retrieve only one row.
A subquery can retrieve zero or more rows.
A subquery can be used only in SQL query statements.
Subqueries CANNOT be nested by more than two levels.
A subquery CANNOT be used in an SQL query statement that uses group functions.
When a subquery is used with an inequality comparison operator in the outer SQL statement, the column list in the SELECT clause of the subquery should contain only one column.
第23题:
Subqueries can contain GROUP BY and ORDER BY clauses
Main query and subquery can get data from different tables
Main query and subquery must get data from the same tables
Subqueries can contain ORDER BY but not the GROUP BY clause
Only one column or expression can be compared between the main query and subquery
Multiple columns or expressions can be compared between the main query and subquery
第24题:
the use of rowid
a GROUP BY clause
an ORDER BY clause
only an inline view
an inline view and an outer query