最新的Oracle Database Administration II - 1Z1-083免費考試真題

A. An image copy on disk can be copied to sbt.

B. An image copy on disk can be copied to disk.

C. A backup set may be duplexed with both copies written to sbt.

D. An image copy on sbt can be copied to disk.

E. A backup set may be duplexed so that one copy is written to sbt and the other to disk.

F. A backup set may be duplexed with both copies written to disk.

A. when free space in a dictionary managed tablespace falls below a specified percentage

B. when the total number of logons exceeds a specific value

C. when the total number of locked user account exceeds a specific value

D. when a resumable statement is suspended

E. when the number of logons per second exceeds a specific value

F. when free space in a locally managed tablespace falls below a specified percentage

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

B. RMAN "pushes" the backups of the database to be duplicated over the network to the auxiliary instance.

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

D. The NOREDO clause can be used if the backups of the database being duplicated were taken when the database was in ARCHIVELOG mode.

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

F. RMAN SBT-based backups of the database to be duplicated can be used by the auxiliary instance.

G. The UNDO TABLESPACE clause is always required when no connection exists to the recovery catalog and the TARGET database is opened.

H. The NOREDO clause must be used if the backups of the database being duplicated were taken when the database was in NOARCHIVELOG mode.

A. SPFILE backups can be created while connected to an application root PDB.

B. Tablespaces from different PDBs with identical names must be backed up by connecting RMAN separately to each PDB to back up the tablespaces.

C. The BACKUP DATABASE PLUS ARCHIVELOG command will back up archive logs when RMAN is connected to a PDB.

D. The BACKUP PLUGGABLE DATABASE command can be used to back up CDB$ROOT.

E. The BACKUP DATABASE command will create a pluggable database (PDB) backup when RMAN is connected to a PDB.

A. It can be used to create container databases and non-container databases.

B. It can only be launched from the command line interface.

C. It can be used to change the character set of an existing database.

D. It can be launched from both the command line and the Universal Installer (OUI) interfaces.

E. It can be used to convert a non-container database to a container database.

A. It fails because Data Pump cannot be container.

B. It creates a full export of only the used while connected to the root container and PDB1.

C. It creates a full export of the root container and all open PDBs.

D. It creates a full export of the root container and all PDBs.

A. the installation of Oracle ASMLIB

B. a group called dba

C. an operating system user to own this installation

D. the Oracle Inventory group to install

E. an operating system account called grid

A. BACKUP ARCHIVELOG ALL SECTION SIZE 25M;

B. BACKUP AS COPY TABLESPACE SYSTEM SECTION SIZE 100M;

C. BACKUP TABLESPACE SYSTEM SECTION SIZE 100M;

D. BACKUP INCREMENTAL LEVEL 0 TABLESPACE SYSAUX SECTION SIZE 100M;

E. BACKUP TABLESPACE "UNDO" INCLUDE CURRENT CONTROLFILE SECTION SIZE
100M;

F. BACKUP TABLESPACE "TEMP" SECTION SIZE 10M;

G. BACKUP SPFILE SECTION SIZE 1M;

A. A PDB snapshot must be a full copy of a source PDB.

B. A CDB can be duplicated using Recovery Manager (RMAN) with no configuration required before starting the duplication.

C. A CDB can be duplicated using the Database Configuration Assistant (DBCA) in silent mode.

D. A CDB can be duplicated only by using the Database Configuration Assistant (DBCA).

E. A PDB snapshot can be a sparse copy of a source PDB.

A. to specify a default tablespace in a PDB cloned from another PDB in the same CDB.

B. to specify the list of tablespaces to include when creating a PDB from the CDB seed

C. to include specific user tablespaces only when relocating a PDB

D. to exclude all tablespaces except SYSTEM, SYSAUX, and TEMP when plugging in a PDB

E. to specify the list of user tablespaces to include when moving a non-CDB to a PDB

F. to exclude a temp tablespace when plugging in a PDB

A. Cleared stateful alerts are displayed by querying DBA_ALERT_HISTORY.

B. They are generated by SMON when a tablespace is 97% full.

C. STATISTICS_LEVEL must be set to ALL to generate alerts.

D. A space usage management alert is automatically cleared after the underlying problem is resolved.

E. All metrics are instance related.

F. Metrics are statistical counts for a specific unit.

A. An application root PDB is created for APP1.

B. An application seed PDB is created for APP1.

C. APP1 can never be unplugged.

D. Application PDBs that are subsequently created in the APP1application container will be cloned from APP1$SEED.

E. A default service is created for the application root APP1.

F. Application PDBs that are subsequently created in the APP1 application container will be cloned from PDB$SEED.

A. It cannot repair logical corruption.

B. To use it, Flashback Database must be enabled.

C. The data file containing the block being recovered remains online.

D. The target database for which one or more blocks are to be recovered must be in the OPEN state.

E. A block being recovered is not accessible.

F. It can be performed on noncorrupt blocks.