Free Oracle 1Z0-083 Exam Questions

Become Oracle Certified with updated 1Z0-083 exam questions and correct answers

Page: 1 / 57

Total 285 Questions | Updated On: Apr 09, 2021

Add To Cart

Question 1

Choose three. Which three are true about RMAN archival backups with the RESTORE POINT clause?

A :

They are never considered obsolete by RMAN.

B :

They can optionally be written to a fast recovery area (FRA).

C :

Â All archive logs are retained after an archival backup is taken, until the next archival backup is taken of the same database.

D :

Archive logs are retained if they are necessary to allow the database to be recovered to a consistent state when an archival backup is restored.

E :

The SPFILE is included in the archival backup.

F :

Use of a recovery catalog is always required to support the creation and use of archival backups. G)The ARCHIVAL attribute for a backup overrides the RMAN retention policy.

G :

Answer: A,B,D

Question 2

Choose the best answer. Examine this output of an export from the current release of an Oracle multitenant database: $ sqlplus system/oracle . SQL> col name for a10 SQL> select name, open_mode from v$pdbs; NAME OPEN_MODE ---------------------------------------PDB$SEED READ ONLY PDB1 READ WRITE PDB2 MOUNTED SQL> exit Next you execute: $ expdp system/oracle full=y What is the outcome?

A : It fails because Data Pump cannot be container.

B : It creates a full export of the root

C : It creates a full export of only the used while connected to the root container and PDB1. container and all PDBs. container and all open PDBs. root container.

Answer: A

Question 3

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

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.

Answer: A,B,E

Question 4

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

A : The ORA_ARCHIVE_STATE column may only be queried by users with the DBA role set.

B : The ORA_ARCHIVE_STATE column is only displayed if it is referenced in the column select list of a query

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

D : The ORA_ARCHIVE_STATE column may only be updated by users with the DBA role set.

E : The ORA_ARCHIVE_STATE column is updated in an overnight maintenance job based on activity tracking.

Answer: B,C

Question 5

Choose two. Which two are true about memory advisors?

A : If Automatic Memory Management is enabled, no memory advisors are available.

B : If Automatic Memory Management is enabled, the Shared Pool Advisor and Buffer Cache Advisor are available to set the maximum size for these individual System Global Area components.

C : All memory advisors use data from Automatic Workload Repository

D : If Automatic Shared Memory Management is enabled, both the SGA Advisor and PGA Advisor are always available.

E : If Manual Shared Memory Management is enabled, only the Shared Pool Advisor and Buffer Cache Advisor are available.

Answer: C,D

Page: 1 / 57

Total 285 Questions | Updated On: Apr 09, 2021

Add To Cart