2026年現在、1Z0-050試験の出題内容は公式の改訂に伴って変わることがあり、古い教材での対策はリスクになりかねません。PassTestのOracle Database 11g: New Features for Administrators問題集は365日間の無料更新付きで、常に最新の内容で学習を続けられます。

Oracle 1Z0-050 試験概要:

Oracle 1Z0-050 試験シラバストピック:

1Z0-050 試験に関してよくいただくご質問

Oracle Database 11g: New Features for Administrators 認定 1Z0-050 試験問題：

問題 #1

You are managing an Oracle Database 11 g database with ASM storage. The ASM disk group has the COMPATIBLE .ASM attribute set to 11.1. Which statements are true regarding extent management and allocation units in the ASM disk group? (Choose all that apply.)

A. The allocation unit size may vary but the extent size is fixed.
B. Extent management is completely automated.
C. The au_size disk group attribute determines the size of allocation units in the disk group.
D. The allocation unit size and extent size are fixed for all the disks in a disk group and cannot be changed.

問題 #2

Evaluate the following SQL statement used to create the PRODUCTS table:
CREATE TABLE products
(product_id NUMBER(3) PRIMARY KEY,
product_desc VARCHAR2(25),
qty NUMBER(8,2),
rate NUMBER(10,2),
total_value AS ( qty * rate))
PARTITION BY RANGE (total_value)
(PARTITION p1 VALUES LESS THAN (100000),
PARTITION p2 VALUES LESS THAN (150000),
PARTITION p3 VALUES LESS THAN (MAXVALUE))
COMPRESS FOR ALL OPERATIONS;
Which statement is true regarding this command?

A. It executes successfully but the values in the TOTAL_VALUE column would not be physically stored in the partitions.
B. It produces an error because the TOTAL_VALUE column cannot be used as a partition key.
C. It executes successfully but partition pruning cannot happen for this partition key.
D. It produces an error because compression cannot be used for the TOTAL_VALUE partition key.

問題 #3

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 newly generated plans are directly placed into the SQL plan baseline without being verified.
B. The new SQL statements initially run with the plans that are known to produce good performance under standard test configuration.
C. The optimizer does not generate new plans for the SQL statements for which the SQL plan baseline has been imported.
D. The plan baselines can be evolved over time to produce better performance

問題 #4

You plan to use SQL Performance Analyzer to analyze the SQL workload. You created a SQL Tuning Set as a part of the workload capturing. What information is captured as part of this process? (Choose all that apply.)

A. the SQL text
B. the execution context Do- the execution frequency
C. the execution plan
D. the system change number (SCN)

問題 #5

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.

解説：