移动端

  • 题王微信公众号

    题王微信公众号

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

计算机考试 | Oracle认证考试

模式切换

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

章节目录

单选题 The backup retention policy is configured as RECOVERY WINDOW 2. You executed the following command in Recovery Manager (RMAN) against your database: RMAN> REPORT OBSOLETE; What would you see in the output?()

A

 a list of all those files that have been deleted in the last two days

B

 a list of all those files that have been recovered within the last two days

C

 a list of all the expired backups and copies

D

 a list of backups and copies that are outside the range covered by the current retention policy

单选题 Why would you use the following FLASHBACK TABLE command?() FLASHBACK TABLE emp TO TIMESTAMP (’11:45’,’hh12:mi’); 

A

to undo the changes made to the EMP table since the specified time

B

to restore the EMP table that was wrongly dropped from the database

C

to view the transactions that have modified the EMP table since the specified time

D

to view the changes made to the EMP table for one or more rows since the specified time

E

to recover the EMP table to a point in time in the past by restoring the most recent backup

单选题 Using Oracle Scheduler you have scheduled two jobs, JOB_A and JOB_B, to run at 9:00 p.m. every Friday. You want both the jobs to use a single resource plan, WEEKEND_PLAN. Which task must have already been performed to enable you to achieve this objective?()

A

 A window must have been created with the WEEKEND_PLAN resource plan.

B

 A program must have been created with the WEEKEND_PLAN resource plan.

C

 A job class must have been created with the WEEKEND_PLAN resource plan.

D

 A windows group must have been created with the WEEKEND_PLAN resource plan.

单选题 In an Oracle 10g database, the in-memory statistics are gathered at regular intervals and used to perform growth-trend analysis and capacity planning of the database. Which component stores these statistics?() 

A

recovery catalog

B

Oracle Enterprise Manager Repository

C

Automatic Workload Repository (AWR)

D

Oracle 10g Enterprise Manager Grid Control

E

Automatic Database Diagnostic Monitor (ADDM)

单选题 Your Oracle Database 10g is online when you execute the following statement:        SQL>ALTER TABLESPACE MY_TABLESPACE FLASHBACK OFF;   What is the result of executing this statement if the Flashback Database feature is already enabled in the database?()

A

 The database does not record flashback logs for MY_TABLESPACE

B

 The tables residing in MY_TABLESPACE are not protected by the Recycle Bin.

C

 All the tablespaces except MY_TABLESPACE can be recovered using Flashback Database feature.

D

 None of the flashback technologies, such as Flashback Table, Flashback Transaction Query and Flashback Version Query can be used to recover individual rows within the objects from MY_TABLESPACE

多选题 Last night, a media failure caused the loss of a temporary file that belongs to your database. Which two things may happen this morning when you try to open your database?()

A

 The database writer writes to a trace file, indicating that the temporary file is not found.

B

 The database prompts for a database recovery.

C

 The database opens normally.

D

 The database gets mounted and throws an error indicating that the temporary file requires recovery.

单选题 Why would you use the following FLASHBACK TABLE command?()  FLASHBACK TABLE emp TO TIMESTAMP (’11:45’,’hh12:mi’); 

A

to undo the changes made to the EMP table since the specified time

B

to restore the EMP table that was wrongly dropped from the database

C

to view the transactions that have modified the EMP table since the specified time

D

to view the changes made to the EMP table for one or more rows since the specified time

E

to recover the EMP table to a point in time in the past by restoring the most recent backup

多选题 In which scenarios would you rebuild an index?()

A

 when you need to disable the index usage

B

 when you need to change storage options

C

 when you need to enable index monitoring

D

 when you need to move the index to another tablespace

最新资讯

首页 上一页 1 2 3 4 5 尾页 /

到第