최신 1Z0-083 무료덤프 - Oracle Database Administration II

A. Data Pump full transportable database

B. Data Pump full database export and import

C. the DBMS_PDB package

D. Data Pump transportable tablespaces

E. cloning the non-CDB as a PDB

F. replication using GoldenGate

A. CDB$ROOT, PDB$SEED, PDB2, PDB1, PDB3, and PDB4

B. CDB$ROOT, PDB1, PDB2, PDB3, and PDB4

C. CDB$ROOT, PDB$SEED, PDB2, PDB1, and PDB3

D. CDB$ROOT, PDB2, PDB1, and PDB3

E. CDB$ROOT, PDB$SEED, PDB1, PDB3, PDB2, and PDB4

A. a default database configuration

B. a Data Warehouse database template, with t he dedicated server mode option and AMM enabled

C. a General Purpose database template, with t he shared server mode option and Automatic Memory Management (AMM) enabled

D. a General Purpose database template with default memory allocation

A. Open the CDB instance in upgrade mode.
In cdb$root, execute alter database local undo on, and then restart the CDB instance.

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 in read-only mode.
In cdb$root, ex cute alter database local undo on, and then change the CDB to read/write mode.

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 each PDB, execute alter database local undo on, create an undo tablespace, and hen restart the CDB instance.

A. Binary compression cannot be applied to the backup.

B. Backups can be written only to media.

C. Backups can be written only to disk.

D. Backups can be taken only for data files.

E. Backups can be taken only if a fast recovery area is configured.

F. Backups can be written only if checksums are stored for each block.

A. It contains predefined common roles in both the root and the seed.

B. It can have local users with the same name in different PDBs.

C. It can be created by cloning an existing CDB.

D. It can contain only one Application Container seed, which is created when the Application Container is created.

E. It can contain only one PDB$SEED, which is created when the CDB is created.

F. It can have any number of pluggable databases (PDBs) limited only by space availability.

G. It can be created from a non-CDB.

A. It succeeds and creates multisection backup sets that are used for active database duplication.

B. It succeeds only if the target database is in MOUNT state.

C. It fails because no parallel channels are allocated for the auxiliary database.

D. It fails because there is no connection to a recovery catalog.

A. It considers the filters in WHERE clauses when generating execution plans for SQL statements.

B. It obeys all hints.

C. It can only use SQL Plan Directives tied to the SQL statement for which a plan is being generated.

D. It considers object statistics when generating execution plans for SQL statements.

E. It can re-optimize execution plans after previous executions detect suboptimal plans.

F. It updates stale object statistics in the Data Dictionary.

A. Flashback logs are maintained in the Flash Recovery Area.

B. Flashback logs need to be cleared manually after you disable Flashback Database.

C. Flashback logs are used to maintain Flashback Database related errors.

D. Flashback logs are maintained in redo log files.

E. Flashback logs are not archived.

A. The control file is backed up whenever a new table is created.

B. The server parameter file (SPFILE) is automatically backed up each time the control file is backed up.

C. The control file is backed up whenever an RMAN backup is successfully recorded in the catalog.

D. The control file is backed up whenever a new tablespace is created.

E. It requires the use of fast recovery area (FRA).

F. The control file is backed up automatically each time the SPFILE is backed up manually.

A. defining foreign keys for all tables to speed up joins

B. defining primary keys for all tables to speed up all queries

C. the configuration of storage arrays

D. using check constraints to speed up updates

E. the physical data model

A. The CSS daemon runs from the Grid Infrastructure home.

B. It supports volume management, file system, and automatic restart capabilities.

C. It can manage database resources on the server where it is installed or on a different server.

D. It must be installed before the Oracle database software is installed.

E. It requires Oracle Automatic Storage Management (ASM) components to be installed separately.

A. It is enabled by performing a software-only Oracle Database installation and then running the roohctl-enable script.

B. It is enabled by performing an Oracle Database installation with database creation and then running the roohctl-enable script.

C. It requires the Rapid Home Provisioning service.

D. Its configuration data and log files reside in subdirectories under the Oracle home.

E. It contains an image that can be distributed across multiple servers.

A. The insert on USER2.DEPT is a recursive autonomous transaction by the child session and is committed.

B. The insert on USER2.DEPT is uncommitted.

C. The inserts on USER1.EMP were rolled back when the session connected to PDB2.

D. The inserts on USER1.EMP were committed when the session connected to PDB2.

E. The inserts on USER1.EMP remain uncommitted when the session connected to PDB2.

F. The inserts on USER1.EMP were committed when the session inserted a row into USER2.DEPT.

G. The insert on USER2.DEPT fails because of the active transaction in the parent container.

A. Backing up a database in NOARCHIVELOG mode using O/S utilities requires that the database instance be shut down.

B. 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.

C. Oracle archive log backups, copied using an O/S utility, can be added to the RMAN catalog as a backup set.

D. An Oracle database can be restored from backup files copied using O/S utilities.

E. Oracle data file backups, copied using an O/S utility, can be added to the RMAN catalog as IMAGE COPIES.

F. 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.

G. 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.