单选题 12.【单选题】Which is the default column or columns for sorting output from compound queries using SET operators such as INTERSECT in a SQL statement?

A、 the first NUMBER or VARCHAR2 column in the last select of the compound query

B、 the first NUMBER column in the first select of the compound query

C、 the first vARCHAR2 column in the first select of the compound query

D、 the first column in the first select of the compound query

E、 the first column in the last selects of the compound query

由4l***0r提供分享举报纠错

相关试题

单选题 3.【单选题】A database is configured to use automatic undo management with temporary undo enabled An UPDATE is executed on a temporary table Where is the UNDO stored?

A、in the undo tablespace

B、in the SYSAUX tablespace

C、in the SGA

D、in the PGA

E、in the temporary tablespace

查看答案

单选题 8.【单选题】You want to use table compression suitable for OLTP that will: 1)Compress rows for all DML statements on that table 2) Minimize the overheads associated with compression Which compression option is best suited for this?

A、COLUMN STORE COMPRESS FOR QUERY LOW

B、ROW STORE COMPRESS BASIC

C、COLUMN STORE COMPRESS FOR ARCHIVE LOW

D、COLUMN STORE COMPRESS FOR ARCHIVE HIGH

E、ROW STORE COMPRESS ADVANCED

查看答案

单选题 7.【单选题】You want to write a query that prompts for two column names and the WHERE condition each time it Is Executed in a session but only prompts for the table name the first time it is executed The variables used in your query are never undefined in your session Which query can be used?

A、SELECT &&col 1 &&co 2FROM &table WHERE &&condition=&&cond

B、SELECT &col 1 &COI2FROM &&table WHERE &condition

C、SELECT &col 1 &CO12FROM &table WHERE &condition

D、ELECT&&col 1&&co FROM &table WHERE&&condition=&cond

E、SELECT &&col 1 &&COL2FROM &table WHERE &&condition

查看答案

单选题 4.【单选题】What is true about non-equijoin statement performance?

A、The join syntax used makes no difference to performance.

B、The BETWEEN condition used with an non-equijoin sometimes performs better than using the >=and<= conditions

C、The BETWEEN condition used with an non-equijoin always performs better than when using the>=and <= conditions

D、The Oracle join syntax performs better than the sol: 1999 compliant ANSI join syntax

E、The Oracle join syntax performs less well than the sol: 1999 compliant ANSI join syntax

查看答案

单选题 1. 【单选题】 Examine the description of the products table

A、

SELECT prod id, AVG(MAX (cost)) FROM products GROUP BY prod.

B、

SELECT prod id, MAX (AVG (cost)) FROM products GROUP BY prod id:

C、

Select prod id, release date, SUM(cost) FROM products GROUP BY prod id

D、

SELECT prod id, release date, SUM(cost) FROM products GROUP BY prod id, release date

查看答案

单选题 6.【单选题】Your database instance is started with a PFILE.Examine these parameters:You want to increase the size of the buffer cache. Free memory is available to increase the size of the buffer cache. You execute the command: SQL> ALTER SYSTEM SETDB_CACHE_SIZE= 1024M;What is the outcome?

A、The value is changed only in the PFILE and takes effect at the next instance startup

B、The value is changed for the current instance and in the PFILE

C、It fails because the SCOPE clause is missing

D、Change is applied to the current instance, but does not persist after instance restart

查看答案

单选题 5.【单选题】Examine the description of the PRODUCT INEORMATTON tableWhich query retrieves the number of products with a null list price?

A、SELECT COUNT(list price) FROM product information WHERE list price NULL

B、SELECT COUNT(list price) FROM product information WHERE list price Is NULL,

C、SELECT COUNT(DISTINCT list price) PROM product information WHERE list price Is NULL:

D、SELECT COUNT(NVL(list price, 0)) FROM product information WHERE list price IsNULL

查看答案

单选题 2.【单选题】Which statement is true about the INTERSECT operator used in compound queries?

A、Multiple INTERSECT operators are not possible in the same SQL statement

B、It processes NULLS in the selected columns

C、INTERSECT is of lower precedence than UNION or UNION ALL

D、It ignores NULLS

查看答案