Oracle 1Z0-055 問題集

質問 1：
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. all the optimizer statistics
B. PL/SQL functions, procedures, and packages
C. ADR diagnostic files
D. the table and index definitions and actual data
E. initialization parameter settings
正解：A,B,E

質問 2：
View the Exhibit to examine the error obtained during the I/O calibration process.
There are no data files on raw devices. What is the reason for this error?

A. The pending area has not been created before running the I/O calibration process.
B. Another session runs the I/O calibration process concurrently.
C. The FILESYSTEMIO_OPTIONS parameter is set to NONE.
D. The DISK_ASYNCH_IO parameter is set to TRUE.
正解：C

質問 3：
Examine the following PL/SQL block:
SET SERVEROUTPUT ON
SET LONG 10000
DECLARE report clob;
BEGIN
report := DBMS_SPM.EVOLVE_SQL_PLAN_BASELINE();
DBMS_OUTPUT.PUT_LINE(report);
END;
Which statement describes the effect of the execution of the above PL/SQL block?
A. All fixed plan baselines are converted into nonfixed plan baselines.
B. The nonaccepted plans in the SQL Management Base are verified with the existing plan baselines.
C. The plan baselines are verified with the SQL profiles.
D. All the nonaccepted SQL profiles are accepted into the plan baseline.
正解：B

質問 4：
Which two initialization parameters would you set to enable Automatic Shared Memory Management? (Choose two.)
A. set DB_CACHE_SIZE to a non-zero value
B. set SGA_TARGET to a non-zero value
C. set SHARED_POOL_SIZE to zero
D. set STATISTICS_LEVEL to TYPICAL or ALL
E. set STATISTICS_LEVEL to BASIC
正解：B,D

質問 5：
You are in the process of creating a virtual private catalog in your Oracle Database 11g database. The PROD1, PROD2, and PROD3 Oracle Database 10g databases are registered in the base recovery catalog. The database user who owns the base recovery catalog is CATOWNER. CATOWNER executes the following command to grant privileges to a new user VPC1 using Oracle Database 11g RMAN executables:
RMAN> GRANT CATALOG FOR DATABASE prod1, prod2 TO vpc1;
Then you issue the following commands:
RMAN> CONNECT CATALOG vpc1/oracle@catdb;
RMAN> SQL "EXEC catowner.dbms_rcvcat.create_virtual_catalog;"
What is the outcome of the above commands?
A. They execute and create a virtual catalog for pre-Oracle 11g clients.
B. They produce an error because you need to connect as CATOWNER to execute this packaged procedure.
C. They produce an error because you need to connect to the target database to execute this packaged procedure.
D. They produce an error because PROD1 and PROD2 databases belong to the older version.
正解：A

質問 6：
Which statement about the enabling of table compression in Oracle Database 11g is true?
A. Compression can be enabled at the table, tablespace, or partition level for conventional DML only.
B. Compression can be enabled only at the table level for both direct loads and conventional DML.
C. Compression can be enabled at the table, tablespace, or partition level for both direct loads and conventional DML.
D. Compression can be enabled at the table, tablespace, or partition level for direct loads only.
正解：C

質問 7：
View the Exhibit.
As shown in the diagram, in-memory statistics are transferred to the disk at regular intervals. Which background process performs this activity?

A. SMON
B. CKPT
C. MMON
D. DBWR
正解：C