Oracle 1z0-063 問題集

質問 1：
Examine the output:
SQL> ARCHIVE LOG LIST
Database log modeArchive Mode
Automatic archival Enabled
Archive DestinationUSE_DB_RECOVERY_FILE_DEST
Oldest online log sequence376
Next log sequence to archive378
Current log sequence378
Which three types of files are automatically placed in the fast recovery area? (Choose three.)
A. Server parameter file (SPFILE)
B. Archived redo log files
C. Control file autobackups
D. Recovery Manager (RMAN) backup pieces
E. Flashback data archives (FDA)
正解：B,C,D

質問 2：
You have set the value of the NLS_TIMESTAMP_TZ_FORMAT parameter to YYYY-MM-DD. The default format of which two data types would be affected by this setting? (Choose two.)
A. INTERVAL YEAR TO MONTH
B. INTERVAL DAY TO SECOND
C. DATE
D. TIMESTAMP
E. TIMESTAMP WITH LOCAL TIME ZONE
正解：D,E

質問 3：
You want to create a guaranteed restore point for your databases by executing the command:
SQL> CREATE RESTORE POINT dbrsp1 GUARANTEE FLASHBACK DATABASE;
Identify two prerequisites for the successful execution of this command. (Choose two.)
A. The database must be running in ARCHIVELOG mode.
B. The recyclebin must be enabled for the database.
C. Fast Recovery Area must be enabled.
D. A database backup must be taken.
E. Flashback Database must be enabled.
F. Undo retention guarantee must be enabled
正解：A,C

質問 4：
In an Oracle 12c database, you attempt to load data into the HR.EMPLOYEES table in a pluggable database (PDB):
$> sqlldr hr/hr@pdb table=employees
Which three are true? (Choose three.)
A. It succeeds if HR is a common user.
B. It succeeds if HR is a local user in the PDB to which HR connects.
C. It loads data into HR.EMPLOYEES if the table exists in CDB$ROOT.
D. It loads data into HR.EMPLOYEES if the table exists in the PDB to which HR connects.
E. It creates the HR.EMPLOYEES table in the PDB and loads data into it if the table does not exist in the PDB to which HR connects.
正解：B,D,E

質問 5：
Examine these RMAN commands:

Which two statements are true about the DUPLICATE command? (Choose two.)
A. It fails because connection to the AUXILIARY instance must be as SYSDBA.
B. It succeeds.
C. It succeeds only if the target database is greater than 400M.
D. No catalogued backup of the TARGET is used to duplicate the database.
E. It fails because no parallel channels are allocated for the auxiliary database.
正解：C,D

質問 6：
Your database supports an OLTP workload. Examine the output of the query:

To ensure faster instance recovery, you set the FAST_START_MTTR_TARGET initialization parameter to
30.
What is the effect of this setting on the database?
A. Automatic checkpoint tuning is disabled.
B. The MTTR advisor is disabled.
C. The frequency of log switches is increased.
D. The overhead on database performance is increased because of frequent writes to disk.
正解：D