11gocmu試験無料問題集（673題）「Oracle Database 11g Certified Master Upgrade 認定」

出題：1

You performed an incomplete recovery and opened the database with the RESETLOGS option. The LOG_ARCHIVE_FORMAT parameter is set to 'ora_%t_%s_%r.log'. Which statement regarding the archived redo log files, created in an earlier incarnation of the database, is true?

A. The archived redo log files are deleted automatically.

B. The archived redo log files will be overwritten.

C. The archived redo log files are still maintained because the file names are unique.

D. The archived redo log files should be moved to some other location.

正解：C 解答を投票する

出題：2

You want to set the following initialization parameters for your database instance:
LOG_ARCHIVE_DEST_1 = 'LOCATION=/disk1/arch' LOG_ARCHIVE_DEST_2 = 'LOCATION=/disk2/arch' LOG_ARCHIVE_DEST_3 = 'LOACTION=/disk3/arch' LOG_ARCHIVE_DEST_4 = 'LOCATION=/disk4/arch MANDATORY'
Identify the statement that correctly describes this setting.

A. This setting is not allowed because the first destination is not set as MANDATORY.

B. The MANDATORY location must be a flash recovery area.

C. The online redo log file is not allowed to be overwritten if the archived log cannot be created in the fourth destination.

D. The optional destinations may not use the flash recovery area.

正解：C 解答を投票する

出題：3

When tuning Automatic PGA Memory Management, which of the following views will provide the information specified?

A. The V$PGA_TARGET_ADVICE_HISTOGRAM view shows how the V$SQL_WORKAREA_HISTOGRAM will change if you switch between Manual and Automatic PGA Memory Management.

B. The V$PGA_TARGET_ADVICE view shows how the V$SQL_WORKAREA histogram will change if you change the value of PGA_AGGREGATE_TARGET.

C. The V$PGA_TARGET_ADVICE view shows how performance will improve for the different work areas if you switch from Manual to Automatic PGA Memory Management.

D. The V$PGA_TARGET_ADVICE view shows the predicted cache hit-ratio improvement if you increase PGA_AGGREGATE_TARGET.

正解：D 解答を投票する

出題：4

Which view shows all valid values for the NLS_LANGUAGE, NLS_SORT, NLS_TERRITORY, and NLS_CHARACTERSET parameters?

A. V$NLS_VALID_VALUES

B. NLS_VALID_VALUES

C. NLS_VALUE_OPTIONS

D. V$NLS_VALUE_OPTIONS

E. V$VALID_NLS_VALUES

正解：A 解答を投票する

出題：5

You have a very large table that your users access frequently. Which of the following advisors will recommend any indexes to improve the performance of queries against this table?

A. The Automatic Memory Manager (AMM)

B. The SQL Access Advisor

C. The Segment Advisor

D. The SQL Tuning Advisor

正解：B 解答を投票する

解説: (GoShiken メンバーにのみ表示されます)

出題：6

Which three functions are performed by the SQL Tuning Advisor? (Choose three.)

A. Recommending restructuring SQL queries that are using bad plans

B. Building the SQL profile

C. Recommending optimization of materialized views

D. Checking query objects for missing and stale statistics

E. Recommending bitmap, function-based, and B-tree indexes

正解：A,B,D 解答を投票する

解説: (GoShiken メンバーにのみ表示されます)

出題：7

Which two statements regarding the Flashback Table feature are correct? (Choose two.)

A. Flashback Table can be performed on system tables.

B. Flashback Table uses log mining to extract SQL_REDO and SQL_UNDO statements.

C. Flashback Table operation does not shrink the segments.

D. Flashback Table operation acquires exclusive data manipulation language (DML) locks.

正解：C,D 解答を投票する

出題：8

What is the advantage of setting the ASM-preferred mirror read for the Stretch cluster configuration?

A. This feature enables much faster file opens.

B. It improves performance by reading from a copy of an extent closest to the node.

C. It improves resync operations.

D. It improves performance as fewer extent pointers are needed in the shared pool.

正解：B 解答を投票する

出題：9

Flashback Database relies on which technologies to recover to a point in time?

A. RMAN command line

B. None of the above

C. Flashback logs in the flash recovery area

D. Flashback Data Archive

E. FlashbUndo tablespace

正解：C 解答を投票する

出題：10

Which is the correct command to put the database in ARCHIVELOG mode?

A. alter database archivelog enable

B. alter database enable archive

C. None of the above

D. alter system enable archivelog mode

E. alter database archivelog

正解：E 解答を投票する

出題：11

To enable resumable space allocation for the instance, which of the following initialization parameters should you set to a nonzero value?

A. RESUMABLE_TIMEOUT

B. RESUMABLE_TIME

C. TIME_RESUMABLE

D. RESUMABLE_SPACE_TIME

E. RESUMABLE_SPACE

正解：A 解答を投票する

出題：12

What are the different logging modes available in Oracle Database 11g? (Choose two.)

A. HOTDATABASE mode

B. NOARCHIVELOG mode

C. ARCHIVELOG mode

D. LOGGING mode

E. NOLOG mode

正解：B,C 解答を投票する

出題：13

Which of the following files cannot be backed up by RMAN? (Choose all that apply.)

A. Online redo logs

B. Archived redo logs

C. Database datafiles

D. Control files

E. Database pfiles

正解：A,E 解答を投票する

11gocmu試験無料問題集「Oracle Database 11g Certified Master Upgrade 認定」