移动端

  • 题王微信公众号

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

计算机考试 | Oracle认证考试

模式切换

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

章节目录

多选题 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 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

单选题 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 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.

单选题 You want to create a tablespace to contain objects with block size 16 KB. But while configuring thestorage you find that the block size that you can provide is only 8 KB.  Which configuration could have enabled the block selection of 16 KB()

A

choosing the extent allocation type to uniform

B

choosing the Segment Space Management option to manual

C

setting autoextension on for the data file mentioned for the tablespace

D

setting the DB_16K_CACHE_SIZE parameter for the database instance to a nonzero value

多选题 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.

多选题 The session of user SCOTT receives the following error after executing an UPDATE command onthe EMP table:  ERROR at line 1:  ORA-00060: deadlock detected while waiting for resource  On investigation, you find that a session opened by user JIM has a transaction that caused the deadlock.  two statements are true regarding the session of SCOTT in this scenario()

A

The session is terminated after receiving the error and JIM can continue with his transaction.

B

SCOTT should perform a COMMIT or ROLLBACK to allow JIM to continue with his transaction.

C

The session is rolled back after receiving the error and JIM can continue with his transaction.

D

SCOTT has to reexecute the last command in the transaction after he commits the transaction.

最新资讯

1 2 3 4 5 下一页 尾页 /

到第