Oracle Oracle Certifications 1Z0-063 Questions & Answers

• Question 41:

  Identify two scenarios in which the RMAN crosscheck command can be used. (Choose two.)

  A. when checking for backups that are not required as per the retention policy

  B. when updating the RMAN repository if any of the archived redo log files have been deleted without using RMAN to do the deletes

  C. when updating outdated information about backups that disappeared from disk or media or became corrupted and inaccessible

  D. when synchronizing backups, which were not performed by using RMAN, with the RMAN repository

  E. when listing backups that are required for recovery operations

  Correct Answer: BE

• Question 42:

  On your Oracle 12c database, you invoke SQL*Loader to load data into the employees table in the hr schema by issuing the command:

  S>sqlldrhr/hr@pdb table=employees

  Which two statements are true about the command? (Choose two.)

  A. It succeeds with default settings if the employees table exists in the hr schema.

  B. It fails because no SQL*Loader data file location is specified.

  C. It fails if the hr user does not have the create any directory privilege.

  D. It fails because no SQL*Loader control file location is specified.

  E. It succeeds and creates the employees table in the HR schema.

  Correct Answer: AD

• Question 43:

  Which two statements are true about dropping a pluggable database (PDB)? (Choose two.)

  A. A PDB must be in MOUNT state or it must be unplugged.

  B. The data files associated with a PDB are automatically removed from disk.

  C. A dropped and unplugged PDB can be plugged back into the same multitenant container database (CDB) or other CDBs.

  D. A PDB must be in closed state.

  E. The backups associated with a PDB are removed.

  F. A PDB must have been opened at least once after creation.

  Correct Answer: AC

  Unplugging a PDB

  The following prerequisites must be met:

  The current user must have SYSDBA or SYSOPER administrative privilege, and the privilege must be

  either commonly granted or locally granted in the PDB. The user must exercise the privilege using AS

  SYSDBA or AS SYSOPER at connect time.

  The PDB must have been opened at least once.

  The PDB must be closed. In an Oracle Real Application Clusters (Oracle RAC) environment, the PDB must

  be closed on all instances.

  Dropping a PDB

  The DROP PLUGGABLE DATABASE statement drops a PDB. You can drop a PDB when you want to

  move the PDB from one CDB to another or when you no longer need the PDB. ?THIS MAKES C

  CORRECT. When you drop a PDB, the control file of the CDB is modified to eliminate all references to the

  dropped PDB. Archived redo log files and backups associated with the PDB are not removed, but you can

  use Oracle Recovery Manager (RMAN) to remove them.

  When dropping a PDB, you can either keep or delete the PDB's data files by using one of the following

  clauses:

  KEEP DATAFILES, the default, retains the data files.

  The PDB's temp file is removed even when KEEP DATAFILES is specified because the temp file is no

  longer needed.

  INCLUDING DATAFILES removes the data files from disk.

  If a PDB was created with the SNAPSHOT COPY clause, then you must specify INCLUDING DATAFILES

  when you drop the PDB.

  The following prerequisites must be met:

  The PDB must be in mounted mode, or it must be unplugged.

• Question 44:

  Your database has a table CUSTOMERS that contains the columns CUST_NAME, AMT_DUE, and OLD_STATUS.

  Examine the commands executed and their output:

  

  Why is it that only one update is listed by the Flashback Version Query?

  A. Supplemental logging is not enabled for the database.

  B. The undo data that existed for versions of rows before the change to the table structure is invalidated.

  C. The DB_FLASHBACK_RETENTION_TARGET parameter is set to a lower value and the undo data pertaining to the first transaction is flushed out.

  D. Undo retention guarantee is not enabled.

  E. Flashback Data Archive is full after the first update statement.

  Correct Answer: B

