A database is configured to use auto

单选题 A database is configured to use automatic undo management with temporary undo enabled. Where is the UNDO stoted? 数据库配置为在启用临时撤消的情况下使用自动撤消管理。在临时表上执行更新。炉子在哪里？

A、 in the SGA

B、 in the PGA

C、 in the SYSAUX tablespace

D、 in the undo tablespace

E、 in the temporary tablespace

查看答案

下载APP答题

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

相关试题

单选题 Which compression method is recommended for Direct - Path Insert operations? 对于直接路径插入操作，建议使用哪种压缩方法？

A、COLUMN STORE COMPRESS ADVANCED

B、ROW STORE COMPRESS ADVANCED

C、COLUMN STORE COMPRESS BASIC

D、ROW STORE COMPRESS BASIC

查看答案

单选题 Examine the description of the products table 检查products表的说明

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

查看答案

单选题 Examine the description of the EMPLOYEES table NIS DATE FORMAT is set to DD - MON – YY . Which query requires explicit data type conversion? 检查EMPLOYEES表的说明NIS日期格式设置为DD-MON-YY。哪个查询需要显式数据类型转换？

A、SELECT join date FROM employees WHERE join date >'10 - 02 - 2018';

B、SELECT join date || ' '|| salary FROM employees

C、SELECT salary + '120.50' FROM employees

D、SELECT SUBSTR( join_date, 1, 2) - 10 FROM employees

E、SELECT join date + '20' FROM employees

查看答案

单选题 Examine the description of the SATES1 table SALES2 is a table with the same description as SATES1 Some sales data is contained erroneously in both tables You must display rows from sAlEs1 and SALES and wish to see the duplicates too Which set operator generates the required output? SALES2是一个与SATES1描述相同的表。两个表中都错误地包含了一些销售数据您必须显示sAlEs1和SALES中的行，并希望看到重复的行。哪个set运算符生成所需的输出？

A、MINUS

B、UNION ALL

C、SUBTRACT

D、UNION

E、INTERSECT

查看答案

单选题 In the spfile of a single instance database, LOCAL LISTENER is set to LISTENER 1. The TNSNAMES ORA file in SORACLE HOME/network/admin in the database home contains: LISTENER 1 = (ADDRESS= (PROTOCOL= TCP) (HOST =host1 abc. com) (PORT=1521) ) Which statement is true?

A、There are two listeners named LISTENER and LISTENER 1 running simultaneously using port 1521on the same host as the database instances

B、The definition for LISTENER 1 requires a CONNECT DATA section to enable dynamic service registration

C、LISTENER 1 must also be defined in the LISTENER. ORA file to enable dynamic service registration

D、The LREG process registers services dynamically with the LISTENER_1 listener

E、Dynamic service registration cannot be used for this database instance

查看答案

单选题 View the Exhibits and examine the structure of the costs and PROMOTIONS tables You want to display PROD IDS whose promotion cost is less than the highest cost PROD ID in a promotion time interval 查看展品并检查要显示促销成本小于促销时间间隔内最高成本产品ID的产品ID的成本和促销表的结构 What will be the result?

A、It executes successfully and gives the required result.

B、It gives an error because the GROUP BY clause is not valid

C、It executes successfully but does not give the required result

D、It gives an error because the ALL keyword is not valid

查看答案

单选题 Your database instance is started with an SPFILE A PFILE is also available You execute this command Where is the value changed? 您的数据库实例是用一个SPFILE启动的，如果您执行此命令，还可以使用一个PFILE ALTER SYSTEM SET数据库缓存大小=100K 值在哪里更改？

A、in the SPFILE and PFTIE

B、in the SPFILE, PFILE, and memory

C、only in the SPFILE

D、in the SPFILE and in memory

E、only in memory

查看答案

单选题 Which is the default column or columns for sorting output from compound queries using SET operators such as INTERSECT in a SQL statement? 使用集合运算符（如SQL语句中的INTERSECT）对复合查询的输出进行排序时，默认列是哪列？

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

查看答案