网友您好， 请在下方输入框内输入要搜索的题目：
题目内容
（请给出正确答案）
多选题
Which three statements are true regarding subqueries?（）
A
Subqueries can contain GROUP BY and ORDER BY clauses
B
Main query and subquery can get data from different tables
C
Main query and subquery must get data from the same tables
D
Subqueries can contain ORDER BY but not the GROUP BY clause
E
Only one column or expression can be compared between the main query and subquery
F
Multiple columns or expressions can be compared between the main query and subquery
参考答案
参考解析
解析：
暂无解析
更多 “多选题Which three statements are true regarding subqueries?（）ASubqueries can contain GROUP BY and ORDER BY clausesBMain query and subquery can get data from different tablesCMain query and subquery must get data from the same tablesDSubqueries can contain ORDER BY but not the GROUP BY clauseEOnly one column or expression can be compared between the main query and subqueryFMultiple columns or expressions can be compared between the main query and subquery” 相关考题
考题
Which of the statements regarding benefit-cost analysis in the Special window are true?A . 1 and 2B . 2 and 3C . 1 and 3D . 1, 2 and 3E . None of the above.
考题
134 Which of the statements regarding benefit-cost analysis in the Special window are true?A. 1 and 2B. 2 and 3C. 1 and 3D. 1, 2 and 3E. None of the above
考题
Which three statements are true regarding the use of the Database Migration Assistant for Unicode(DMU)?()
A. A DBA can check specific tables with the DMUB. The database to be migrated must be opened read-only.C. The release of the database to be converted can be any release since 9.2.0.8.D. The DMU can report columns that are too long in the converted characterset.E. The DMU can report columns that are not represented in the converted characterset.
考题
Which two statements are true regarding L2TP? ()(Choose two.)
A. Tunnels are initiated by the LACB. Tunnels are initiated by the LNSC. By default, subscriber authentication occurs on the LNSD. By default, subscriber authentication occurs on the LAC
考题
Which two statements are true regarding the USING clause in table joins?（）A、It can be used to join a maximum of three tables B、It can be used to restrict the number of columns used in a NATURAL join C、It can be used to access data from tables through equijoins as well as nonequijoins D、It can be used to join tables that have columns with the same name and compatible data types
考题
Which of the following statements is true regarding the VERSIONS BETWEEN clause？（） A、 The VERSIONS BETWEEN clause may be used in DML statements.B、 The VERSIONS BETWEEN clause may be used in DDL statements.C、 The VERSIONS BETWEEN clause may not be used to query past DDL changes to tables.D、 The VERSIONS BETWEEN clause may not be used to query past DML statements to tables.
考题
Which statement is true regarding the INTERSECT operator?（）A、It ignores NULL values B、Reversing the order of the intersected tables alters the result C、The names of columns in all SELECT statements must be identical D、The number of columns and data types must be identical for all SELECT statements in the query
考题
Which three statements are true regarding subqueries?（）A、Subqueries can contain GROUP BY and ORDER BY clauses B、Main query and subquery can get data from different tables C、Main query and subquery must get data from the same tables D、Subqueries can contain ORDER BY but not the GROUP BY clause E、Only one column or expression can be compared between the main query and subqueryF、 Multiple columns or expressions can be compared between the main query and subquery
考题
Which three statements about subqueries are true?（）A、A single row subquery can retrieve only one column and one row.B、A single row subquery can retrieve only one row but many columns.C、A multiple row subquery can retrieve multiple rows and multiple columns.D、A multiple row subquery can be compared by using the “” operator.E、A single row subquery can use the IN operator.F、A multiple row subquery can use the “=” operator.
考题
Which two statements are true regarding L2TP? （）(Choose two.)A、Tunnels are initiated by the LACB、Tunnels are initiated by the LNSC、By default, subscriber authentication occurs on the LNSD、By default, subscriber authentication occurs on the LAC
考题
Which three statements are true regarding the use of the Database Migration Assistant for Unicode(DMU)?（）A、A DBA can check specific tables with the DMUB、The database to be migrated must be opened read-only.C、The release of the database to be converted can be any release since 9.2.0.8.D、The DMU can report columns that are too long in the converted characterset.E、The DMU can report columns that are not represented in the converted characterset.
考题
Which two statements are true regarding subqueries? （）A、A subquery can retrieve zero or more rows B、Only two subqueries can be placed atone level C、A subquery can be used only in SQL query statements D、A subquery can appear on either side of a comparison operator E、There is no limit on the number of subquery levels in the WHERE clause of a SELECT statement
考题
Which two statements about subqueries are true? （）A、A subquery should retrieve only one row.B、A subquery can retrieve zero or more rows.C、A subquery can be used only in SQL query statements.D、Subqueries CANNOT be nested by more than two levels.E、A subquery CANNOT be used in an SQL query statement that uses group functions.F、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.
考题
Examine the following statement that is used to modify the constraint on the SALES table： SQL ALTER TABLE SALES MODIFY CONSTRAINT pk DISABLE VALIDATE； Which three statements are true regarding the above command（）A、The constraint remains valid.B、The index on the constraint is dropped.C、It allows the loading of data into the table using SQL*Loader.D、New data conforms to the constraint， but existing data is not checkedE、It allows the data manipulation on the table using INSERT/UPDATE/DELETE SQL statements.
考题
Which three statements about subqueries are true? （）A、Asinglerowsubquerycanretrieveonlyonecolumnandonerow.B、Asinglerowsubquerycanretrieveonlyonerowbutmanycolumns.C、Amultiplerowsubquerycanretrievemultiplerowsandmultiplecolumns.D、Amultiplerowsubquerycanbecomparedusingthe"；；"；operator.E、AsinglerowsubquerycanusetheINoperator.F、Amultiplerowsubquerycanusethe"；="；operator.
考题
Which statements are true regarding the Query Result Cache? （）A、It can be set at the system, session, or table level.B、It is used only across statements in the same session.C、It can store the results from normal as well as flashback queries.D、It can store the results of queries based on normal, temporary, and dictionary tables.
考题
Which statement is true regarding subqueries?（）A、The LIKE operator cannot be used with single-row subqueries B、The NOT IN operator is equivalent to IS NULL with single-row subqueries C、=ANY and =ALL operators have the same functionality in multiple-row subqueries D、The NOT operator can be used with IN, ANY, and ALL operators in multiple-row subqueries
考题
多选题Which two statements are true regarding the use of UTF-16 encoding？ （）AEnables easier loading of multinational data.BUses a fixed-width Multibyte encoding sequence.CAsian characters are represented in three characters.DUsed a variable-width Multibyte encoding sequence.EEuropean characters are represented on one or two bytes.
考题
多选题Which two statements are true regarding the execution of the correlated subqueries？（）AThe nested query executes after the outer query returns the row.BThe nested query executes first and then the outer query executes.CThe outer query executes only once for the result returned by the inner query.DEach row returned by the outer query is evaluated for the results returned by the inner query.
考题
单选题Which statement is true regarding subqueries?（）A
The LIKE operator cannot be used with single-row subqueries B
The NOT IN operator is equivalent to IS NULL with single-row subqueries C
=ANY and =ALL operators have the same functionality in multiple-row subqueries D
The NOT operator can be used with IN, ANY, and ALL operators in multiple-row subqueries
考题
多选题Examine the following statement that is used to modify the constraint on the SALES table： SQL ALTER TABLE SALES MODIFY CONSTRAINT pk DISABLE VALIDATE； Which three statements are true regarding the above command（）AThe constraint remains valid.BThe index on the constraint is dropped.CIt allows the loading of data into the table using SQL*Loader.DNew data conforms to the constraint， but existing data is not checkedEIt allows the data manipulation on the table using INSERT/UPDATE/DELETE SQL statements.
考题
多选题Which three statements are true regarding the fine-grained auditing （FGA）？（）AFGA is possible on SELECT statements only.BThe audit trail for FGA is stored in the FGA_LOG$ table.CThe audit trail for FGA is stored in the AUD_LOG$ table.DFGA enables a SQL predicate to define when to audit an event.EFGA audits DELETE statements only when audit columns are specified.FFGA includes the SQL statement used by the user as part of the audit event entry.
考题
多选题Which three statements about subqueries are true? （）AAsinglerowsubquerycanretrieveonlyonecolumnandonerow.BAsinglerowsubquerycanretrieveonlyonerowbutmanycolumns.CAmultiplerowsubquerycanretrievemultiplerowsandmultiplecolumns.DAmultiplerowsubquerycanbecomparedusingthe；；；operator.EAsinglerowsubquerycanusetheINoperator.FAmultiplerowsubquerycanusethe；=；operator.
考题
单选题Which statement is true regarding the INTERSECT operator?（）A
It ignores NULL values B
Reversing the order of the intersected tables alters the result C
The names of columns in all SELECT statements must be identical D
The number of columns and data types must be identical for all SELECT statements in the query
考题
单选题Which of the following statements is true regarding the VERSIONS BETWEEN clause？（）A
The VERSIONS BETWEEN clause may be used in DML statements.B
The VERSIONS BETWEEN clause may be used in DDL statements.C
The VERSIONS BETWEEN clause may not be used to query past DDL changes to tables.D
The VERSIONS BETWEEN clause may not be used to query past DML statements to tables.
考题
多选题Which two statements are true regarding subqueries? （）AA subquery can retrieve zero or more rowsBOnly two subqueries can be placed atone levelCA subquery can be used only in SQL query statementsDA subquery can appear on either side of a comparison operatorEThere is no limit on the number of subquery levels in the WHERE clause of a SELECT statement
考题
多选题Which three statements are true regarding the logical structure of the Oracle database？（）AEach segment contains one or more extents.BMultiple tablespaces can share single data file.CA data block is the smallest unit of I/O for data files.DIt is possible to have tablespaces of different block sizes in a database.EEach data block in the database always corresponds to one OS block.
热门标签
最新试卷
