Oracle 1Z0-083 問題集

質問 1：
Which four are true about duplicating a database using Recovery Manager (RMAN)? (Choose four.)
A. A connection to the recovery catalog instance is always required.
B. A connection to an auxiliary instance is always required.
C. A backup of the target database is always required.
D. Duplication can be done by having the auxiliary database instance pull backup sets from the target database instance.
E. A subset of the target database can be duplicated.
F. A connection to the target database instance is always required.
G. Duplication can be done by having the target database instance push copies to the auxiliary database instance.
H. A new DBID is always created for the duplicated database.
正解：B,D,E,G
解説: (Topexam メンバーにのみ表示されます)

質問 2：
Which two are true about RMAN backups when using a media manager? (Choose two.)
A. A media manager always writes RMAN requested backups to tape.
B. A media manager is required to create RMAN proxy copies.
C. By default, a request for a proxy copy may result in a backup set being created.
D. A media manager is required to create RMAN image copies.
E. The media manager layer (MML) routines provided by Oracle support any vendors' media management products.
正解：B,C
解説: (Topexam メンバーにのみ表示されます)

質問 3：
Your SALES_ROOTapplication container has two application PDBs.
The SALES_APPapplication has a common table, FIN.REVENUE, in the two PDBs.
Examine this query and its output:

Which two are true? (Choose two.)
A. A container map exists for the REVENUE table, but is not enabled.
B. The CONTAINERS clause cannot be used in queries on the REVENUE table.
C. The REVENUE table must be a list-partitioned table.
D. The MAPTABLE table is a metadata-linked table.
E. The MAPTABLE tables defines a logical partition key on a commonly used column for the REVENUE table.
F. The REVENUE table partitions are not pruned across the PDBs automatically.
正解：E,F
解説: (Topexam メンバーにのみ表示されます)

質問 4：
Which three are true about backup, restore, and recovery operations done without using Recovery Manager (RMAN)? (Choose three.)
A. Backing up a database in ARCHIVELOG mode using O/S utilities requires that the database instance be started and the database be in MOUNT state.
B. Oracle data file backups, copied using an O/S utility, can be added to the RMAN catalog as IMAGE COPIES.
C. Backing up a database in NOARCHIVELOG mode using O/S utilities requires that the database instance be shut down.
D. An Oracle database can be restored from backup files copied using O/S utilities.
E. Oracle archive log backups, copied using an O/S utility, can be added to the RMAN catalog as a backup set.
F. Backing up a database in NOARCHIVELOGmode using O/S utilities requires that the database instance be started and the dataabse be in the MOUNT state.
G. Backing up a database in ARCHIVELOG mode using O/S utilities requires that the database instance be started and the database be in OPEN state.
正解：B,C,D
解説: (Topexam メンバーにのみ表示されます)

質問 5：
Which three are true about Automatic Workload Repository (AWR) and Automatic Database Diagnostic Monitor (ADDM) in an Oracle multitenant environment? (Choose three.)
A. No AWR data is stored in the CDB$ROOT SYSAUX tablespace.
B. ADDM can run in a nonroot container.
C. All AWR data is stored in the CDB$ROOT SYSAUX tablespace.
D. AWR snapshots can be created in CDB$ROOT.
E. AWR snapshots can be created in a PDB.
F. AWR reports can be generated while connected to any container.
正解：B,D,E
解説: (Topexam メンバーにのみ表示されます)

質問 6：
Which three are performed by Oracle Automatic Storage Management (ASM) instances?
(Choose three.)
A. managing space allocation for Oracle ASM files
B. managing extent allocation for Oracle database segments
C. mounting disk groups
D. acting as an I/O server to write data file blocks to ASM disks on behalf of Database Writer processes (DBWn)
E. managing Allocation Units (AUs) for disk group content
F. acting as an I/O server to read data file blocks from ASM disks on behalf of database server processes
正解：A,C,E
解説: (Topexam メンバーにのみ表示されます)