The EMP table exists in your schema. Y...

多项选择题X 纠错

The EMP table exists in your schema. You want to execute the following query:
SELECT ename, sal
FROM emp
AS OF TIMESTAMP (SYSTIMESTAMP - INTERVAL '6' MINUTE)
WHERE ename = 'ALLEN';
What are the minimum requirements for the statement to execute successfully? （）

A. ARCHIVELOG mode must be enabled
B. Row Movement must be enabled for the table
C. FLASHBACK must be set to ON for the database
D. The UNDO_MANAGEMENT parameter must be set to AUTO
E. The UNDO_RETENTION parameter must be set appropriately

参考答案：

进入题库练习

查答案就用赞题库小程序还有拍照搜题语音搜题快来试试吧

无需下载立即使用

你可能喜欢

单项选择题

You have three temporary tablespace groups named G1, G2, and G3 in your database. You are creating a new temporary tablespace as follows:
CREATE TEMPORARY TABLESPACE TEMP1 TEMPFILE '/u1/data/temp1.dbf' SIZE 10M
TABLESPACE GROUP '';
Which statement regarding the above command is correct?（）

A. It will create the tablespace TEMP1 in group G1.
B. It will create the tablespace TEMP1 in group G3.
C. It will not add the tablespace TEMP1 to any group.
D. It will create the tablespace TEMP1 in the default group.

点击查看答案进入题库练习

多项选择题

On which two database objects can the VERSIONS clause of the Flashback Versions Query be used?（）

A. fixed tables
B. heap tables
C. external tables
D. temporary tables
E. Index-Organized Tables (IOTs)

点击查看答案进入题库练习

多项选择题

Which two initialization parameters would you set to enable Automatic Shared Memory Management?（）

A. set SHARED_POOL_SIZE to zero
B. set STATISTICS_LEVEL to BASIC
C. set SGA_TARGET to a non-zero value
D. set DB_CACHE_SIZE to a non-zero value
E. set STATISTICS_LEVEL to TYPICAL or ALL

点击查看答案进入题库练习

单项选择题

An online tablespace, TEST_TBS, is full and you realize that no server-managed tablespace threshold alerts were generated for the TEST_TBS tablespace. What could be the reason, if the TEST_TBS tablespace does not include autoextensible data files?（）

A. TEST_TBS is a small file tablespace.
B. TEST_TBS is a bigfile tablespace (BFT).
C. TEST_TBS is the default temporary tablespace.
D. TEST_TBS is a dictionary-managed tablespace.

点击查看答案进入题库练习

单项选择题

Which method would you use to undo the changes made by a particular transaction without affecting the changes made by other transactions?（）

A. point-in-time recovery
B. execute the ROLLBACK command with transaction number
C. flashback the database to before the transaction was committed
D. determine all the necessary undo SQL statements from FLASHBACK_TRANSACTION_QUERY and use them for recovery

点击查看答案进入题库练习

单项选择题

Which of the following advisors within the Oracle advisory framework will analyze a single SQL statement and make recommendations for performance improvement?（）

A. SQL Repair Advisor
B. SQL Optimizer
C. SQL Access Advisor
D. SQL Tuning Advisor SQL

点击查看答案进入题库练习

多项选择题

For which two situations would you use functionality provided by the Resource Manager?（）

A. setting idle timeout limits on resource plans
B. saving storage space by using compressed backup sets
C. creating jobs that will run automatically at a scheduled time
D. assigning priorities to jobs to manage access to system resources
E. creating alerts to perform notification when tablespaces are low on available space resources

点击查看答案进入题库练习

单项选择题

You have not configured Oracle Managed Files (OMF) in your database. You do not want to scan the entire datafile every time an incremental backup is performed. You decide to enable the block change tracking feature. Which statement should you use to enable the block change tracking feature?（）

A. ALTER DATABASE ENABLE BLOCK CHANGE TRACKING;
B. ALTER SYSTEM ENABLE BLOCK CHANGE TRACKING USING FILE <path>;
C. ALTER DATABASE ENABLE BLOCK CHANGE TRACKING USING FILE <path>;
D. ALTER SYSTEM ENABLE BLOCK CHANGE TRACKING;

点击查看答案进入题库练习

单项选择题

Which statement is true when Automatic Workload Repository (AWR) baselines are created using baseline templates?（）

A. AWR baselines are always created as repeating baselines.
B. AWR baselines can be created on the basis of two time values.
C. AWR baselines are always created with infinite expiration duration.
D. AWR baselines are always created using the Automatic Workload Repository (AWR) retention period as expiration duration.

点击查看答案进入题库练习

单项选择题

Which background process of a database instance, using Automatic Storage Management (ASM), connects as a foreground process into the ASM instance?（）

A. ASMB
B. PMON
C. RBAL
D.SMON

点击查看答案进入题库练习

赞题库

赞题库-搜题找答案

（已有500万+用户使用）

历年真题
章节练习
每日一练
高频考题
错题收藏
在线模考
提分密卷
模拟试题

无需下载立即使用

手机版电脑版