Oracle 1Z0-055 問題集

質問 1：
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

質問 2：
View the following SQL statements:
Transaction T1
INSERT INTO hr.regions VALUES (5,'Pole');
COMMIT;
Transaction T2
UPDATE hr.regions SET region_name='Poles' WHERE region_id = 5;
COMMIT;
Transaction T3
UPDATE hr.regions SET region_name='North and South Poles' WHERE
region_id = 5;
You want to back out transaction T2. Which option would you use?
A. It is possible with the NONCONFLICT_ONLY option.
B. It is possible with the NOCASCADE_FORCE option.
C. It is possible, but transaction T3 also backs out.
D. It is not possible because it has conflicts with transaction T3.
正解：B

質問 3：
To generate recommendations to improve the performance of a set of SQL queries in an application, you execute the following blocks of code:
BEGIN
dbms_advisor.create_task(dbms_advisor.sqlaccess_advisor,'TASK1'); END; / BEGIN
dbms_advisor.set_task_parameter('TASK1','ANALYSIS_SCOPE','ALL');
dbms_advisor.set_task_parameter('TASK1','MODE','COMPREHENSIVE'); END; / BEGIN
dbms_advisor.execute_task('TASK1'); dbms_output.put_line(dbms_advisor.get_task_script('TASK1')); END;
/
The blocks of code execute successfully; however, you do not get the required outcome.
What could be the reason?
A. A workload needs to be associated with the task.
B. A template needs to be associated with the task.
C. The partial or complete workload scope needs to be associated with the task.
D. The type of structures (indexes, materialized views, or partitions) to be recommended need to be specified for the task.
正解：A

質問 4：
Which two statements regarding the Flashback Table feature are correct? (Choose two.)
A. Flashback Table uses log mining to extract SQL_REDO and SQL_UNDO statements.
B. Flashback Table can be performed on system tables.
C. Flashback Table operation acquires exclusive data manipulation language (DML) locks.
D. Flashback Table operation does not shrink the segments.
正解：C,D

質問 5：
View the Exhibit to examine the Automatic Database Diagnostic Monitor (ADDM) tasks.
You executed the following commands:
SQL> VAR tname VARCHAR2(60);
SQL> BEGIN :tname := 'my_instance_analysis_mode_task'; DBMS_ADDM.INSERT_SEGMENT_DIRECTIVE(:tname,'Sg_directive','SCOTT');
END;
Which statement describes the consequence?

A. The ADDM task is filtered to produce the Segment Advisor suggestions for the SCOTT schema only.
B. All subsequent ADDM tasks including my_instance_analysis_mode_task are filtered to suppress the Segment Advisor suggestions for the SCOTT schema.
C. The PL/SQL block produces an error because the my_instance_analysis_mode_task task has not been reset to its initial state.
D. The ADDM task is filtered to suppress the Segment Advisor suggestions for the SCOTT
schema.
正解：C

質問 6：
You are using Recovery Manager (RMAN) to perform backups. In which three situations would you perform a compressed backup? (Choose three.)
A. You are backing up to tape and your tape device performs its own compression.
B. You are making image copies, and you have not enabled tablespace compression.
C. You are using disk-based backups and disk space in your Flash Recovery Area, or other disk-based backup destinations are limited.
D. You are using some archival backup media, such as CD or DVD, where reducing backup sizes saves media costs and archival storage.
E. You are performing your backups to some device over a network where reduced network bandwidth is more important than CPU usage.
正解：C,D,E

質問 7：
Which two statements are true with respect to the maintenance window? (Choose two.)
A. A DBA can enable or disable an individual task in all maintenance windows.
B. A DBA cannot change the duration of the maintenance window after it is created.
C. In case of a long maintenance window, all Automated Maintenance Tasks are restarted every four hours.
D. A DBA can control the percentage of the resource allocated to the Automated Maintenance Tasks in each window.
正解：A,D