Oracle 1Z0-060 問題集

質問 1：
You are about to plug a multi-terabyte non-CDB into an existing multitenant container database (CDB) as a pluggable database (PDB).
The characteristics of the non-CDB are as follows:
- Version:Oracle Database 12c Releases 1 64-bit
- Character set: WE8ISO8859P15
- National character set: AL16UTF16
- O/S: Oracle Linux6 64-bit
The characteristics of the CDB are as follows:
- Version: Oracle Database 12c Release 1 64-bit
- Character set: AL32UTF8
- O/S:OracleLinux 6 64-bit
Which technique should you use to minimize down time while plugging this non-CDB into the CDB?
A. Data Pump full export / import
B. The DBMS_PDB package
C. RMAN
D. Transportable tablespace
E. Transportable database
正解：D

質問 2：
Which three can be performed on a Data Pump type external table? (Choose three.)
A. updating the table using an UPDATE statement
B. performing a CREATE TABLE AS SELECT (CTAS) to populate the table
C. creating an invisible index on the table
D. partitioning the table
E. creating a public synonym for the table
F. creating a view on the table
正解：A,B,C

質問 3：
You are connected to a pluggable database (PDB) as a common user with DBA privileges.
The STATISTICS_LEVEL parameter is PDB_MODIFIABLE. You execute the following:
SQL > ALTER SYSTEM SET STATISTICS_LEVEL = ALL SID = `*' SCOPE = SPFILE; Which is true about the result of this command?
A. Nothing happens; because there is no SPFILE for each PDB, the statement is ignored.
B. The STATISTICS_LEVEL parameter is set to all whenever the multitenant container database (CDB) is restarted.
C. The STATISTICS_LEVEL parameter is set to ALL whenever any PDB is reopened.
D. The STATISTICS_LEVEL parameter is set to all whenever this PDB is re-opened.
正解：D
解説: (Topexam メンバーにのみ表示されます)

質問 4：
You use the segment advisor to help determine objects for which space may be reclaimed.
Which three statements are true about the advisor given by the segment advisor?
A. It may advise the use of online table redefinition for tables in locally managed tablespaces
B. It may advise the use of segment shrink for tables in dictionary managed tablespaces it the no chained rows.
C. It may advise the use of online table redefinition for tables in dictionary managed tablespace.
D. It will detect and advise about chained rows.
E. It may advise the use of segment shrink for free list managed tables.
正解：A,C,D
解説: (Topexam メンバーにのみ表示されます)

質問 5：
You are about to plug a multi-terabyte non-CDB into an existing multitenant container database (CDB).
The characteristics of the non-CDB are as follows:
- Version: Oracle Database 11gRelease 2 (11.2.0.2.0) 64-bit
- Character set: AL32UTF8
- National character set: AL16UTF16
- O/S: Oracle Linux 6 64-bit
The characteristics of the CDB are as follows:
- Version: Oracle Database 12c Release 1 64-bit
- Character Set: AL32UTF8
- National character set: AL16UTF16
- O/S: Oracle Linux 6 64-bit
Which technique should you use to minimize down time while plugging this non-CDB into the CDB?
A. Data Pump full export/import
B. The DBMS_PDB package
C. RMAN
D. Transportable tablespace
E. Transportable database
正解：D
解説: (Topexam メンバーにのみ表示されます)

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

質問 7：
You notice a performance change in your production Oracle 12c database and you want to know what change caused this performance difference. You generate the compare period Automatic Database Diagnostic Monitor (ADDM) report to further investigation.
Which three findings would you get from the report?
A. It detects the top wait events causing performance degradation.
B. It gives information about statistics collection in both time periods.
C. It detects any configuration change that caused a performance difference in both time periods.
D. It shows the resource usage for CPU, memory, and I/O in both time periods.
E. It identifies any workload change that caused a performance difference in both time periods
正解：C,D,E

質問 8：
You want to upgrade your pre-12c database to an Oracle 12c database. You set up the test environment and replay the captured workload from the production database on the test machine twice with a time difference of four hours.
For which three reasons would you use the Compare Period ADDM report after the replay?
(Choose three.)
A. to check the performance improvement and degradation caused during the change
B. to compare the performance change of top SQL statements for the two runs
C. to find the resource consumption by SQL statements that are common to both periods
D. to review the hardware resources used during the two runs
E. to check the database time consumed for the two time periods
F. to review the change in the initialization parameters between the two runs
正解：A,C,D