You have not configured Oracle Managed Files （OMF) in your database. You do not want to sc

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;

查看答案

如搜索结果不匹配，请联系老师获取答案

您可能会需要：

重置密码查看订单联系客服

安装上学吧APP，拍照搜题省时又省心！

更多“You have not configured Oracle…”相关的问题

第1题

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

点击查看答案

第2题

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

点击查看答案

第3题

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.

点击查看答案

第4题

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