1Z0-050問題集、Oracle実際の試験問題

質問 1

Examine the section of the Health Check report given below:
DBMS_HM.GET_RUN_REPORT('HM_RUN_1061')
Run Name: HM_RUN_1061 Run Id: 1061 Check Name : Data Block Integrity Check Mode : REACTIVE Status : COMPLETED Start Time : 2007-05-12 22:11:02.032292 -07:00 End Time : 2007-05-12 22:11:20.835135 -07:00 Error Encountered: 0 Source Incident Id : 7418 Number of Incidents Created :0
Which two statements are true regarding the Health Check report? (Choose two.)

A. Health Check was performed to check the disk image block corruptions

B. Health Check was performed to check interblock and intersegment corruption.

C. Health Check was performed manually.

D. Health Check was performed by the Health Monitor automatically in response to a critical error.

E. Health Check was performed to verify the integrity of database files and report failures.

正解: A,C

質問 2

The Database Resource Manager is automatically enabled in the maintenance window that runs the Automated Maintenance Task. What is the reason for this?

A. to prevent the Automated Maintenance Tasks from consuming excessive amounts of system resources

B. to allow the Automated Maintenance Tasks to use system resources without any restriction

C. to allow resource sharing only among the Automated Maintenance Tasks in the maintenance window

D. to prevent the creation of an excessive number of scheduler job classes

正解: A

質問 3

You are working on a CATDB database that contains an Oracle Database version 11.1 catalog schema owned by the userRC011. The INST1 database contains an Oracle Database version 10.1 catalog schema owned by the user RCAT10.
You want the RMAN to import metadata for database IDs 1423241 and 1423242, registered in RCAT10, into the recover catalog owned by RC011. You also want to deregister them from the catalog after import.
You executed the following commands to achieve this:
RMAN> CONNECT CATALOG rco1 1/password@catdb
RMAN> IMPORT CATALOG rcat1 0/oracle@inst1 DBID=1423241,1423242;
What happens if the RC011 catalog has scripts with the same name as that of the scripts in RCAT10 catalog?

A. The scripts in the RC011 catalog are overwritten.

B. RMAN renames the global scripts that are imported from the RCAT10 catalog.

C. RMAN renames the local stored scripts in the RC011 catalog.

D. The RMAN session in which the command is executed aborts.

正解: B

質問 4

Which of the following information will be gathered by the SQL Test Case Builder for the problems pertaining to SQL-related problems? (Choose all that apply.)

A. initialization parameter settings

B. ADR diagnostic files

C. PL/SQL functions, procedures, and packages

D. all the optimizer statistics

E. the table and index definitions and actual data

正解: A,C,D

質問 5

View the Exhibit to examine the parameters set for your database instance.

You execute the following command to perform I/O calibration after the declaration of bind variables in the session that are used in the command:
SQL> EXECUTE dbms_resource_manager.calibrate_io( num_physical_disks=>1, max_latency=>5u,max_iops=>:max_iops, max_mbps=>:max_mbps, actual latency=>: actual_latency);
Which statement describes the consequence?

A. The command produces an error.

B. The calibration process runs successfully and populates all the bind variables.

C. The calibration process runs successfully but only the latency time is computed.

D. The calibration process runs successfully but the latency time is not computed.

正解: A

質問 6

View the Exhibit to examine the error while executing the REPAIR FAILURE command in an RMAN session.

What is the reason for this error?

A. The ADVISE FAILURE command has not been issued before the REPAIR FAILURE command.

B. Another repair session is running concurrently.

C. The failure ID has not been mentioned in the command for data file 5.

D. There are new failures recorded in the Automatic Diagnostic Repository (ADR).

正解: B

質問 7

While tuning a SQL statement, the SQL Tuning Advisor finds an existing SQL profile for the statement that has stale statistics available. What would the optimizer do in this situation?

A. It initiates the statistics collection process by running GATHER_STATS_JOB.

B. It makes the statistics information available to GATHER_STATS_JO

C. It logs a warning message in the alert log so that the DBA can perform statistics collection manually.

D. It updates the existing SQL profiles with current statistics.

正解: B

質問 8

ENCRYPT_TS is an encrypted tablespace that contains tables with data. Which statement is true regarding the effect of queries and data manipulation language (DML) statements on the encrypted data in the tables?

A. The data is decrypted during SORT and JOIN operations.

B. The data remains encrypted when it is stored in the redo logs.

C. The data remains encrypted in the UNDO tablespace provided that the UNDO tablespace was created with the encryption option enabled.

D. The data remains encrypted when it is read into memory.

正解: B

質問 9

In which situations will the ASM metadata backup help you recover the ASM disk in a disk group? (Choose all that apply.)

A. when the data file on an ASM disk group gets corrupted

B. when one or more disks in an ASM disk group are lost

C. wnen one or more file directory paths are accidentally deleted from an ASM disk group

D. when one of the disks in a disk group is accidentaly unplugged

正解: B,C

質問 10

You want to track and store all transactional changes to a table over its lifetime. To accomplish this task, you enabled Flashback Data Archive with the retention of 5 years. After some time, the business requirement changed and you were asked to change the retention from 5 years to 3 years. To accomplish this, you issued the following command: ALTER FLASHBACK ARCHIVE fla1 MODIFY RETENTION 3 YEAR;
What is the implication of this command?

A. The command produces an error because the retention time cannot be reduced.

B. All historical data older than three years is purged from the flashback archive FLA1.

C. All historical data is purged and the new flashback data archives are maintained for three years.

D. All historical data is retained but the subsequent flashback data archives are maintained for only three years.

正解: B

質問 11

You issued the following command on the temporary tablespace LMTEMP in your database:
SQL>ALTER TABLESPACE Imtemp SHRINK SPACE KEEP 20M;
Which requirement must be fulfilled for this command to succeed?

A. The tablespace must be locally managed.

B. The tablespace must have only one temp file.

C. The tablespace can remain as the default but must have no active sort operations.

D. The tablespace must be made nondefault and offline.

正解: A

質問 12

The OPTIMIZER_USE_PLAN_BASELINES parameter is set to TRUE. The optimizer generates a plan for a SQL statement but does not find a matching plan in the SQL plan baseline. Which two operations are performed by the optimizer in this scenario? (Choose two.)

A. The optimizer adds the new plan to the SQL plan baseline but not in the ENABLED state.

B. The optimizer selects the new plan for the execution of the SQL statement.

C. The optimizer adds the new plan to the SQL plan baseline as an accepted plan.

D. The optimizer adds the new plan to the plan history.

E. The optimizer costs each of the accepted plans in the SQL plan baseline and picks the one with the lowest cost.

正解: D,E

質問 13

Which tasks are run automatically as part of the Automated Maintenance Task by default? (Choose all that apply.)

A. Segment Advisor

B. SQL Access Advisor

C. Automatic Database Diagnostics Monitor

D. Optimizer statistics gathering

E. Automatic SQL Tuning Advisor

正解: A,D,E

質問 14

Which setting enables the baselines by default in Oracle Database 11g?

A. adding filters to the Automatic Database Diagnostic Monitor (ADDM)

B. setting the STATISTICS_LEVEL parameter to TYPICAL

C. setting the OPTIMIZER_USE_PENDING_STATISTICS parameter to TRUE

D. enabling Automated Maintenance Task using Oracle Enterprise Manager

正解: B

Oracle Database 11g: New Features for Administrators - 1Z0-050 模擬練習