2026年の1Z1-050試験は出題範囲が広く、十分な準備なしに挑むにはハードルの高い試験です。PassTestが提供するOracle Database 11g: New Features for Administrators対策問題集183問を繰り返し解くことで、出題傾向をつかみ、苦手分野を着実に克服できます。

Oracle 1Z1-050 試験概要:

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

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

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

問題 #1

You executed the following commands:
SQL> ALTER SESSION SET OPTIMIZER_USE_PENDING_STATISTICS = false;
SQL> EXECUTE DBMS_STATS.SET_TABLE_PREFS('SHI, 'CUSTOMERS', 'PUBLISH'.'false');
SQL> EXECUTE DBMS_STATS.GATHER_TABLE_STATS('SH', 'CUSTOMERS');
Which statement is correct regarding the above statistics collection on the SH.CUSTOMERS table in the above session?

A. The statistics are temporary and used by the optimizer for all sessions until this session terminates.
B. The statistics are treated as the current statistics by the optimizer for all sessions.
C. The statistics are treated as the current statistics by the optimizer for the current sessions only.
D. The statistics are stored in the pending statistics table in the data dictionary.

問題 #2

Examine the following RMAN command:
BACKUP DATABASE
TAG TESTDB
KEEP UNTIL 'SYSDATE+11
RESTORE POINT TESTDB06;
Which two statements are true regarding the backup taken by using the above RMAN command? (Choose two.)

A. The backup becomes obsolete after one day, regardless of the default retention policy settings.
B. The backup is deleted after one day, regardless of the default retention policy settings.
C. Only data files and the control file are backed up.
D. Archived redo logs are backed up only if the database is open during the backup

問題 #3

Evaluate the following command and Its output:
SQL>SELECT * FROM dba_temp_free_space;
TABLESPACE_NAME TABLESPACE_SIZE ALLOCATED_SPACE FREE_SPACE
LMTEMP 250609664 101048576 149561088
Which two statements correctly interpret the output? (Choose two.)

A. FREE_SPACE indicates both the space that is currently allocated and available for reuse, and the space that is currently unallocated.
B. FREE_SPACE indicates only the space that is currently allocated and available for reuse.
C. ALLO CAT ED_S PACE indicates only the space currently allocated and in use.
D. FREE_SPACE indicates only the space that is currently unallocated.
E. ALLO CAT ED_S PACE indicates both the space currently allocated and used, and the space that is available for reuse.

問題 #4

Evaluate the following command:
SQL>ALTER SYSTEM SET db_securefile = 'IGNORE1;
What is the impact of this setting on the usage of Secure Files?

A. It ignores the SECUREFILE option only if a Manual Segment Space Management tablespace is used and creates a Basic File.
B. It forces Secure Files to be created even if the BASICFILE option is specified to create the LO
C. It does not allow the creation of Secure Files and generates an error if the SECUREFILE option is specified to create the LOB.
D. It forces Basic Files to be created even if the SECUREFILE option is specified to create the LOB.

問題 #5

Which three are the valid statements in relation to SQL plan baselines? (Choose three.)

A. The plans in the SQL plan baseline are verified and accepted plans.
B. The plans can be manually loaded to the SQL plan baseline.
C. For the SQL plan baselines to be accessible to the optimizer, the SYSAUX tablespace must be online.
D. The plans generated for every SQL statement are stored in the SQL plan baseline by default.
E. The plan baselines are stored temporarily in the memory as long as the database instance is running.

解説：