11gocmu最も有効な質問と解答で勉強

仕事や学業の合間にOracle Database 11g Certified Master Upgradeの合格を目指す方にとって、限られた時間をどう使うかが最大の課題です。Tech4Examの11gocmu練習問題は、要点を押さえた673問の問題集で、短い準備期間でも効率よく実力を磨けます。

Oracle 11gocmu 試験概要:

Oracle 11gocmu 試験シラバストピック:

11gocmu試験のQ&A – 受験前に知っておきたいこと

Oracle Database 11g Certified Master Upgrade 認定 11gocmu 試験問題：

問題 #1

The following query will provide what information about transportable tablespaces for the current database? (Choose all that apply.)
select d.platform_name "Source", t.platform_name "Compatible Targets", endian_format from v$transportable_platform t, v$database d where t.endian_format = (select endian_format from v$transportable_platform t, v$database d where d.platform_name = t.platform_name);

A. The list of target platforms requiring endian conversion
B. None of the above
C. The list of all target platforms that can receive transportable tablespaces from the source database
D. The list of target platforms that will not require endian conversion
E. The list of target platforms having the same endian format as the source database

問題 #2

Which three statements are true about persistent configuration? (Choose three.)

A. Persistent lightweight jobs are useful when users need to create a large number of jobs in a short time
B. It is possible to create fully self-contained persistent lightweight jobs
C. A user cannot set privileges on the persistent lightweight jobs
D. Persistent lightweight jobs generate a large amount of metadata
E. The use of a template is mandatory to create persistent lightweight jobs

問題 #3

Which DBMS_SCHEDULER procedures can be used to enable a program? (Choose all that apply.)

A. SET_ATTRIBUTE
B. VALIDATE_PROGRAM
C. SET_ENABLED
D. ENABLE_PROGRAM
E. ENABLE

問題 #4

You are using Recovery Manager (RMAN) for backup and recovery operations with a recovery catalog. You have been taken database backups every evening. On November 15, 2007, at 11:30 AM, you were informed that the USER_DATA tablespace was accidentally dropped.
On investigation, you found that the tablespace existed until 11:00 AM, and important transactions were done after that.
So you decided to perform incomplete recovery until 11:00
AM. All the archive logs needed to perform recovery are intact.
In NOMOUNT state you restored the control file that has information about the USER_DATA tablespace from the latest backup.
Then you mounted the database. Identify the next set of commands that are required to accomplish the task?

A. Option B
B. Option C
C. Option A
D. Option B

問題 #5

You create two resource plans, one for data warehouse loading jobs at night and the other for application jobs at day time. You want the resource plans to activate automatically so that the resource allocation is optimum as desired by the activity.
How would you achieve this?

A. Set the SWITCH_TIME resource plan directive for both the resource plans
B. Implement Scheduler windows
C. Implement job classes
D. Implement the mapping rule for the consumer groups

解説：