Oracle 1Z0-052 問題集

質問 1：
View the Exhibit and examine the attributes of an undo tablespace. In an OLTP system, the user SCOTT has started a query on a large table in the peak transactional hour that performs bulk inserts. The query runs for more than 15 minutes and then SCOTT receives the following error:
ORA-01555: snapshot too old
What could be the reason for this error?
Exhibit:

A. There is not enough space in Flash Recovery Area.
B. There is not enough free space in the flashback archive.
C. The query is unable to place data blocks in undo tablespace.
D. The query is unable to get a read-consistent image.
正解：D
解説: (Topexam メンバーにのみ表示されます)

質問 2：
You are managing an Oracle Database 11g database running in ARCHIVELOG mode. The Flash Recovery Area is specified as the destination for the archived redo log files. You notice this warning in the alert log file:
ORA19815: WARNING: db_recovery_file_dest_size of 3221225472 bytes is 100.00% used, and has 0 remaining bytes available.
What would you do to reclaim the used space in the Flash Recovery Area? (Choose two.)
A. Manually delete all the expired backup sets from the Flash Recovery Area by using operating system (OS) commands.
B. Manually delete all the archived log files from the Flash Recovery Area by using operating system (OS) commands.
C. Back up the Flash Recovery Area.
D. Decrease the retention time for the database backup and flashback log files.
正解：C,D

質問 3：
Note the following functionalities of various background processes:
1 . Record the checkpoint information in data file headers.
2 . Perform recovery at instance startup.
3 . Cleanup unused temporary segments.
4 . Free the resources used by a user process when it fails.
5 . Dynamically register database services with listeners.
6 . Monitor sessions for idle session timeout.
Which option has the correct functionalities listed for a background process?
A. Database Writer Process (DBWn): 1, 3, 4
B. Archiver Process (ARCn): 1, 2, 5
C. System Monitor Process (SMON): 1, 4, 5
D. Process Monitor Process (PMON): 4, 5, 6
正解：D

質問 4：
You want to enable archiving on your database. Presently, the database is running in NOARCHIVELOG mode.
Given below are the steps to accomplish the task in random order:
1 . Shut down the instance.
2 . Execute the ALTER DATABASE ARCHIVELOG command.
3 . Start up the instance and mount the database.
4 . Set the DB_RECOVERY_FILE_DEST initialization parameter to
$ ORACLE_HOME/dest_1.
5. Open the database.
Which is the correct sequence of steps for accomplishing the task?
A. 1, 3, 2, 5; 4
B. 4, 1, 5, 2; 3
C. 4, 1, 3, 2, 5
D. 1, 3, 4, 5; 2
E. 1, 3, 4, 5, 2
正解：A

質問 5：
Which two are true about Optimizer Statistics? (Choose two.)
A. They can be used to determine the events on which a database instance waited
B. They are automatically updated when DDL statements execute
C. They do not persist across instance restarts
D. They can be gathered by executing the PL/SQL procedures in the DBMS_STATS package
E. They are gathered by the Manageability Monitor (MMON) background process
F. They provide information to the Optimizer so that it can determine optimal execution plans for SQL statements
正解：D,F
解説: (Topexam メンバーにのみ表示されます)