Oracle Oracle Database 1Z0-067 Questions & Answers

• Question 231:

  You want to create a guaranteed restore point for your database by executing the command:

  SQL> CREATE RESTORE POINT dbrsp1 GUARANTEE FLASHBACK DATABASE;

  Identify two prerequisites for the successful execution of this command.

  A. The database must be running in archivelog mode.

  B. Flashback Database must be enabled.

  C. Fast Recovery Area must be enabled.

  D. The recyclebin must be enabled for the database.

  E. Undo retention guarantee must be enabled.

  F. A database backup must be taken.

  Correct Answer: AC

  SQL> select flashback_on from v$database; FLASHBACK_ON

  NO SQL> CREATE RESTORE POINT dbrsp1 GUARANTEE FLASHBACK DATABASE; Restore point created. SQL> archive log list; Database log mode Archive Mode Automatic archival Enabled Archive destination USE_DB_RECOVERY_FILE_DEST Oldest online log sequence 113 Next log sequence to archive 115 Current log sequence 115 SQL> Reference: http://docs.oracle.com/cd/B19306_01/backup.102/b14192/rpfbdb002.htm

• Question 232:

  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 233:

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

  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

  References:

  https://www.pythian.com/blog/table-recovery-with-rman-in-database-12c/ https://docs.oracle.com/

  database/121/BRADV/rcmresind.htm#BRADV695

• Question 234:

  Your database is running in archivelog mode and a nightly backup of the database, along with an autobackup of the control file, is taken by using RMAN. Because of a media failure, the SPFILE and the control files are lost.

  Examine the steps to restore the SPFILE and the control file to mount the database:

  1.

  Set DBID of the target database in RMAN.

  2.

  Start the database instance by using the STARTUP FORCE NOMOUNT command in RMAN.

  3.

  Restore the control files from the backup.

  4.

  Mount the database.

  5.

  Restore the SPFILE from the autobackup.

  6.

  Create a PFILE from the recovered SPFILE.

  7.

  Restart the instance in NOMOUNT state.

  Identify the required steps in the correct order.

  A. 1, 2, 5, 3, 6, 4

  B. 1, 2, 3, 5, 6, 4

  C. 2, 1, 5, 7, 3, 4

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

  Correct Answer: C

• Question 235:

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

  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

  Starting with Oracle Database 12c Release 1 (12.1), RMAN can use backup sets to transfer the source database files that need to be duplicated. The backup sets are transferred over the network to the auxiliary database. Backup sets can be encrypted for additional security. Specify the encryption algorithm by using the SET ENCRYPTION ALGORITHM command before the DUPLICATE command. RMAN uses backup sets to perform active database duplication when the connection to the target database is established using a net service name and any one of the following conditions is satisfied: The DUPLICATE ... FROM ACTIVE DATABASE command contains either the USING BACKUPSET, USING COMPRESSED BACKUPSET, or SECTION SIZE clause. The number of auxiliary channels allocated is equal to or greater than the number of target channels allocated. Reference:http://docs.oracle.com/database/121/BRADV/rcmdupdb.htm#BRADV298

• Question 236:

  You created a database with DBCA by using one of the Oracle supplied templates.

  Which is the default permanent tablespace for all users except DBSNMP and OUTLN?

  A. USERS

  B. SYSTEM

  C. SYSAUX

  D. EXAMPLE

  Correct Answer: A

  This table space is used to store permanent user objects and data. Like the TEMP table space, every database should have a table space for permanent user data that is assigned to users. Otherwise, user objects will be created in the SYSTEM table space, which is not good practice. In the preconfigured database, USERS is assigned the default table space, and space for all objects created by non-system users comes from this table space. For system users, the default permanent table space remains SYSTEM.

