Oracle 1Z0-050 問題集

質問 1：
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 but the latency time is not computed.
C. The calibration process runs successfully and populates all the bind variables.
D. The calibration process runs successfully but only the latency time is computed.
正解：A

質問 2：
View the Exhibit for some of the current parameter settings.

A user logs in to the HR schema and issues the following commands:
SQL> CREATE TABLE emp (empno NUMBER(3), enameVARCHAR2(20), sal NUMBER(8,2));
SQL> INSERT INTO emp(empno,ename) VALUES(1 /JAMES');
At this moment, a second user also logs in to the HR schema and issues the following command: SQL> ALTER TABLE emp MODIFY sal NUMBER(10,2);
What happens in the above scenario?
A. The second user's session waits for a time period before producing the resource busy error.
B. The second user's command executes successfully.
C. A deadlock is created.
D. The second user's session immediately produces the resource busy error.
正解：A

質問 3：
View the Exhibit exhibit1 to examine the series of SQL commands.

View the Exhibit exhibit2 to examine the plans available in the SQL plan baseline. The baseline in the first row of the Exhibit is created when OPTIMIZER_MODE was set to
FIRST_ROWS.
Which statement is true if the SQL query in exhibit1 is executed again when the value of OPTIMIZER_MODE is set to FIRST_ROWS?
A. The optimizer uses the plan in the first row of the exhibit2 because it is the latest generated plan.
B. The optimizer uses the plan in the second row of the exhibit2 because it is an accepted plan.
C. The optimizer uses a new plan because none of the plans in the exhibit2 are fixed plans.
D. The optimizer uses the plan in the first row of the exhibit2 because OPTIMIZER_MODE was set to FIRST_ROW during its creation.
正解：B

質問 4：
You are managing an Oracle Database 11 g instance and an Oracle Database 10g instance on the same machine. Both instances use the ASM instance as storage. Which statements regarding the ASM disk group compatibility attributes are true in this scenario? (Choose all that apply.)
A. ASM compatibility controls which features for the ASM will be enabled.
B. The RDBMS compatibility settings for a disk group control the format of data structures for ASM metadata on the disk.
C. RDBMS compatibility and the database version determines whether a database instance can mount the ASM disk group
D. The database-compatibility version settings for each instance must be greater than or equal to the RDBMS compatibility of all ASM disk groups used by that database instances.
正解：A,C,D

質問 5：
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 is purged and the new flashback data archives are maintained for three years.
C. All historical data older than three years is purged from the flashback archive FLA1.
D. All historical data is retained but the subsequent flashback data archives are maintained for only three years.
正解：C

質問 6：
Your organization decided to upgrade the existing Oracle 10g database to Oracle 11 g 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.
正解：C

質問 7：
Which tasks can be accomplished using the Enterprise Manager Support Workbench in Oracle Database 11g? (Choose all that apply.)
A. You can track the Service Request (SR) and implement repairs.
B. You can manually run health checks to gather diagnostic data for a problem.
C. You can package and upload diagnostic data to Oracle Support.
D. Generate reports on data failure such as data file failures,
正解：A,B,C

質問 8：
Which are the prerequisites for performing flashback transactions on your database? (Choose all that apply.)
A. Supplemental log must be enabled.
B. Execute permission on the DBMS_FLASHBACK package must be granted to the user.
C. Undo retention guarantee for the database must be configured.
D. Supplemental log must be enabled for the primary key
正解：A,B,D