违法和不良信息举报 联系客服
免费注册 登录

The RECYCLEBIN parameter is set to ON for your database. You

题目
多选题
The RECYCLEBIN parameter is set to ON for your database. You drop a table, PRODUCTS, from the SCOTT schema. Which two statements are true regarding the outcome of this action? （）(Choose two)
A

All the related indexes and views are automatically dropped

B

The flashback drop feature can recover only the table structure

C

Only the related indexes are dropped whereas views are invalidated

D

The flashback drop feature can recover both the table structure and its data

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

第1题：

You have the following requirements in relation to the detection of block corruption for your database instance:1. Check for logical self-consistency of data blocks when modified in memory.2. Checksums are calculated before and after the block change.3. Checks are performed for the lost writes to the physical standby database.Which method would help you perform the above checks automatically? （）

A. Set the DB_SECUREFILE parameter to PERMITTED

B. Set the DB_ULTRA_SAFE parameter to DATA_ONLY

C. Set the DB_LOCK_CHECKSUM parameter to TYPICAL

D. Set the DB_LOST_WRITE_PROTECT parameter to TYPICAL


参考答案：B

第2题：

Examine the exhibit to view the parameters set in your parameter file. (Click the Exhibit(s) button.)You restart the instance.To what value will the MEMORY_MAX_TARGET parameter be set by default?()

A.120M

B.320M

C.480M

D.600M


参考答案：D

第3题：

You want to enable automatic PGA memory management in your database. Which setting is required to achieve this?()

A. Set MEMORY_TARGET to zero

B. Set the STATISTICS_LEVEL parameter to BASIC

C. Set the WORKAREA_SIZE_POLICY parameter to MANUAL

D. Set the PGA_AGGREGATE_TARGET parameter to nonzero value


参考答案：D

第4题：

Your database is started by using the server parameter file （SPFILE）. You issued this command to change the value of the LOG_BUFFER initialization parameter：  ALTER SYSTEM SET LOG_BUFFER=24M SCOPE=BOTH;  What would be the outcome of this command？（）

  • A、The command would return an error because LOG_BUFFER is a static parameter.
  • B、The parameter value would be changed and it would come into effect immediately.
  • C、You need to restart the database so that parameter changes can come into effect.
  • D、The command would succeed only if initialization parameter LOG_ARCHIVE_MAX_PROCESS is set to value 2.

正确答案:A

第5题：

You want to monitor and control the resource usage by sessions. You want to be warned automatically when more than 100 sessions are opened with your database.  What action would you take to achieve this？（）

  • A、Use the Database Resource Manager.
  • B、Set the limits in the profiles used by users.
  • C、Modify the SESSIONS initialization parameter.
  • D、Set the warning threshold for the Current Logons Count metric.

正确答案:D

第6题：

Which statement about Automatic Memory Management with Oracle 11g is true?()

A. You cannot specify MEMORY_TARGET if you explicitly specify SGA_TARGET or PGA_AGGREGATE_TARGET values that are greater than zero in your parameter file.

B. Oracle can reallocate memory between the SGA and PGA automatically as needed.

C. To use Automatic Memory Management, you must explicitly set both the MEMORY_TARGET and MEMORY_MAX_TARGET parameters in your parameter file.

D. You can set the MEMORY_TARGET parameter to a maximum value of the current SGA size plus the current PGA size.


参考答案：B

第7题：

View the Exhibit to examine the parameter values.You are planning to set the value for the MEMORY_TARGET parameter of your database instance.What value would you recommend?()

A. 90 MB

B. 272 MB

C. 362 MB

D. 1,440 MB


参考答案：C

第8题：

The RECYCLEBIN parameter is set to ON for your database. You drop a table, PRODUCTS, from the SCOTT schema.Which two statements are true regarding the outcome of this action?()

A. All the related indexes and views are automatically dropped

B. The flashback drop feature can recover only the table structure

C. Only the related indexes are dropped whereas views are invalidated

D. The flashback drop feature can recover both the table structure and its data


参考答案：C, D

第9题：

You are maintaining a database that is in ARCHIVELOG mode. You have configured the flash recovery area in your database. The database is in MOUNT EXCLUSIVE mode， and you want to configure the Flashback Database feature. Which two options are NOT required to configure the Flashback Database feature？ （）

  • A、 Open the database in read-only mode.
  • B、 Set the retention target with the DB_FLASHBACK_RETENTION_TARGET initialization parameter.
  • C、 Enable the block change tracking feature.
  • D、 Execute the ALTER DATABASE FLASHBACK ON statement.

正确答案:A,C

第10题：

You are maintaining an OLTP database in Oracle10g. You have configured the Flash Recovery Area in your database. The Flash Recovery Area is full because you have set the retention policy to NONE. What will you do to resolve the problem？（）

  • A、 Increase the value of the FAST_START_MTTR_TARGET initialization parameter.
  • B、 Increase the value of the DB_RECOVERY_FILE_DEST_SIZE parameter.
  • C、 Increase the value of the PGA_AGGREGATE_TARGET initialization parameter.
  • D、 Increase the value of the SGA_TARGET initialization parameter.

正确答案:B

更多相关问题
相关内容