試験科目：Oracle Database 11g: Administration II
問題と解答：全698問 1Z0-053 模擬問題
NO.1 You need to configure fine-grained access control to external network resources from within your
database. You create an access control list (ACL) using the DBMS_NETWORK_ACL_ADMIN package.
Which statement is true regarding the ACL created?
A. It is a list of users and network privileges stored in the XML file according to which a group of users can
connect to one or more hosts.
B. It is a list of remote database links stored in the XML file that are available to the users of the database.
C. It is the list of the host names or the IP addresses stored in the data dictionary that can connect to your
database through PL/SQL network utility packages such as UTL_TCP.
D. It is a list of users and network privileges stored in the data dictionary according to which a group of
users can connect to one or more hosts.
NO.2 While deploying a new application module, the software vendor ships the application software along
with appropriate SQL plan baselines for the new SQLs being introduced. Which two statements describe
the consequences? (Choose two.)
A. The new SQL statements initially run with the plans that are known to produce good performance
under standard test configuration.
B. The plan baselines can be evolved over time to produce better performance.
C. The newly generated plans are directly placed into the SQL plan baseline without being verified.
D. The optimizer does not generate new plans for the SQL statements for which the SQL plan baseline
has been imported.
NO.3 Consider the following scenario for your database:
-Backup optimization is enabled in RMAN. The recovery window is set to 7 days in RMAN. The most
recent backup to disk for the TOOLS tablespace was taken on November 3, 2007.
The TOOLS tablespace is read-only since November 4, 2007.
On November 23, 2007, you issue the RMAN command to back up the database to disk. Which statement
is true regarding the backup of the TOOLS tablespace?
A. The RMAN makes backup because optimization can be enabled only for backups to disk
B. The RMAN backup fails because the TOOLS tablespace is read-only
C. The RMAN makes the backup because no backup of the tablespace exists within the seven day
D. The RMAN skips the backup of the tablespace because backup optimization is enabled
1Z0-053 コンポーネント 1Z0-053 受験料
NO.4 Examine the section of the Health Check report given below:
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 interblock and intersegment corruption.
B. Health Check was performed by the Health Monitor automatically in response to a critical error.
C. Health Check was performed to check the disk image block corruptions.
D. Health Check was performed to verify the integrity of database files and report failures.
E. Health Check was performed manually.