Oracle 1Z0-083 問題集

質問 1：
The USERS tablespace consists of data files 3 and 4 and must always be online in read/write mode.
Which two are true about using RMAN to perform an open database back up of this tablespace?
(Choose two.)
A. Backups can be taken only if the database is in ARCHIVELOG mode.
B. The database must be registered in an RMAN catalog.
C. Backups must be contained in backup sets.
D. Backups must be done incrementally.
E. Backups can be done incrementally.
F. Only consistent backups can be created.
正解：A,E
解説: (Topexam メンバーにのみ表示されます)

質問 2：
How do you configure a CDB for local undo mode?
A. Open the CDB in read-only mode.
In cdb$root, ex cute alter database local undo on, and then change the CDB to read/write mode.
B. Open the CDB instance in restricted mode.
In cdb$root, execute alter database local undo on.
create an undo tablespace in each PDB, and hen restart the CDB instance
C. Open the CDB instance in upgrade mode.
In each PDB, execute alter database local undo on, create an undo tablespace, and hen restart the CDB instance.
D. Open the CDB instance in restricted mode.
In cdb$root, drop the undo tablespace.
Execute alter database local undo on in each PDB and then restart the CDB instance.
E. Open the CDB instance in upgrade mode.
In cdb$root, execute alter database local undo on, and then restart the CDB instance.
正解：E
解説: (Topexam メンバーにのみ表示されます)

質問 3：
Which two are true about creating RMAN backups for an Oracle container database? (Choose two.)
A. Control file backups can be created while connected to the root container.
B. Online Redo Log backups can be created while connected to the root container.
C. Control file backups can be created while connected to a nonroot container.
D. The BACKUP TABLESPACEcommand can back up a PDBtablespace even if RMAN is connected to CDB$ROOT.
E. Archived Redo Log backups can be created while connected to an application root CDB.
正解：A,D
解説: (Topexam メンバーにのみ表示されます)

質問 4：
Which three are true about opatchauto? (Choose three.)
A. It is used to apply interim patches to Oracle Grid Infrastructure and Oracle Database home combinations.
B. Users must always input patch plans to opatchauto.
C. It applies patches in nonrolling mode by default.
D. It must be invoked by a user with root user privileges.
E. Patches are applied via opatchauto.
F. It performs a shutdown and then a restart of all processes in both Oracle Grid Infrastructure and Oracle Database home during the patching process.
G. It requires the Oracle Grid Infrastructure and Oracle Database instances to be shut down before being invoked.
正解：A,D,F
解説: (Topexam メンバーにのみ表示されます)

質問 5：
You create a table with the PERIOD FOR clause to enable the use of the Temporal Validity feature of Oracle Database 12c. Examine the table definition: create table employees (empno number, salary number, deptid number, name varchar2(100), period for employee_time); Which three statements are true concerning the use of the Valid Time Temporal feature for the EMPLOYEES table?
A. The valid time columns are not populated by the Oracle Server automatically.
B. The valid time columns are visible by default when the table is described.
C. Thesamestatementmayfilteronbothtransactiontimeandvalidtemporaltimebyusingthe AS OF TIMESTAMP and PERIOD FOR clauses.
D. The valid time columns employee_time_start and employee_time_end are automatically created.
E. Setting the session valid time using DBMS_FLASHBACK_ARCHIVE.ENABLE_AT_VALID_TIME sets the visibility for data manipulation language (DML), data definition language (DDL), and queries performed by the session.
正解：A,C,D

質問 6：
Examine these queries and their output:

After a system crash, an instance restart and an attempted opening of the PDBs result in:

Which two are true? (Choose two.)
A. Data file 24 cannot be recovered while the CDB is opened.
B. Data file 24 must be recovered while PDB2 is closed.
C. Data file 24 must be recovered while the CDB is opened.
D. Data file 24 can be recovered while CDB$ROOT and PDB$SEED are opened.
E. Data file 24 can be recovered while PDB2 is opened.
正解：D,E
解説: (Topexam メンバーにのみ表示されます)