Oracle Oracle Certifications 1Z0-063 Questions & Answers

• Question 251:

  Which two can be backed up by using RMAN in a database that is in ARCHIVELOG mode? (Choose two.)

  A. online redo log files while the database is open

  B. data files while the database is open

  C. PFILE and password file in MOUNT state

  D. data blocks in data files that have changed since the previous backup

  E. data files while the database is in NOMOUNT state

  Correct Answer: BD

• Question 252:

  You regularly take backups of your database using RMAN with a recovery catalog. Your database is currently open and the temp01.dbf temp file belonging to the TEMP tablespace is corrupted.

  Identify two methods to recover the temp file with the least disruption to database availability. (Choose two.)

  A. Drop the TEMP tablespace, and then re-create it with new temp files.

  B. Restart the database instance to create the temp file automatically.

  C. Take the TEMP tablespace offline, drop the missing temp file, and then create a new temp file.

  D. Add a new temp file to the TEMP tablespace with a new name, and then drop the temp file that is corrupted.

  Correct Answer: BC

  Temp files are a special class of data files that are associated only with temporary tablespaces.

  B: After restore and recovery of a whole database, when the database is open, missing temporary tablespaces that were recorded in the control file are re-created with their previous creation size, AUTOEXTEND, and MAXSIZE attributes. Only temporary tablespaces that are missing are re-created. If a temp file exists at the location recorded in the RMAN repository but has an invalid header, then RMAN does not re-create the temp file.

  If the temp files were created as Oracle-managed files, then they are re-created in the current DB_CREATE_FILE_DEST location. Otherwise, they are re-created at their previous locations.

  C: If a data file becomes missing or corrupted. You must take it offline before you can open the database.

  References: https://docs.oracle.com/database/121/ADMIN/dfiles.htm https://docs.oracle.com/database/121/BRADV/rcmcomre.htm

• Question 253:

  You are administering a multitenant container database (CDB) that has no startup triggers and contains three pluggable databases (PDBs).

  You execute the command to start up the CDB: SQL> STARTUP

  Which statement is true?

  A. CDB$ROOT, PDB$SEED, and the PDBs are opened in read-only mode.

  B. CDB$ROOT and PDB$SEED are opened in read-only mode, but the PDBs are in closed mode.

  C. CDB$ROOT is opened in read/write mode, but PDB$SEED and the PDBs are in closed mode.

  D. CDB$ROOT is opened in read/write mode, PDB$SEED in read-only mode, and the PDBs in MOUNT state.

  E. CDB$ROOT, PDB$SEED, and the PDBs are opened in read/write mode.

  Correct Answer: D

  If neither READ WRITE nor READ ONLY is specified, a PDB will be opened in READ ONLY if a CDB to

  which it belongs is used as a physical standby database, otherwise the PDB will be opened READ WRITE.

  Prerequisites for a PDB STARTUP

  When the current container is a pluggable database (PDB), the STARTUP command can only be used if:

  *

  The PDB is in MOUNTED mode, excluding the use of the FORCE option.

  *

  The PDB must be in READ ONLY or READ WRITE mode to be in mounted mode. Etc.

  References: https://docs.oracle.com/database/121/SQPUG/ch_twelve045.htm

• Question 254:

  RMAN is connected to a target database instance and an auxiliary instance. You execute the command:

  

  What is the outcome?

  A. RMAN uses the push method to transfer image copies.

  B. RMAN uses the push method to transfer backup sets.

  C. RMAN uses the pull method to restore files using backup sets.

  D. RMAN uses the pull method to restore files using image copies.

  Correct Answer: C

  When RMAN performs active database duplication using backup sets, a connection is established with the source database and the auxiliary database. The auxiliary database then connects to the source database through Oracle Net Services and retrieves the required database files from the source database. This method of active database duplication is also to as the pull-based method.

  Example: DUPLICATE TARGET DATABASE TO dupdb FROM ACTIVE DATABASE PASSWORD FILE SPFILE NOFILENAMECHECK; Incorrect Answers: A, B, D: When active database duplication is performed using image copies, after RMAN establishes a connection with the source database, the source database transfers the required database files to the auxiliary database. Using image copies may require additional resources on the source database. This method is referred to as the push-based method of active database duplication.

  References: https://docs.oracle.com/database/121/BRADV/rcmdupdb.htm

