1Z0-083 無料問題集「Oracle Database Administration II」

（A）With Automatic Memory Management, the database instance can increase the System Global Area size by reducing the Program Global Area size.

（B）On Line Transaction Processing systems often use less Program Global Area than Decision Support Systems.

（C）Automatically tuned and resized System Global Area components will always revert to their initial sizes after an instance restart.

（D）Automatic Memory Management must be used together with locking the System Global Area into physical memory.

（E）With Automatic Shared Memory Management, the database instance can increase the Large Pool size by reducing the Shared Pool size.

（F）With Automatic Shared Memory Management, the database instance can increase the Program Global Area size by reducing the System Global Area size.

（A）CDB1_TAB and APP_ROOT_TAB

（B）none of the tables, because all three tables will be dropped

（C）CDB1_TAB only

（D）CDB1_TAB, APP_ROOT_TAB, and APP_PDB1_TAB

（E）CDB1_TAB and APP_PDB1_TAB

（A）Cloning HR_ROOT automatically clones HR_PDB1.

（B）CDB1 and CDB2 must be in shared undo mode.

（C）The HR_PDB1 clone created in CDB2 will be in mount state when cloning ends.

（D）All transactions in HR_PDB1 of CDB1 must commit before the cloning process starts.

（E）A common user must exist in CDB2 with the CREATE PLUGGABLE DATABASE privilege.

（A）The HR_ROOT replica must exist in the remote CDB.

（B）A proxy PDB must exist in the application root in the local CDB.

（C）PDB3's application root replica must exist in the local CDB.

（D）A database link must exist in the local CDB root referring to the remote CDB.

（E）A database link must exist in the remote CDB referring to the local CDB.

（F）A proxy PDB must exist in the application root in the remote CDB.

（A）Flashback Database uses a restored control file to recover a database.

（B）Flashback Database can recover a database to the state that it was in before a reset logs operation.

（C）Flashback logs are used to restore to the blocks' before images, and then the redo data may be used to roll forward to the desired flashback time.

（D）The Oracle database automatically creates, deletes, and resides flashback logs in the Fast Recovery Area.

（E）Flashback Database can recover a data file that was dropped during the span of time of the flashback.

（F）Flashback logs are written sequentially, and are archived.

（A）It can be used to patch existing Oracle software installations.

（B）It can be used to create a single-instance Oracle Database in an already-installed Oracle home.

（C）It can be used to upgrade only single-instance databases running on Oracle Restart.

（D）It can be used to deploy new homes without disrupting active databases.

（E）It can be used to create templates of Oracle homes as gold images of only Oracle databases.

（F）It can be used only on nodes with Oracle Grid Infrastructure installed.

（A）RMAN "pushes" the backups of the database to be duplicated over the network to the auxiliary instance.

（B）The UNDO TABLESPACE clause is always required when no connection exists to the recovery catalog and the TARGET database is closed.

（C）The UNDO TABLESPACE clause is never required.

（D）RMAN disk-based backups of the database to be duplicated can be used by the auxiliary instance.

（E）The UNDO TABLESPACE clause is always required when no connection exists to the TARGET instance.

（A）A transportable data pump import can leave a plugged-in tablespace in read-only mode.

（B）Tablespaces always remain in read/write mode during transportable tablespace operations.

（C）A transportable data pump import can leave a plugged-in tablespace in read/write mode.

（D）Tablespaces never remain in read/write mode during transportable tablespace operations.

（E）Simultaneous data pump jobs can be limited at the pluggable database (PDB) level.

（F）An ordinary data pump export of a table with encrypted columns will always encrypt the same columns when imported.

（A）They are installed via OPatch or OPatchAuto.

（B）A base release is not needed to install patchsets.

（C）They are only released quarterly.

（D）They can introduce new features.

（E）They can be applied in a rolling fashion for Clusterware and the databases.

（F）Installing a patchset is considered an "upgrade".

（A）It applies patches in nonrolling mode by default.

（B）It must be invoked by a user with root user privileges.

（C）It requires the Oracle Grid Infrastructure and Oracle Database instances to be shut down before being invoked.

（D）Users must always input patch plans to opatchauto.

（E）It performs a shutdown and then a restart of all processes in both Oracle Grid Infrastructure and Oracle Database home during the patching process.

（F）It is used to apply interim patches to Oracle Grid Infrastructure and Oracle Database home combinations.

（G）Patches are applied via opatchauto.

（A）converting an application PDB to an application seed

（B）converting an application PDB to an application root

（C）converting an application PDB to a regular PDB

（D）converting a regular PDB to an application PDB

（E）converting an application seed to an application PDB

（F）converting an application container into another application container in a different CDB

（G）converting an application container into another application container in the same CDB

（A）A non-unique index can be converted to a unique index using a Data Definition Language (DDL) command.

（B）An index can be scanned to satisfy a query without the indexed table being accessed.

（C）An invisible index is maintained when a Data Manipulation Language (DML) command is per- formed on its underlying table.

（D）An index is always created by scanning the key columns from the underlying table.

（E）A descending index is a type of bitmapped index.

（A）2, 4, 5, 6, 7

（B）1, 2, 4, 6, 7, 8

（C）1, 2, 3, 4, 5, 6, 7, 8

（D）1, 2, 3, 4, 5, 7, 8

（E）1, 2, 4, 5, 7, 8

（A）seven

（B）three

（C）six

（D）eight

（E）five

（A）After the change, each existing PDB has to be reopened for the new undo mode to take effect.

（B）After the change, only a common user with the required privilege can create an undo tablespace in CDB&ROOT.

（C）Any new PDB and existing PDBs are automatically configured to use the default undo tablespace in CDB$ROOT.

（D）After the change, only one undo tablespace can exist in CDB$ROOT.

（E）After the change, any user with the required privilege can create an undo tablespace in the PDBs.

（F）Undo tablespaces existing in PDBs must be dropped before the change.

（A）Database Point-in-Time Recovery is performed by the Managed Recovery Process (MRP)

（B）The Database must be in ARCHIVELOG mode.

（C）The database must be open RESETLOGS after Database Point-in-Time Recovery.

（D）The target point for the recovery must be specified as a stime or System Change Number (SCN).

（E）The database must be in MOUNT state when performing Database Point-in-Time Recovery.

（F）The database must have FLASHBACK DATABASE ON to perform Database Point-in-Time Recovery.

（A）redo logs

（B）temporary tablespaces

（C）mandatory Oracle-supplied PL/SQL packages

（D）undo tablespaces

（E）all data dictionary metadata

（F）user-defined PL/SQL packages

（G）control files