Oracle Oracle Certifications 1Z0-083 Questions & Answers

• Question 121:

  In your Database, the TBS PERCENT USED parameter is set to 60 and the TBS PERCENT FREE parameter is set to 20.

  Which two storage-tiering actions might be automated when using information Lifecycle Management (ILM) to automate data movement?

  A. The movement of all segments to a target tablespace with a higher degree of compression, on a different storage tier, when the source tablespace exceeds tbs percent used

  B. Setting the target tablespace to read-only after the segments are moved

  C. The movement of some segments to a target tablespace with a higher degree of compression, on a different storage tier, when the source tablespace exceeds T3S percent used

  D. Taking the target tablespace offline after the segments are moved

  E. The movement of some blocks to a target tablespace with a lower degree of compression, on a different storage tier, when the source tablespace exceeds tbs percent used

  Correct Answer: BC

• Question 122:

  You notice a performance change in your production Oracle 12c database. You want to know which change caused this performance difference. Which method or feature should you use?

  A. Compare Period ADDM report

  B. AWR Compare Period report

  C. Active Session History (ASH) report

  D. Taking a new snapshot and comparing it with a preserved snapshot.

  Correct Answer: A

  Comparing Current System Performance to a Baseline Period You may have noticed a performance change on a production system and would like to know why, or you may have implemented a change to a production system and want to know the effect of the change, such as increased concurrency waits.

  The Compare Period ADDM compares the performance of the database server in two time periods, and returns a report describing the performance changes and the root origin of the changes. https://docs.oracle.com/database/121/TDPPT/tdppt_degrade.htm#TDPPT525

• Question 123:

  The CATDB12c database contains an Oracle Database version 12c catalog schema owned by the RC12C user.

  The RCAT11 database contains an Oracle Database version 11g catalog schema owned by the RC11 user in which several databases are registered. Both the databases are open.

  You execute the RMAN commands:

  RMAN> CONNECT CATALOG rc12c/pass12c@catdb12c RMAN> IMPORT CATALOG rc11/pwdcat11@ract11

  Which two tasks are performed as part of the import? (Choose two.)

  A. Databases from the RC12C catalog are implicitly unregistered if the RC11 catalog has registered databases with same name.

  B. Recovery catalog is resynchronized with the control files of the registered databases.

  C. Imported databases are unregistered from the RC11 catalog.

  D. Local and global stored scripts that have the same name as existing scripts in the RC12C catalog are automatically renamed.

  E. All databases registered in the RC11 catalog are registered in the RC12C catalog.

  Correct Answer: CE

  By default, the imported database IDs are unregistered from the source recovery catalog schema after a successful import. It is possible for global scripts, but not local scripts, to have name conflicts during import because the destination schema contains an object with the same name. In this case, RMAN renames the global script name to COPY OF script_name. For example, RMAN renames bp_cmd to COPY OF bp_cmd

  https://docs.oracle.com/database/121/RCMRF/rcmsynta026.htm#RCMRF198

• Question 124:

  Examine the statements that use flashback technologies:

  1.

  FLASHBACK TABLE customers TO TIMESTAMP TO_TIMESTAMP (2013-02-04 09:30:00, YYYY-MM-DD HH:MI:SS);

  2.

  SELECT * FROM customers AS OF SCN 123456;

  3.

  FLASHBACK TABLE customers TO BEFORE DROP;

  4.

  FLASHBACK DATABASE TO TIMESTAMP TO_TIMESTAMP (2013-02-04 09:30:00, YYYY-MM-DD HH:MI:SS);

  5.

  SELECT * FROM customers VERSIONS BETWEEM SCN 123456 AND 123999;

  6.

  ALTER TABLE customer FLASHBACK ARCHIVE;

  Which set of statements depends on the availability of relevant undo data in the undo tablespace?

  A. 1,3,6

  B. 1,2,5

  C. 3,4,5

  D. 2,3,5,6

  Correct Answer: B

• Question 125:

  Which two are true about RMAN image copies? (Choose two) A. They can only be written to disk.

  B. They can be encrypted using Transparent Data Encryption (TDE).

  C. They can be used as a level 0 incremental backup.

  D. They can be used as a level 1 incremental backup.

  E. They are the only backup option available for databases in NOARCHIVELOG mode.

  Correct Answer: AC

• Question 126:

  Which three conditions must be met before you create a Virtual Private Catalog (VPC)?

  A. A base recovery catalog should exist.

  B. The owner of VPC cannot own recovery catalog.

  C. At least one target database should be registered in the recovery catalog.

  D. The register database privilege should be granted to the virtual catalog owner.

  E. The recovery_catalog_owner role should be granted to the virtual catalog owner.

  Correct Answer: ADE

• Question 127:

  You create a table with the PERIOD FOR clause to enable the use of the Temporal Validity feature of Oracle Database 12c.

  Examine the table definition:

  

  Which three statements are true concerning the use of the Valid Time Temporal feature for the EMPLOYEES table?

  A. The valid time columns employee_time_start and employee_time_end are automatically created.

  B. The same statement may filter on both transaction time and valid temp or altime by using the AS OF TIMESTAMP and PERIOD FOR clauses.

  C. The valid time columns are not populated by the Oracle Server automatically.

  D. The valid time columns are visible by default when the table is described.

  E. Setting the session valid time using DBMS_FLASHBACK_ARCHIVE.ENABLE_AT_VALID_TIME sets the visibility for data manipulation language (DML), data definition language (DDL), and queries performed by the session.

  Correct Answer: ABE

  A: To implement Temporal Validity(TV), 12c offers the option to have two date columns in that table which is having TV enabled using the new clause Period For in the Create Table for the newly created tables or in the Alter Table for the

  existing ones. The columns that are

  used can be defined while creating the table itself and will be used in the Period For clause or you can skip having them in the table's definition in the case of which, the Period For clause would be creating them internally.

  E: ENABLE_AT_VALID_TIME Procedure

  This procedure enables session level valid time flashback.

• Question 128:

  Which three are true about upgrading an application in an application container? (Choose three).

  A. An application root clone gets created automatically.

  B. The upgrade can be performed when connected either to CDB$ROOT or to PDB$SEED.

  C. After an application upgrade, the application container's PDBs remain synchronized with the existing application root.

  D. The upgrade must be performed when connected to CDB$ROOT.

  E. An application name and version number must be specified to upgrade the application.

  F. After an application upgrade, the application container's PDBs are automatically synchronized with the application root clone.

  Correct Answer: AEF

• Question 129:

  Which statement describes the significance of the CHANGE FAILURE command in RMAN? (Choose all that apply.)

  A. It is used to change failure priority only for HIGH or LOW priorities.

  B. It is used to execute the advised repair script.

  C. It is used to change failure priority only for the CRITICAL priority.

  D. It is used to explicitly close the open failures.

  E. It is used to inform the database about the repair after the repair script executes.

  Correct Answer: AD

• Question 130:

  Examine the RMAN commands:

  RMAN> CONNECT TARGET "sbu@prod AS SYSBACKUP";

  RMAN>CONNECT AUXILIARY "sbu@dup_db AS SYSBACKUP";

  RMAN >DUPLICATE TARGET DATABASE TO dup_db

  FROM ACTIVE DATABASE

  PASSWORD FILE

  SECTION SIZE 400M;

  Which statement is true about the DUPLICATE command?

  A. It succeeds and creates multisection backup sets that are used for active database duplication.

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

  C. It succeeds only if the target database is in MOUNT state.

  D. It fails because there is no connection to a recovery catalogue.

  Correct Answer: A