• Question 237:

  Your database is running in archivelog mode. Examine the parameters for your database instance:

  LOG_ARCHIVE_DEST_l ='LOCATION=/disk1/arch MANDATORY' LOG_ARCHIVE_DEST_2 ='LOCATION=/disk2/arch' LOG_ARCHIVE_DEST_3 ='LOCATIO=/disk3/arch' LOG_ARCHIVE_DEST _4 ='LOCATIONs/disk4/arch' LOG_ARCHIVE _MIN_SUCCEED_DEST = 2

  While the database is open, you notice that the destination set by the log_archive_dest_1 parameter is not available. All redo log groups have been used.

  What happens at the next log switch?

  A. The database instance hangs and the redo log files are not overwritten.

  B. The archived redo log files are written to the fast recovery area until the mandatory destination is made available.

  C. The database instance is shutdown immediately.

  D. The destination set by the log_archive_dest parameter is ignored and the archived redo log files are created in the next two available locations to guarantee archive log success.

  Correct Answer: A

  Explanation: Made more logfile switch until all redos groups are full. first log switch succeds, second also succeds then next will hang database.

• Question 238:

  Examine the steps to configure Oracle Secure Backup (OSB) for use with RMAN:

  1.Create media families for data files and archived redo log files.

  2.Configure database backup storage selectors or RMAN media management parameters.

  3.Create an OSB user preauthorized for RMAN operations.

  4.Configure RMAN Access to the OSB SBT.

  5.Disable Non-Uniform Memory Access (NUMA) awareness by setting the ob_ignore_numa parameter to

  0.

  Identify the steps in the correct order.

  A. 1, 4, 3, 2, 5

  B. 1, 3, 4, 5, 2

  C. 4, 3, 1, 2, 5

  D. 4, 3, 5, 1, 2

  Correct Answer: C

  Reference: http://docs.oracle.com/cd/B19306_01/backup.102/b14234/obadm_odb.htm#BDCBGJBF

• Question 239:

  Examine the RMAN command:

  RMAN> SET ENCRYPTION IDENTIFIED BY ON FOR ALL TABLESPACES; RMAN> BACKUP DATABASE PLUS ARCHIVELOG;

  Which type of encryption is used for the backup performed by using this command?

  A. password-mode encryption

  B. dual-mode encryption

  C. transparent encryption

  D. default encryption

  Correct Answer: B

  To make dual-mode encrypted backups: Start RMAN and connect to a target database and recovery catalog (if used). Execute the SET ENCRYPTION BY PASSWORD command, making sure to omit the ONLY keyword. The following example sets the encryption password for all tablespaces (where password is a placeholder for the actual password that you enter) in the backup and omits ONLY to indicate dual-mode encryption: SET ENCRYPTION IDENTIFIED BY password ON FOR ALL TABLESPACES; References:http://docs.oracle.com/cd/B28359_01/backup.111/b28270/rcmbckad.htm#CEGEJABH

• Question 240:

  The following parameters are set for your Oracle 12c database instance:

  OPTIMIZER_CAPTURE_SQL_PLAN_BASELINES=FALSE OPTIMIZER_USE_SQL_PLAN_BASELINES=TRUE

  You want to manage the SQL plan evolution task manually. Examine the following steps:

  1.

  Set the evolve task parameters.

  2.

  Create the evolve task by using the DBMS_SPM.CREATE_EVOVLE_TASK function.

  3.

  Implement the recommendations in the task by using the DBMS_SPM.IMPLEMENT_EVOLVE_TASK function.

  4.

  Execute the evolve task by using the DBMS_SPM.EXECUTE_EVOLVE_TASK function.

  5.

  Report the task outcome by using the DBMS_SPM.REPORT_EVOLVE_TASK function.

  Identify the correct sequence of steps.

  A. 2, 4, 5

  B. 2, 1, 4, 3, 5

  C. 1, 2, 3, 4, 5

  D. 1, 2, 4, 5

  Correct Answer: B

  Reference: https://docs.oracle.com/database/121/TGSQL/tgsql_spm.htm#TGSQL94653