1Z1-083試験無料問題集「Oracle Database Administration II 認定」

A. to generate an XML metadata file that describes a non-CDB Oracle 12c database so that it can be plugged in as a PDB

B. to determine whether an XML file describes a PDB that can be plugged into the CDB in which you run the procedure

C. to generate an XML metadata file that describes the current plugged-in PDB

D. to generate an XML metadata file from any unplugged PDB

E. to generate a . pdb archive file for any PDB in the current CDB

A. V$SESSION_WAIT_CLASS displays waits broken down by wait class only for terminated sessions.

B. V$SERVICE_EVENT displays wait counts for every wait event for each service even including counts of zero for waits that never occurred.

C. V$SESSION_WAIT and V$SESSION both contain details of the event on which a waiting session is currently waiting.

D. V$SESSION_EVENT displays all waits events for those events that have occurred at least once for sessions that have now terminated.

E. V$SESSION_WAIT and V$SESSION both contain details of the event on which a non-waiting session last waited.

A. the data dictionary in CDB$ROOT

B. the Process Monitor Process (PMON)

C. temporary tablespaces

D. undo tablespaces

E. the log writer process (LGWR)

F. SYSAUX tablespaces

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 PLUGGABLE DATABASE command can be used to back up CDB$ROOT.

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

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

A. Only the ORCL database instance is started.

B. Only the ORCL database instance, the Oracle ASM instance, and the +DATA and +FRA disk groups are started.

C. The ORCL database, the Oracle ASM instances, the +DATA and +FRA disk groups, and the LISTENER are started.

D. Only the ORCL database and the ASM instances are started.

E. Only the ORCL database instance and the +DATA and +FRA disk groups are started.

A. It fails because connection to the AUXILIARY instance must be as SYSDBA.

B. It succeeds.

C. No catalogued backup of the TARGET is used to duplicate the database.

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

E. Itsucceeds only if the target database is greater than 400M.

A. A media corrupt block is one where the block is not formatted correctly.

B. If a row lock is held by a nonexistent transaction, the block containing the row is logically corrupt.

C. If a row lock is held by a nonexistent transaction, the block containing the row is media corrupt.

D. DB_BLOCK_CHECKING=TRUE causes a check sum to be added to each data block to help detect physical or media corruption.

E. The ANALYZE TABLE VALIDATE STRUCTURE CASCADE command verifies that each table row has an index entry pointing to it.

F. DB_LOST_WRITE_PROTECT=TYPICAL causes extra logging overhead on the standby database.

A. A non-CDB can be converted into a PDB.

B. A PDB in a remote CDB can be accessed transparently there by aggregating results from local and remote PDBs.

C. A PDB created from PDB$SEED must be set to READ WRITE after loading data.

D. A PDB unplugged from a container database (CDB) can be plugged into a different CDB without altering any of its schemas.

E. A PDB created from PDB$SEED must be set to READ ONLY after loading data.

F. An unplugged PDB can be plugged into multiple CDBs simultaneously by sharing data files.

G. A PDB can be plugged into a CDB only if both are of the same Oracle Database release.

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

B. Flashback logs are not archived.

C. Flashback logs are maintained in redo log files.

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

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

A. The source PDB can be in MOUNT or OPEN state.

B. The source PDB must not be an application root.

C. A backup of the PDB must exist, taken using the BACKUP command with the TO PLATFORM clause.

D. The source PDB must be in MOUNT state.

E. Automatic conversion of endianness occurs.

F. The source and target platforms must have the same endianness.

A. A password encryption of backups uses the password while creating and restoring backups.

B. Image copy backups can be created by using password encryption.

C. A database uses the same encryption key for every encrypted backup.

D. Encrypted backups can only be written to disk.

E. Transparent encryption of backups uses an encryption wallet.

A. 1, 5, 6

B. 3, 4, 1, 6, 8

C. 1, 3, 5, 6, 7

D. 1, 3, 5, 7

E. 2, 5, 6

A. Enable asynchronous disk I/O.

B. Increase the level of RMAN multiplexing.

C. Disable FORCE LOGGING for the database.

D. Increase the size of the database buffer cache.

E. Increase the size of tape I/O buffers.

A. V$SESSION_EVENT displays all waits for all past sessions if the wait has occurred at least once for a session.

B. V$SESSION_WAIT_CLASS displays waits broken down by wait class only for waiting sessions.

C. V$SESSION_WAIT and V$SESSION both contain details of the event on which a session is currently waiting.

D. V$SERVICE_EVENT displays all waits for all services if the wait has occurred at least once for a service.

E. V$SESSION_EVENT displays all waits for all past and existing sessions if the wait has occurred at least once for a session.

F. V$SESSION_WAIT and V$SESSION both contain details of the event on which a non-waiting session last waited.

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

B. It is used to apply interim patches to Oracle Grid Infrastructure and Oracle Database home combinations.

C. Patches are applied via opatchauto.

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

E. It applies patches in nonrolling mode by default.

F. It must be invoked by a user with root user privileges.

G. Users must always input patch plans to opatchauto.

A. Tables or table partitions from the system and sysaux tablespaces cannot be recovered.

B. Tables with not null constraints cannot be recovered.

C. Tables or table partitions can be recovered only when the database is in mount state.

D. Tables or table partitions with a foreign key cannot be recovered.

E. Tables or table partitions can be recovered by using an auxiliary instance only.

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

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

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

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

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