• Question 45:

  Which two methods can be used to add an Oracle 11g database to a multitenant container database (CDB) as a pluggable database (PDB)? (Choose two.)

  A. Use the DBMS_PDB package to plug the Oracle 11g database into the existing CDB as a PDB.

  B. Use the CREATE DATABASE ... ENABLE PLUGGABLE DATABASE statement to create a PDB by copying data files from PDB$SEED and use data pump to load data from the Oracle 11g database into the newly created PDB.

  C. Pre-create a PDB in CDB and use data pump to load data from the complete database export of the Oracle 11g database into the newly created PDB.

  D. Pre-create a PDB in CDB and use the NETWORK_LINK and PARALLEL parameters with data pump import to import data from the Oracle 11g database to the newly created PDB.

  E. Upgrade the Oracle 11g database to a 12c non-CDB and use the DBMS_PDB.DESCRIBE procedure to plug the database as a new PDB into the CDB.

  Correct Answer: DE

• Question 46:

  In which three scenarios is media recovery required? (Choose three.)

  A. when a tablespace is accidentally dropped from a database

  B. when archived redo log files are lost

  C. when data files are lost

  D. when one of the online redo log members is corrupted

  E. when all control files are lost

  Correct Answer: ACE

  Reference: http://docs.oracle.com/cd/A87860_01/doc/server.817/a76993/recoscen.htm

• Question 47:

  In the SPFILE, UNDO TABLESPACE is Set to UNDOTBS.

  You rename the undotbs undo tablespace:

  ALTER TABLESPACE undotbs RENAME TO undotbs_old;

  Which statement is true?

  A. The tablespace will be renamed but the data file headers will not be updated.

  B. The statement will fail because you cannot rename an undo tablespace.

  C. The tablespace will be renamed and all the changes will be logged in the alert log.

  D. The tablespace will be renamed and a message written to the alert log indicating that you should change the corresponding initialization parameter.

  E. You must set the undo_tablespace parameter to some other tablespace name before renaming undotbs.

  Correct Answer: C

• Question 48:

  After implementing full Oracle Data Redaction, you change the default value for the number data type as follows:

  SQL> SELECT NUMBER_VALUE FROM REDACTION_VALUES_FOR_TYPE_FULL; NUMBER_VALUE

  SQL> EXEC DBMS_REDACT.UPDATE_FULL_REDACTI0N_VALUES(-1) PL/SQL procedure successfully completed.

  SQL> select number_value from redaction_values_for_type_full; NUMBER VALUE

  After changing the value, you notice that FULL redaction continues to redact numeric data with a zero.

  What must you do to activate the new default value for numeric full redaction?

  A. Re-enable redaction policies that use FULL data redaction.

  B. Re-create redaction policies that use FULL data redaction.

  C. Re-connect the sessions that access objects with redaction policies defined on them.

  D. Flush the shared pool.

  E. Restart the database instance.

  Correct Answer: E

  About Altering the Default Full Data Redaction Value You can alter the default displayed values for full Data Redaction polices. By default, 0 is the redacted value when Oracle Database performs full redaction (DBMS_REDACT.FULL) on a column of the NUMBER data type. If you want to change it to another value (for example, 7), then you can run the DBMS_REDACT.UPDATE_FULL_REDACTION_VALUES procedure to modify this value. The modification applies to all of the Data Redaction policies in the current database instance. After you modify a value, you must restart the database for it to take effect.

• Question 49:

  Identify three scenarios in which RMAN will use backup sets to perform active database duplication. (Choose three.)

  A. when the duplicate ... from active database command contains the section size clause

  B. when you perform active database duplication on a database with flashback disabled

  C. when you specify set encryption before the duplicate ... from active database command

  D. when the number of auxiliary channels allocated is equal to or greater than the number of target channels E. when you perform active database duplication on a database that has read-only tablespaces

  Correct Answer: ACD

  Reference: http://docs.oracle.com/database/121/BRADV/rcmdupdb.htm#BRADV298

• Question 50:

  Which two statements are true about recovering logically corrupted tables or table partitions from an RMAN backup? (Choose two.)

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

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

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

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

  E. Tables with not null constraints cannot be recovered.

  Correct Answer: AD

  Reference:

  http://docs.oracle.com/database/121/BRADV/rcmresind.htm#BRADV695 (Limitations of Recovering Tables

  and Table Partitions from RMAN Backups)