移动端

  • 题王微信公众号

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

计算机考试 | Oracle认证考试

模式切换

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

章节目录

单选题 You decided to change the location of the flash recovery area. You executed the following command:   ALTER SYSTEM SET DB_RECOVERY_FILE_DEST=’+disk1’ SCOPE=BOTH SID=’*’;   Which statement is true?()

A

 The location can be changed only if the flash recovery area is empty.

B

 After executing the command, all new flash recovery area files will be created in the new location.

C

 The command will generate an error because you cannot change the flash recovery area while the database is open.

D

 All the existing files in the flash recovery area will be moved to the new location and all new Flash Recovery Area files will be created in the new location.

多选题 You executed the following command in Recovery Manager (RMAN) to perform a backup of the DETTBS tablespace: RMAN> BACKUP TABLESPACE DETTBS;  Under which conditions would this command execute successfully? ()

A

 The database is in NOMOUNT state.

B

 The database is in NOARCHIVELOG mode and the tablespace is online.

C

 The database is in NOARCHIVELOG mode and the tablespace is offline.

D

 The database is in ARCHIVELOG mode and the tablespace is offline.

E

 The database is in ARCHIVELOG mode and the tablespace is online.

单选题 The loss of the control file forced you to re/x7fcreate the control file. After re/x7fcreating it and opening the database, you find that some of the data files are named as MISSINGnnnnn, where nnnnn is a five/x7fdigit number starting with 0.  What could be the possible reason?()

A

These are the data files that are corrupted.

B

There is no SYSAUX tablespace in your database

C

There is a read­only tablespace in your database.

D

These are the data files that cannot be recovered.

多选题 You are working on an Oracle Database 10g database. You enabled the Flashback Database feature. Which two statements regarding flashback logs are true? ()

A

 Flashback logs are not archived.

B

 Flashback logs are maintained in redo log files.

C

 Flashback logs are maintained in the Flash Recovery Area.

D

 Flashback logs are used to maintain Flashback Database related errors.

E

 Flashback logs need to be cleared manually after you disable Flashback Database.

单选题 You took the DATA1 tablespace offline at 10:00 A.M. At 12:30 P.M., a schema of a user is dropped and purged from the Recycle Bin. You noticed this at 2:00 P.M. and decided to perform an incomplete recovery.  Which datafiles will you recover?()

A

 all the datafiles in the database

B

 the datafiles associated with the SYSTEM tablespace

C

 the datafiles associated with the DATA1 tablespace

D

 all the datafiles in the database except those associated with the DATA1 tablespace

单选题 You need to create a schedule that will run a job on the second Friday of each month. What should the repeat interval of the schedule be set to?()

A

 FREQ = MONTHLY; BYDAY = 2FRI;

B

 FREQ = MONTHLY; BYDAY = FRI(2);

C

 FREQ = MONTHLY; BYDAY = FRI2;

D

 FREQ = MONTHLY; BYDAY = -2FRI;

最新资讯

1 2 3 4 5 下一页 尾页 /

到第