多选题Which two statements regarding a SQL profile are true?（）AIt is built by Automatic Tuning Optimizer.BIt cannot be stored persistently in the data dictionary.CIt can be used by the query optimizer automatically.DIt can be created manually by using the CR

题目内容(请给出正确答案)

多选题

Which two statements regarding a SQL profile are true?（）

It is built by Automatic Tuning Optimizer.

It cannot be stored persistently in the data dictionary.

It can be used by the query optimizer automatically.

It can be created manually by using the CREATE PROFILE command.

如果没有搜索结果或未解决您的问题，请直接联系老师获取答案。

更多相关问题

第1题

多选题Which two statements regarding a SQL profile are true？（）AIt is built by Automatic Tuning Optimizer.BIt cannot be stored persistently in the data dictionary.CIt can be used by the query optimizer automatically.DIt can be created manually by using the CREATE PROFILE command.

点击查看答案
第2题

多选题Examine the following output： SQL> SELECT index_name，status FROM dba_indexes WHERE status=’UNUSABLE’； INDEX_NAME STATUS------------------------------ ----------- EIND UNUSABLE Which two statements about the above index are true（）AIt is ignored by the query optimizer.BIt is not used while the index is being rebuilt.CThe index cannot be rebuilt， and has to be re-created.DThe index is automatically rebuilt when used the next time

点击查看答案
第3题

多选题Which two statements about subqueries are true? （）AA single row subquery can retrieve data from only one table.BA 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.CA SQL query statement can display data from table B that is referred to in its subquery, without including B in its own FROM clause.DA single row subquery can retrieve data from more than one table.EA single row subquery cannot be used in a condition where the LIKE operator is used for comparison.FA multiple-row subquery cannot be used in an INSERT statement to insert multiple rows at a time.

点击查看答案
第4题

多选题Which two statements about subqueries are true? （）AA subquery should retrieve only one row.BA subquery can retrieve zero or more rows.CA subquery can be used only in SQL query statements.DSubqueries CANNOT be nested by more than two levels.EA subquery CANNOT be used in an SQL query statement that uses group functions.FWhen 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.

点击查看答案
第5题

多选题Which statements are true regarding the Query Result Cache？（）AIt can be set at the system， session， or table level.BIt is used only across statements in the same session.CIt can store the results from normal as well as flashback queries.DIt can store the results of queries based on normal，temporary，and dictionary tables.

点击查看答案
第6题

多选题Which two statements are true regarding views?（）AA subquery that defines a view cannot include the GROUP BY clauseBA view that is created with the subquery having the DISTINCT keyword can be updatedCA view that is created with the subquery having the pseudo column ROWNUM keyword cannot be updatedDA 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题

多选题Which two statements are true regarding the ORDER BY clause? （）AIt is executed first in the query executionBIt must be the last clause in the SELECT statementCIt cannot be used in a SELECT statement containing a HAVING clauseDYou cannot specify a column name followed by an expression in this clauseEYou can specify a combination of numeric positions and column names in this clause

点击查看答案

多选题Which two statements regarding a SQL profile are true?（）AIt is built by Automatic Tuning Optimizer.BIt cannot be stored persistently in the data dictionary.CIt can be used by the query optimizer automatically.DIt can be created manually by using the CR

题目内容(请给出正确答案)

更多相关问题

第1题

第2题

第3题

第4题

第5题

第6题

第7题

相关内容