Oracle Oracle Certifications 1Z0-083 Questions & Answers

• Question 91:

  Which three are true about post-upgrade activities when upgrading an Oracle database using Database Upgrade Assistant? (Choose three).

  A. Any Recovery Manager (RMAN) recovery catalog must be upgraded manually.

  B. After a manual upgrade, TNSNAMES.ORA entries must be updated to reflect the new ORACLE_HOME.

  C. Time zone files must be upgraded manually using the DBMS_DST PL/SQL package.

  D. The new extended data type capability must be enabled by running the utlrp.sql script

  E. The Oracle Application Express configuration should be updated after upgrading Oracle Database.

  Correct Answer: ABE

• Question 92:

  Which two restrictions apply when the RMAN BACKUP AS COPY command is used to create a backup? (Choose two).

  A. Backups can be taken only if a fast recovery area is configured.

  B. Backups can be written only to disk.

  C. Backups can be taken only for data files.

  D. Binary compression cannot be applied to the backup.

  E. Backups can be written only if checksums are stored for each block.

  F. Backups can be written only to media.

  Correct Answer: BD

• Question 93:

  Which two statements are true about encrypted backups performed by using RMAN? (Choose two)

  A. Transparent encryption of backups uses an encryption wallet.

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

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

  D. Encrypted backups can only be written to disk.

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

  Correct Answer: AC

• Question 94:

  Which two are direct benefits of the multiprocess, multithreaded architecture of Oracle Database 12c when it is enabled?

  A. Reduced logical I/O

  B. Reduced virtual memory utilization

  C. Improved Serial Execution performance

  D. Reduced physical I/O

  E. Reduced CPU utilization

  Correct Answer: BE

• Question 95:

  Which two statements are true when row archival management is enabled?

  A. The ORA_ARCHIVE_STATE column visibility is controlled by the ROW ARCHIVAL VISIBILITY session parameter.

  B. The ORA_ARCHIVE_STATE column is updated manually or by a program that could reference activity tracking columns, to indicate that a row is no longer considered active.

  C. The ROW ARCHIVAL VISIBILITY session parameter defaults to active rows only.

  D. The ORA_ARCHIVE_STATE column is visible if referenced in the select list of a query.

  E. The ORA_ARCHIVE_STATE column is updated automatically by the Oracle Server based on activity tracking columns, to Indicate that a row is no longer considered active. Correct

  Correct Answer: CD

• Question 96:

  Which three statements are true about the key store storage framework for transparent data encryption?

  A. It facilitates and helps to enforce keystore backup requirements.

  B. It handles encrypted data without modifying applications.

  C. It enables a keystore to be stored only in a file on a file system.

  D. It enables separation of duties between the database administrator and the security administrator.

  E. It transparently decrypts data for the database users and applications that access this data.

  F. It helps to track encryption keys and implement requirements such as keystore password rotation and master encryption key reset or re-key operations.

  Correct Answer: ADF

  Reference: http://oradb-srv.wlv.ac.uk/E16655_01/network.121/e17729/asotrans.htm#CHDEABCA (benefits of the keystore storage framework)

• Question 97:

  RMAN is connected to the target database prod1 and an auxiliary instance in nomount state. Examine the command to create a duplicate database:

  RMAN> DUPLICATE TARGET DATABASE TO dup1

  FROM ACTIVE DATABASE

  NOFILENAMECHECK

  PASSWORD FILE

  SPFILE;

  Which two statements are true about the execution of the duplicate command?

  A. All archive redo log files are automatically copied to the duplicate database.

  B. The duplicate database has the same directory structure as the source database.

  C. The duplicate database is created by using the backups created during the execution of

  D. The duplicate command.

  E. The password file and SPFILE for the duplicate database dup1 are created in their respective default locations.

  F. The duplicate database is created without using RMAN backups and prod: is allowed to remain open during duplication.

  Correct Answer: BF

• Question 98:

  Which three are true about backing up the control file? (Choose three).

  A. It cannot be backed up manually as a binary copy.

  B. It gets backed up automatically by RMAN as a trace file containing SQL statements for control file recreation when a database backup occurs.

  C. It can be backed up manually as a binary copy.

  D. It can get backed up automatically as a binary copy.

  E. It gets backed up automatically by RMAN when the BACKUP SPFILE command is used.

  F. It can be backed up manually as a trace file containing SQL statements for control file recreation.

  Correct Answer: CDF

• Question 99:

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

  

  After changing the value, you notice that FULL redaction continues to redact numeric data with 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

  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. Note:

  *

  The DBMS_REDACT package provides an interface to Oracle Data Redaction, which enables you to mask (redact) data that is returned from queries issued by low-privileged users or an application.

  *

  UPDATE_FULL_REDACTION_VALUES Procedure

  This procedure modifies the default displayed values for a Data Redaction policy for full redaction.

  *

  After you create the Data Redaction policy, it is automatically enabled and ready to redact data.

  *

  Oracle Data Redaction enables you to mask (redact) data that is returned from queries issued by low-privileged users or applications. You can redact column data by using one of the following methods:

  / Full redaction.

  / Partial redaction.

  / Regular expressions.

  / Random redaction.

  / No redaction.

• Question 100:

  Which three are true about cloning databases into an existing CDB with RMAN? (Choose three).

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

  B. A user with SYSDBA or SYSBKUP must be logged in with RMAN to CDB$ROOT when cloning a PDB.

  C. Only one PDB can be cloned at a time.

  D. Two or more PDBs can be cloned with the same command.

  E. A user with SYSDBA or SYSBKUP must be logged in with RMAN to the non-CDB being cloned when cloning a non-CDB.

  F. The target and auxiliary instance passwords must be the same.

  Correct Answer: BCF