Oracle 1z0-062 問題集

質問 1：
The persistent configuration settings for RMAN have default for all parameters.
Identify four RMAN commands that produce a multi-section backup.
A. BACKUP INCREMENTAL LEVEL 0 TABLESPACE SYSAUX SECTION SIZE 100M;
B. BACKUP TABLESPACE SYSTEM SECTION SIZE 100M;
C. BACKUP TABLESPACE "TEMP" SECTION SIZE 10M;
D. BACKUP ARCHIVELOG ALL SECTION SIZE 25M;
E. BACKUP TABLESPACE "UNDO" INCLUDE CURRENT CONTROLFILE SECTION SIZE 100M;
F. BACKUP AS COPY TABLESPACE SYSTEM SECTION SIZE 100M;
G. BACKUP SPFILE SECTION SIZE 1M;
正解：A,B,E,F

質問 2：
In your Oracle 12c database, you invoke SQL *Loader Express Mode command to load data:
$> sqlldr hr/hr table=employees
Which two statements are true about this command? (Choose two.)
A. It succeeds with default settings if the EMPLOYEES table belonging to the HR schema is already defined in the database.
B. It succeeds even if the HR user does not have the CREATE DIRECTORY privilege.
C. It succeeds and creates the EMPLOYEES table in the HR schema if the table does not exist.
D. It fails because the SQL *Loader control file location is not specified.
E. It fails because the SQL *Loader data file location is not specified.
正解：A,B

質問 3：
Which three statements are true about Automatic Workload Repository (AWR)? (Choose three.)
A. All AWR tables belong to the SYSTEM schema.
B. The manageability monitor (MMON) process gathers statistics and creates an AWR snapshot that is used by the self-tuning components in a database.
C. An AWR snapshot shows the SQL statements that are producing the highest load on the system, based on criteria such as elapsed time and CPU time.
D. An AWR snapshot contains system-wide tracing and logging information.
E. AWR data is stored in memory and in a database.
正解：B,C,E

質問 4：
You want to create a file watcher and an event-based job for detecting the arrival of files on the local server from various locations. To achieve this, you enable the raising of file arrival events from remote systems.
Which two conditions must be satisfied to receive file arrival events from a remote system? (Choose two.)
A. The remote system's scheduler agent must be registered with your database.
B. Database links to remote databases must be created.
C. The local database must be set up to run remote external jobs.
D. The initialization parameter REMOTE_OS_AUTHENT must be set to TRUE on your database.
E. The remote system must have a running Oracle Database instance and a scheduler agent installed.
正解：A,C
解説: (Topexam メンバーにのみ表示されます)

質問 5：
Examine the parameters:
Your database instance is started with a PFILE.

You want to increase the size of the buffer cache. Free memory is available to increase the size of the buffer cache.
You execute the command:
SQL> ALTER SYSTEM SET DB_CACHE_SIZE=1024M;
Which is the outcome?
A. It fails because the SCOPE clause is missing.
B. The value is changed only in the PFILE and takes effect at the next instance startup.
C. Change is applied to the current instance, but does not persist after instance restart.
D. The value is changed for the current instance and in the PFILE.
正解：C