• Question 255:

  You want to migrate your Oracle 11g database as a pluggable database (PDB) in a multitenant container database (CDB).

  Examine the steps required to perform the migration:

  1.

  Use Data Pump export to perform a full transportable export on the source database with the export parameter VERSION=12.

  2.

  Place all tablespaces in read-only mode on the source database.

  3.

  Upgrade the source database to Oracle Database 12c.

  4.

  Copy the dump file and data files to the desired location in the target database.

  5.

  Create a new PDB in the target CDB.

  6.

  Synchronize the PDB on the target CDB.

  7.

  Use Data Pump import on the new PDB by using the full transportable import options.

  Identify the required steps in the correct order.

  A. 1, 5, 4, 7, and 6

  B. 3, 2, 5, 1, 4, and 7

  C. 2, 5, 1, 4, 7, and 6

  D. 2, 1, 3, 5, 7, and 6

  Correct Answer: C

  This example is a dumpfile-based full transportable export/import operation. In this case the metadata from

  the source database is exported to a dump file, and both the dump file and the tablespace data files are

  transferred to a new system.

  The steps would be as follows:

  *

  (2) Set user tablespaces in the source database to READ ONLY.

  *

  (5) Create a CDB on the destination system, including a PDB into which you will import the source database.

  *

  (1) From the Oracle Database 11g Release 2 (11.2.0.3) environment, export the metadata and any data residing in administrative tablespaces from the source database using the FULL=Y and TRANSPORTABLE=ALWAYS parameters. Note that the VERSION=12 parameter is required only when exporting from an Oracle Database 11g Release 2 database.

  *

  (4) Copy the tablespace data files from the source system to the destination system.

  *

  (7) In the Oracle Database 12c environment, connect to the pre-created PDB and import the dump file.

  References: http://www.oracle.com/technetwork/database/upgrade/upgrading-oracle-database-wp-12c1896123.pdf, page 11

• Question 256:

  Which three statements are true about the database instance startup after an instance failure? (Choose three.)

  A. The RECO process recovers the uncommitted transactions at the next instance startup.

  B. Online redo log files and archived redo log files are required to complete the rollback stage of instance recovery.

  C. Uncommitted changes are rolled back to ensure transactional consistency.

  D. The SMON process coordinates the database recovery.

  E. Media recovery is required to complete the database recovery.

  F. Changes committed before the failure, which were not written to the data files, are re-applied.

  Correct Answer: ACD

  A: Occasionally a database closes abnormally with one or more distributed transactions in doubt (neither committed nor rolled back). When you reopen the database and recovery is complete, the RECO background process automatically, immediately, and consistently resolves any in-doubt distributed transactions.

  C: Crash and instance recovery involve two distinct operations: rolling forward the current, online datafiles by applying both committed and uncommitted transactions contained in online redo records, and then rolling back changes made in uncommitted transactions to their original state.

  D: The SMON background process performs instance recovery, applying online redo automatically. No user intervention is required.

  References: https://docs.oracle.com/cd/B28359_01/server.111/b28318/startup.htm https://docs.oracle.com/database/121/CNCPT/startup.htm

