Oracle 1Z0-060 問題集

質問 1：
Examine the structure of the customers table:

CUSTNO is the primary key in the table. You want to find out if any customers' details have been entered more than once using different CUSTNO, by listing all the duplicate names.
Which two methods can you use to get the required result?
A. Self-join
B. Subquery
C. Left outer-join with self-join
D. Full outer-join with self-join
E. Right outer-join with self-join
正解：A,B

質問 2：
Which three tasks can be automatically performed by the Automatic Data Optimization feature of Information lifecycle Management (ILM)?
A. Tracking insert time by row for table rows
B. Tracking the most recent write time for a table block
C. Tracking the most recent write timefor a table segmentin a usertablespace
D. Tracking the most recent read time for a table segment in the SYSAUX tablespace
E. Tracking the most recent read time for a table segment in a user tablespace
F. Tracking the most recent write time for a table segment in the SYSAUX tablespace
正解：B,C,E
解説: (Topexam メンバーにのみ表示されます)

質問 3：
You enabled an audit policy by issuing the following statements:
SQL> AUDIT POLICY ORA_DATABASE_PARAMETER BY SCOTT;
SQL> AUDIT POLICY ORA_DATABASE_PARAMETER BY SYS, SYSTEM;
For which database users and for which executions is the audit policy now active? (Choose two.)
A. Only for failed executions
B. SCOTT, but not SYS and SYSTEM
C. Only for successful executions
D. Both successful and failed executions
E. SCOTT, SYS and SYSTEM
F. SYS and SYSTEM, but not SCOTT
正解：D,F

質問 4：
Your multitenant container (CDB) containing three pluggable databases (PDBs) is running in ARCHIVELOG mode. You find that the SYSAUX tablespace is corrupted in the root container.
The steps to recover the tablespace are as follows:
1. Mount the CDB.
2. Close all the PDBs.
3. Open the database.
4. Apply the archive redo logs.
5. Restore the data file.
6. Take the SYSAUX tablespace offline.
7. Place the SYSAUX tablespace offline.
8. Open all the PDBs with RESETLOGS.
9. Open the database with RESETLOGS.
10. Execute the command SHUTDOWN ABORT.
Which option identifies the correct sequence to recover the SYSAUX tablespace?
A. 6, 5, 4, 7
B. 10, 1, 2, 5, 4, 9, 8
C. 10, 1, 2, 5, 8
D. 10, 1, 5, 8, 10
正解：A
解説: (Topexam メンバーにのみ表示されます)

質問 5：
Which normal form is a table in if it has no multi-valued attributes and no partial dependencies?
A. First normal form
B. Second normal form
C. Third normal form
D. Fourth normal form
正解：B

質問 6：
Which three statements are true about adaptive SQL plan management?
A. The optimizer always uses the fixed plan, if the fixed plan exists in the plan baseline.
B. The non-accepted plans are automatically accepted and become usable by the optimizer if they perform better than the existing accepted plans.
C. It automatically performs verification or evolves non-accepted plans, in COMPREHENSIVE mode when they perform better than existing accepted plans.
D. The non-accepted plans in a SQL plan baseline are automatically evolved, in COMPREHENSIVE mode, during the nightly maintenance window and a persistent verification report is generated.
E. It adds new, bettor plans automatically as fixed plans to the baseline.
正解：B,C,D
解説: (Topexam メンバーにのみ表示されます)

質問 7：
Examine the contents of SQL loader control file:

Which three statements are true regarding the SQL* Loader operation performed using the control file?
A. The SQL* Loader data file myfile1.dat has the column names for the EMP table.
B. The SQL* Loader operation assumes that the file must be a stream record format file with the normal carriage return string as the record terminator.
C. The SQL* Loader operation fails because no record terminators are specified.
D. An EMP table is created if a table does not exist.
Otherwise, if the EMP table is appended with the loaded data.
E. Field names should be the first line in the both the SQL* Loader data files.
正解：A,B,C

質問 8：
You wish to enable an audit policy for all database users, except SYS, SYSTEM, and SCOTT.
You issue the following statements:
SQL> AUDIT POLICY ORA_DATABASE_PARAMETER EXCEPT SYS;
SQL> AUDIT POLICY ORA_DATABASE_PARAMETER EXCEPT SYSTEM;
SQL> AUDIT POLICY ORA_DATABASE_PARAMETER EXCEPT SCOTT;
For which database users is the audit policy now active?
A. All users except sys and SCOTT
B. All users except SYS
C. All users except sys, system, and SCOTT
D. All users except SCOTT
正解：D
解説: (Topexam メンバーにのみ表示されます)