Oracle 1Z0-083 問題集

質問 1：
Which three RMAN persistent settings can be set for a database?
A. multiple backup device types for a single backup
B. default destinations for backups
C. backup retention policy
D. default backup device type
E. default section size for backups
正解：B,C,D

質問 2：
Which three actions will add a resource to an Oracle Restart configuration? (Choose three.)
A. creating a disk group using the CREATE DISKGROUP SQL statement
B. creating a database using the CREATE DATABASE SQL statement
C. creating a database service using Oracle Database Configuration Assistant (DBCA)
D. creating an Oracle Database service by modifying the SERVICE_NAMES parameter
E. creating a database service using DBMS_SERVICE.CREATE_SERVICE
F. creating an Oracle Automatic Storage Management (ASM) instance with ASM Configuration Assistant (ASMCA)
正解：A,C,F
解説: (Topexam メンバーにのみ表示されます)

質問 3：
Which three are true about an application container?
A. It always contains multiple applications.
B. Two or more application PDBs in the same application container can be given exclusive access to some tables.
C. It can have new application PDBs created by copying PDB$SEED.
D. Two or more application PDBs in the same application container can share access to tables.
E. It always has a new application PDBs created by copying PDB$SEED.
F. It always contains a single application.
正解：B,C,D

質問 4：
Which statement correctly describes the SQL profiling performed by the SQL Tuning Advisor?
A. It is a set of recommendations by the optimizer to change the access methods used.
B. It is a set of recommendations by the optimizer to restructure a SQL statement to avoid suboptimal execution plans.
C. It is auxiliary information collected by the optimizer for a SQL statement to eliminate estimation error.
D. It is auxiliary information collected by the optimizer for a SQL statement to help use better joins orders.
E. It is a set of recommendations by the optimizer to create new indexes.
正解：B
解説: (Topexam メンバーにのみ表示されます)

質問 5：
Which two are true about Oracle Optimizer Statistics, their use, and their collection? (Choose two.)
A. Statistics collected using DBMS_STATS always yield the best optimizer result.
B. The number of table rows is considered when evaluating the cost of accessing a table using an index.
C. The Statistics Advisor generates actions for all recommendations.
D. Index balanced B*Tree height is considered when evaluating the cost of using an index.
E. The Statistics Advisor can help recommend the best way to gather statistics.
正解：D,E
解説: (Topexam メンバーにのみ表示されます)

質問 6：
You configured the Fast Recovery Area (FRA) for your database. The database instance is in ARCHIVELOG mode. The default location for the archived redo log files is the FRA. Which two files are removed automatically if space is required in the FRA as per the retention policy?
A. RMAN backups that are obsolete
B. user-managed backups of data files and control files
C. archived redo log files that have multiple copies in a different archive location
D. flashback logs
正解：A,D