Oracle 1Z0-050 問題集

質問 1：
Which statement is true when Automatic Workload Repository (AWR) baselines are created using baseline templates?
A. AWR baselines are always created using the Automatic Workload Repository (AWR) retention period as expiration duration.
B. AWR baselines are always created as repeating baselines.
C. AWR baselines are always created with infinite expiration duration.
D. AWR baselines can be created on the basis of two time values.
正解：D

質問 2：
You have applications that have frequently executed queries, and produce small and static result sets.
You configure the sqlnet.ora file in the client machine to set a nonzero value for the OCI_RESULT_CACHE_MAX_SIZE parameter.
What is the purpose of this configuration?
A. to enhance the query performance by creating a cache in the client memory for sorting operations
B. to avoid the storing of query plans and results in the server by creating a cache in the client memory
C. to avoid round trips to the server by enabling caching of query results in client memory
D. to improve performance by storing a copy of the data from the private SQL area of the PGA
正解：C

質問 3：
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

質問 4：
What are the advantages of variable extent size support for large ASM files? (Choose two.)
A. This feature enables faster file opens because of the reduction in the amount of memory that is required to store file extents.
B. Fewer extent pointers are needed to describe the file and less memory is required to
manage the extent maps in the shared pool.
C. It improves resync operations when the disk comes online after being taken offline for maintenance purposes.
D. It improves performance in the extended cluster configuration by reading from a local copy of an extent.
正解：A,B

質問 5：
Your database initialization parameter file has the following entry:
SEC_MAX_FAILED_LOGIN_ATTEMPTS=3
Which statement is true regarding this setting?
A. It drops the connection after the specified number of login attempts fail only for users who have the SYSDBA privilege.
B. It is enforced only if the password profile is enabled for the user.
C. It locks the user account after the specified number of attempts.
D. It drops the connection after the specified number of login attempts fail for any user.
正解：D

質問 6：
Which two are the prerequisites to enable Flashback Data Archive? (Choose two.)
A. The tablespace on which the Flashback Data Archive is created must be managed with Automatic Segment Space Management (ASSM).
B. Automatic undo management must be enabled.
C. Database must be running in archivelog mode.
D. Undo retention guarantee must be enabled.
正解：A,B

質問 7：
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

質問 8：
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 manually.
B. Health Check was performed to check interblock and intersegment corruption.
C. Health Check was performed by the Health Monitor automatically in response to a critical error.
D. Health Check was performed to check the disk image block corruptions
E. Health Check was performed to verify the integrity of database files and report failures.
正解：A,D