=
LIKE
BETWEEN
NOT IN
IS
<>
第1题:
Which three statements about subqueries are true?()
第2题:
Which two statements are true regarding views?()
第3题:
Which three statements about subqueries are true? ()
第4题:
Which two statements about subqueries are true? ()
第5题:
Which statement is true regarding subqueries?()
第6题:
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
第7题:
The LIKE operator cannot be used with single-row subqueries
The NOT IN operator is equivalent to IS NULL with single-row subqueries
=ANY and =ALL operators have the same functionality in multiple-row subqueries
The NOT operator can be used with IN, ANY, and ALL operators in multiple-row subqueries
第8题:
Create groups of data
Sort data in a specific order
Convert data to a different format
Retrieve data based on an unknown condition
第9题:
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.
第10题:
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.
第11题:
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.
第12题:
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.
第13题:
Which best describes an inline view? ()
第14题:
Which two statements are true regarding subqueries? ()
第15题:
Which two 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题:
lslp -a
qchk -A
enq -s ALL
lpstat -p ALL
第18题:
=
LIKE
BETWEEN
NOT IN
IS
<>
第19题:
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 table 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 a condition where the LIKE operator is used for comparison.
第20题:
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
第21题:
A single row subquery can retrieve only one column and one row.
A single row subquery can retrieve only one row but many columns.
A multiple row subquery can retrieve multiple rows and multiple columns.
A multiple row subquery can be compared by using the > operator.
A single row subquery can use the IN operator.
A multiple row subquery can use the = operator.
第22题:
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
第23题:
A subquery can retrieve zero or more rows
Only two subqueries can be placed atone level
A subquery can be used only in SQL query statements
A subquery can appear on either side of a comparison operator
There is no limit on the number of subquery levels in the WHERE clause of a SELECT statement