Oracle 1Z0-083 問題集

質問 1：
You plan to perform cross-platform PDB transport using XTTS. Which two are true?
A. The source PDB must not be an application root.
B. The source and target platforms must have the same endianess.
C. The source PDB must be in MOUNT state.
D. A backup of the PDB must exist, taken using the BACKUP command with the To PLATFORM clause.
E. The source PDB can be in MOUNT or OPEN state.
F. Automatic conversion of endianess occurs.
正解：B,E

質問 2：
Which are the three steps in the SQL tuning process for Oracle Database environments?
A. Identify poorly tuned SQL statements using the SQL Tuning Advisor.
B. Identify poorly tuned SQL statements using Automatic Database Diagnostic Monitor.
C. Tune SQL statements as a group using the SQL Tuning and SQL Access Advisors.
D. Test the application as a whole using tuned SQL statements.
E. Test tuned SQL statements one at a time for all statements in the application.
F. Tune individual SQL statements using the SQL Tuning Advisor.
正解：B,D,F

質問 3：
Examine this configuration:
4. CDB1is an Oracle Database 12c Release 2 database containing pluggable databases PDB$SEED, PDB1, and PDB2.
5. PDB$SEEDis open READ ONLY
6. PDB1is open READ WRITE
7. PDB2 is MOUNTED.
8. ORACLE_HOMEis /u01/app/oracle/product/18.1.0/dbhome_1.
You execute these commands before upgrading the database to the current release:

For which databases will fixup scripts be created?
A. CDB1, PDB$SEED, and PDB1 only
B. CDB1, PDB$SEED, PDB1, and PDB2
C. CDB1 and PDB$SEED only
D. CDB1, PDB1, and PDB2 only
E. PDB$SEED, PDB1, and PDB2 only
正解：A
解説: (Topexam メンバーにのみ表示されます)

質問 4：
Which three statements are true about Oracle database block space management?
A. An update statement cannot cause chained rows to occur.
B. A row can be migrated to a block in the same extent as the extent containing the original block.
C. An insert statement can result in a migrated row.
D. A row can be migrated to a block in a different extent than the extent containing the original block.
E. An insert statement can result in a chained row.
正解：B,D,E

質問 5：
Which are three of the steps taken by Database Configuration Assistant (DBCA) to clone a remote pluggable database (PBD) starting from Oracle 19c? (Choose three.)
A. creating a new empty PDB in the local database from PDB$SEED
B. creating a database link from CDB$ROOT in the local database to the PDB in the remote system that is to be cloned
C. creating a database link from CDB$ROOT in the remote database to the PDB in the local database
D. creating a database link from CDB$ROOT in the local database to CDB$ROOT in the remote system that is to be cloned
E. opening the cloned PDB
F. automatically dropping the database link to the remote database if it already exists
G. creating a database link from CDB$ROOT in the remote database to be cloned to CDB$ROOT in the local database
正解：D,E,F
解説: (Topexam メンバーにのみ表示されます)

質問 6：
SQL Performance Analyzer (SPA) has reported several regressed SQL statements for one of your databases.
Which action could help in the performance management of these regressed SQL statements?
A. Create an adaptive execution plan for each of the regressed statements
B. Use The SQL Tuning Advisor for each of the regressed statements.
C. Create SQL plan directives for each of the regressed statements.
D. Use the SQL Access Advisor for each of the regressed statements.
正解：B