移动端

  • 题王微信公众号

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

计算机考试 | Oracle认证考试

模式切换

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

章节目录

单选题 Which type of database file is spread across all disks in a disk group?()

A

 All types of files are spread across all disks in the disk group.

B

 Datafiles

C

 Redo log files

D

 Archived redo log files

E

 Control files

单选题 Examine the following ALTER command:   SQL> ALTER DISKGROUP dgroup1 UNDROP DISKS;   What is the purpose of the command?()  

A

 It cancels all pending disk drops within the disk group.

B

 It restores disks that are being dropped as the result of a DROP DISKGROUP operation

C

 It mounts disks in the disk group for which the drop-disk operation has already been co pleted

D

 It restores all the dropped disks in the disk group for which the drop-disk operation has already been completed

E

 It adds previously dropped disks back into the disk group

单选题 What is the impact of the results of the output of the following command?()   RMAN> report unrecoverable database;  Report of files that need backup due to unrecoverable operations  File Type of Backup Required Name  4 full or incremental C:///ORACLE/ORADATA/ORCL/USERS01.DBF  

A

 There are no backup sets with any backups of the users01.dbf datafile.

B

 The users01.dbf datafile has had unrecoverable operations occur in it. It will need to be backed up or some data loss is possible during a recovery.

C

 The users01.dbf datafile is corrupted.

D

 The users01.dbf datafile backup exceeds the retention criteria.

E

 The last backup of the users01.dbf datafile failed and must be rerun.

单选题 You are tuning RMAN to optimize performance. You want tape I/O to be asynchronous when you perform tape backups. Which action should you take?()

A

 Set the BACKUP_TAPE_IO_SLAVES parameter to FALSE

B

 Set the BACKUP_TAPE_IO_SLAVES parameter to TRUE

C

 Use compression when performing tape backups

D

 Configure multiple SBT channels

单选题 Your organization decided to upgrade the existing Oracle 10g database to Oracle 11g database in a multiprocessor environment. At the end of the upgrade,you observe that the DBA executes the following script:   SQL> @utlrp.sql   What is the significance of executing this script?()  

A

 It performs parallel recompilation of only the stored PL/SQL code.

B

 It performs sequential recompilation of only the stored PL/SQL code.

C

 It performs parallel recompilation of any stored PL/SQL as well as Java code.

D

 It performs sequential recompilation of any stored PL/SQL as well as Java code.

单选题 Which of the following identifies and creates an index to minimize the DB time for a particular SQL statement?()

A

The SGA Tuning Advisor

B

The SQL Access Advisor

C

The SQL Tuning Advisor

D

The Memory Advisor

单选题 When issuing the duplicate database command, you use the parameter DB_FILE_NAME_CONVERT. For what purpose do you use this parameter?()  

A

 To indicate the location of the auxiliary-instance online redo logs.

B

 To indicate the location of the target database datafiles.

C

 To indicate the location of the auxiliary-instance control file and online redo logs.

D

 To indicate the location of the auxiliary-instance database datafiles.

E

 This is not a valid parameter when duplicating a database.

多选题 Which of the following are valid program types for a lightweight job?()

A

 PLSQL_BLOCK

B

 EXECUTABLE

C

 JAVA_STORED_PROCEDURE

D

 STORED_PROCEDURE

E

 EXTERNAL

最新资讯

1 2 3 4 5 下一页 尾页 /

到第