• Question 257:

  A database instance uses an SPFILE. Examine the parameter: You plan to multiplex the control file to a new location, parallelization for the backup set./u01/app/oracle/oradata/cdb1/disk3/control03.ctl/.

  

  Examine the possible steps that are in random order:

  1. Shut down the database instance.

  2.Issue ALTER SYSTEM SET CONTROL_FILES= `/u01/app/oracle/oradata/cdb1/disk1/control01.ctl, /u01/

  app/oracle/oradata/cdb1/disk2/control02, ctl, /u01/app/oracle/oradata/cdb1/disk3/control03.ctl'

  SCOPE=SPFILE;.

  3.

  Issue ALTER SYSTEM SET CONTROL_FILES=

  `/u01/app/oracle/oradata/cdb1/disk1/control01.ctl, /u01/app/oracle/oradata/cdb1/disk2/control02.ctl, /u01/

  app/oracle/oradata/cdb1/disk3/control03.ctl';.

  4.

  Copy the control file from the existing location to `/u01/app/oracle/oradata/cdb1/disk3/control03.ctl'.

  5.

  Mount the database.

  6.

  Open the database.

  Identify the required steps in the correct order to accomplish the task.

  A. 3, 4

  B. 2, 1, 4, 6

  C. 3, 1, 4, 6

  D. 1, 5, 2, 4, 6

  E. 2, 6

  Correct Answer: B

• Question 258:

  You accidentally drop the CUSTOMERS table, and then recover it by using the FLASHBACK TABLE command.

  Which two statements are true about the dependent objects of the CUSTOMERS table? (Choose two.)

  A. Only the primary key constraint created for the table is flashed back, whereas all other indexes must be retrieved separately.

  B. All the constraints defined on the table, except the referential integrity constraints, are flashed back.

  C. All the triggers associated with the table are flashed back but are disabled.

  D. Materialized views that use the CUSTOMERS table are flashed back.

  E. LOB segments associated with the CUSTOMERS table are flashed back.

  Correct Answer: BE

  B: Oracle Database retrieves all indexes defined on the table except for bitmap join indexes, and all triggers and constraints defined on the table except for referential integrity constraints that reference other tables.

  Incorrect Answers:

  A: Flashback Table restores tables while automatically maintaining associated attributes such as current indexes, triggers, and constraints, and in this way enabling you to avoid finding and restoring databasespecific properties. Furthermore. indexes on table that exist currently are reverted and reflect the state of the table at the Flashback point.

  C: By default, the database disables triggers on the affected table before performing a FLASHBACK TABLE operation. After the operation, the database returns the triggers to the state they were in before the operation (enabled or disabled). To keep triggers enabled during the flashback of the table, add an ENABLE TRIGGERS clause to the FLASHBACK TABLE

  D: Flashback Table operations are not valid for the following type objects: tables that are part of a cluster, materialized views, Advanced Queuing (AQ) tables, static data dictionary tables, system tables, remote tables, object tables, nested tables, or individual table partitions or subpartitions.

  References: Oracle Database, Backup and Recovery User's Guide, 12 Release 2 (January 2017), page 18-11

• Question 259:

  You are administering a multitenant container database (CDB) that contains multiple pluggable databases (PDBs). RMAN is connected to CDB$ROOT.

  Examine the command:

  RMAN> LIST FAILURE;

  Which statement is true about this command?

  A. It lists failures only for the CDB root database.

  B. It lists failures for a PDB only when RMAN is connected to a recovery catalog.

  C. It lists failures for the CDB and all the PDBs in this CDB.

  D. It lists failures only if RMAN is connected to a PDB.

  Correct Answer: A

  In the current release, Data Recovery Advisor can only be used to diagnose and repair data corruptions in

  non-CDBs and the root of a multitenant container database (CDB). Data Recovery Advisor is not

  supported for pluggable databases (PDBs).

  Note: You can run the LIST FAILURE command to show all known failures.

  References: https://docs.oracle.com/database/121/BRADV/rcmrepai.htm

• Question 260:

  Which three methods can be used to create a pluggable database (PDB) in an existing multitenant container database (CDB)? (Choose three.)

  A. Use PDB$SEED for creating a PDB.

  B. Use the DBMS_PDB package to plug a non-CDB into an existing CDB.

  C. Clone an existing PDB.

  D. Use Enterprise Manager Database Express to create a PDB in an existing CDB.

  E. Use the DBMS_PDB package to plug a pre-Oracle 12c database into an existing CDB.

  Correct Answer: BCD