Oracle 1z0-034 問題集

質問 1：
Note the output of the following query:
SQL> SELECTflashback_archive_name,status FROM dba_flashback_archive;
FLASHBACK_ARCHIVE_NAMESTATUS
FLA1
You executed the following command to enable Flashback Data Archive on the EXCHANGE_RATE table:
ALTERTABLEexchange_rateFLASHBACK ARCHIVE;
What is the outcome of this command?
A. The command generates an error because no Flashback Data Archive name is specified and there is no default Flashback Data Archive.
B. The Flashback Data Archive is created in the same tablespace where the tables are stored.
C. The Flashback Data Archive is created in the SYSAUX tablespace.
D. The table uses the default Flashback Data Archive.
正解：D

質問 2：
Which statements are true regarding system-partitioned tables? (Choose all that apply.)
A. Traditional partition pruning and partitionwise joins are not supported on these tables.
B. Only a single partitioning key column can be specified.
C. All DML statements must use partition-extended syntax.
D. Unique local indexes cannot be created on a system-partitioned table.
E. The same physical attributes must be specified for each partition.
正解：A,D

質問 3：
You executed the following commands:
SQL> ALTER SESSION SET OPTIMIZER_USE_PENDING_STATISTICS = false;
SQL> EXECUTE DBMS_STATS. SET_TABLE_PREFS('SH', '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 treated as the current statistics by the optimizer for the current sessions only.
B. The statistics are treated as the current statistics by the optimizer for all sessions.
C. The statistics are stored in the pending statistics table in the data dictionary.
D. The statistics are temporary and used by the optimizer for all sessions until this session terminates.
正解：C

質問 4：
The instance abnormally terminates because of a power outage. Which statement is true about redo log files during instance recovery?
A. Inactive and current redo log files are required to accomplish recovery
B. Online and archived redo files are required to accomplish instance recovery
C. All redo log entries after the last checkpoint are applied from redo log files to data files
D. All redo log entries recorded in the current log file until the checkpoint position are applied to data files
正解：C

質問 5：
View the Exhibit and examine the parameter settings in your server-side parameter file (SPFILE). When you tried to start the database instance, you received the following error:
SQL> startup ORA-00824: cannot set SGA_TARGET or MEMORY_TARGET due to existing internal settings, see alert log for more information
Why did the instance fail to start?
Exhibit:

A. Because both the SGA_TARGET and MEMORY_TARGET parameters are set.
B. Because the PGA_AGGREGATE_TARGET parameter is not set
C. Because MEMORY_TARGET and MEMORY_MAX_TARGET cannot be equal
D. Because the STATISTICS_LEVEL parameter is set to BASIC
正解：D
解説: (Topexam メンバーにのみ表示されます)

質問 6：
Tablespaces of certain types or in certain states can be renamed. Which four of these situations permit renaming a tablespace?
A. the default permanent tablespace for the non-SYSTEM users
B. an offline tablespace
C. the SYSTEM tablespace
D. a temporary tablespace
E. a read-only tablespace
F. an undo tablespace
正解：A,D,E,F

質問 7：
Which three elements can a job chain process involve? (Choose three)
A. an event
B. a program
C. a lightweight job
D. a schedule
E. another chain
正解：C,D,E
解説: (Topexam メンバーにのみ表示されます)

質問 8：
Multiple RMAN sessions are connected to the database instance. Examine the following output when backup commands are running in server sessions: What could have helped you to correlate server sessions with channels?

A. Specify the command ID in the RMAN script
B. Implement RMAN multiplexing
C. Set the DEBUG ON in the RMAN script
D. Use a tag with the RMAN BACKUP command
正解：A