移动端

  • 题王微信公众号

    微信搜“题王网”真题密题、最新资讯、考试攻略、轻松拿下考试

计算机考试 | Oracle认证考试

模式切换

0 0 0
我的错题 我的收藏 学习笔记

章节目录

单选题 In which situation may the UNDO_RETENTION parameter be ignored, even if it is set to a value()

A

when the data file of the undo tablespace is autoextensible

B

when there are more than one undo tablespaces available in the database

C

when the undo tablespace is of a fixed size and retention guarantee is not enabled

D

when the undo tablespace is autoextensible and retention guarantee is not enabled

多选题 Which two statements are true regarding the SGA_TARGET initialization parameter()

A

It can be increased up to the value of the SGA_MAX_SIZE parameter.

B

Increasing the value of the SGA_TARGET parameter distributes the increased memory among all the Autotuned components.

C

Reducing the value of the SGA_TARGET parameter deallocates memory from both autotuned and Manually sized components.

D

Increasing the value of SGA_TARGET up to the value of SGA_MAX_SIZE disables the automatic shared Memory management feature.

单选题 View the Exhibit to examine the output for the CROSSCHECK BACKUP command.  Which statement is trueabout the output of the command()

A

The backup piece is expired as the new backup is available.

B

The backup piece is expired because the operating-system file was not found.

C

The backup piece is expired because the retention period for the backup has expired.

D

The backup piece is expired because the backup set to which it belongs is not complete

多选题 Which two statements are true about the Automatic Workload Repository (AWR)()

A

All AWR tables belong to the SYSTEM schema.

B

The AWR contains systemwide tracing and logging information.

C

The snapshots collected by the AWR are accessible through data dictionary views.

D

The snapshots collected by the AWR are used by self-tuning components in the database.

多选题 In which of the scenarios will the DBA perform recovery()

A

The alert log file is corrupted.

B

A tablespace is accidentally dropped.

C

One of the redo log members is corrupted.

D

A database user terminates the session abnormally.

E

The hard disk on which the data file is stored is corrupted.

单选题 Which statement is true about the UNDO_RETENTION parameter when retention guarantee is not enabled()

A

It is the time period after which the undo data becomes obsolete.

B

It is the time period after which the committed undo data would be transferred to a temporary tablespace.

C

It is the minimum time period up to which the committed undo data would be retained if free undo space isavailable.

D

It is the time period after which the undo data is transferred to the Flash Recovery Area to provide readconsistency.

单选题 Which statement is true regarding the effect of this command on the transaction in Scott’s session()

A

The command fails as a transaction is still pending.

B

The transaction in Scott’s session is rolled back and the tablespace becomes read-only.

C

The command waits and the user SCOTT can execute data manipulation language (DML) statements only as part of the current transaction.

D

The command hangsuntil all transactions on the objects in the tablespace commit or rollback, and then the tablespace is placed in read-only mode.

最新资讯

1 2 3 4 5 下一页 尾页 /

到第