Oracle 1Z0-083 Exam Dumps – PDF Questions and Testing Engine [Q158-Q174]

Rate this post

Oracle 1Z0-083 Exam Dumps – PDF Questions and Testing Engine

Latest 1Z0-083 Exam Dumps for Pass Guaranteed

NO.158 For which two requirements can you use the USER_TABLESPACE clause with the CREATE PLUGGABLE DATABASE command? (Choose two.)

to specify a default tablespace in a PDB cloned from another PDB in the same CDB

to exclude all tablespaces except SYSTEM, SYSAUX, and TEMP when plugging in a PDB

to include specific user tablespaces only when relocating a PDB

to specify the list of user tablespaces to include when moving a non-CDB to a PDB

to exclude a temp tablespace when plugging in a PDB

to specify the list of tablespaces to include when creating a PDB from the CDB seed

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

They are never considered obsolete by RMAN.

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

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

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.

The SPFILE is included in the archival backup.

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.

NO.160 Examine this configuration:
1.The ORCL database data files are in Automatic Storage Management (Oracle ASM) disk group +DATA.
2.ORCL uses disk group +FRA for the Fast Recovery Area.
3.LISTENER is the listener for ORCL.
4.The database, listener, ASM instance, and ASM disk groups are managed by Oracle Restart.
5.All components are currently shut down.
You execute this command:

What is the outcome?

The ORCL database, the Oracle ASM instances, the +DATA and +FRA disk groups, and the LISTENER are started.

Only the ORCL database instance is started.

Only the ORCL database and the ASM instances are started.

Only the ORCL database instance, the Oracle ASM instance, and the +DATA and +FRA disk groups are started.

Only the ORCL database instance and the +DATA and +FRA disk groups are started.

NO.161 A user complains about poor database performance. You want to verify if the user’s session has waited for certain types of I/O activity. Which view displays all waits waited on by a session at least once?

V$SESSION_EVENT

V$SESSTAT

V$SESSION_WAIT

V$SESSION_WAIT_CLASS

V$SESSION

NO.162 Which two are true about diagnosing Oracle Database failure situations using Data Recovery Advisor?
(Choose two.)

Using the Data Recovery Advisor LIST FAILUREcommand always requires that the database for which failures are to be listed is in MOUNTstate.

A failure can be closed only when it has been repaired.

Data Recovery Advisor can be used if a database is closed.

The Data Recovery Advisor CHANGE FAILUREcommand can be used only to change failure priorities.

Data Recovery Advisor can proactively check for failures.

NO.163 Which three are true about Rapid Home Provisioning of Oracle software? (Choose three.)

It can be used only on nodes with Oracle Grid Infrastructure installed.

It can be used to patch existing Oracle software installations.

It can be used to create templates of Oracle homes as gold images of only Oracle databases.

It can be used to deploy new homes without disrupting active databases.

It can be used to create a single-instance Oracle Database in an already-installed Oracle home.

It can be used to upgrade only single-instance databases running on Oracle Restart.

NO.164 Which two are true about RMAN duplexed backup sets? (Choose two.)

A duplexed backup set uses the same number of SBT channels as a non-duplexed backup set for the same number of files.

A non-duplexed backup set written to disk can be duplexed to disk by backing up the backup set that is already on disk.

A non-duplexed backup set written to SBT can be duplexed to tape by backing up the backup set that is already on tape.

A non-duplexed backup set written to disk can be duplexed to tape by backing up the backup set that is already on disk.

A non-duplexed backup set written to SBT can be duplexed to disk by backing up the backup set that is already on tape.

A duplexed backup set always uses twice as many SBT channels as a non-duplexed backup set for the same number of files.

NO.165 Examine this configuration:
1. CDB1 is a container database.
2. COMMON_USER_PREFIX is set to an empty string.
3. PDB1 is a pluggable database in CDB1.
4. APP1_ROOT is an application container in CDB1.
5. APP1_PDB1 is an application PDB in APP1_ROOT.
You execute these commands:
$ sqlplus sys/oracle@localhost:1521/cdb1 as sysdba
SQL> CREATE ROLE role1 CONTAINER=CURRENT;
What is true?

It will return an error because creation of a local role is not allowed in CDB$ROOT.

ROLE1 will be created only in CDB$ROOT and APP1_ROOT.

ROLE1 will be created in CDB$ROOT, PDB1, APP1_ROOT, and APP1_PDB1.

ROLE1 will be created only in CDB$ROOT.

It will return an error because common roles must start with C##.

NO.166 Which two are true about RMAN duplexed backup sets? (Choose two.)

A duplexed backup set uses the same number of SBT channels as a non-duplexed backup set for the same number of files.

A non-duplexed backup set written to disk can be duplexed to disk by backing up the backup set that is already on disk.

A non-duplexed backup set written to SBT can be duplexed to tape by backing up the backup set that is already on tape.

A non-duplexed backup set written to disk can be duplexed to tape by backing up the backup set that is already on disk.

A non-duplexed backup set written to SBT can be duplexed to disk by backing up the backup set that is already on tape.

A duplexed backup set always uses twice as many SBT channels as a non-duplexed backup set for the same number of files.

NO.167 Choose two. Which two are true about PDB archive files?

DBMS_PDB.CHECK_PLUG_COMPATIBILITY can be run against a PDB archive.

They contain a PDB manifest file and all the data files in uncompressed form for a PDB.

They contain all the data files only in uncompressed form for a PDB.

They must be created using the DBMS_PDB package.

They contain a PDB manifest file and all the data files in compressed form for a PDB.

They contain all the data files only in compressed form for a PDB.

NO.168 Automatic Shared Memory Management is disabled for one of your database instances.
Some SQL statements perform poorly due to excessive hard parse activity, thereby degrading performance.
What would be your next step?

Run the SQL Access Advisor.

Run the Memory Advisor for the shared pool.

Run the SQL Tunning Advisor.

Run the Memory Advisor for the Program Global Area.

Run the Memory Advisor for the System Global Area.

NO.169 Which three are true? (Choose three.)

Virtual Private Database (VPD) policies on objects in an application root are automatically synchronized with all application PDBs contained in the application container.

Application-common TSDP policies are always container specific.

Application-common Transparent Security Data Protection (TSDP) policies can be created only within an application install/patch BEGIN-END block.

Application-common Oracle Label Security (OLS) policies cannot be created in an application root outside an install/patch BEGIN-END block.

Fine-grained auditing (FGA) policies in an application root are automatically synchronized to all application PDBs contained in the application container.

Application-common OLS policies can be created in an application root inside an install/patch BEGIN-END block.

Unified auditing can be automatically synchronized to all application PDBs in an application container.

NO.170 Choose three. Which three resources are always shared among CDB$ROOT and pluggable databases (PDBs)?

the data dictionary in CDB$ROOT

the log writer process (LGWR)

SYSAUX tablespaces

temporary tablespaces

the Process Monitor Process (PMON)

undo tablespaces

NO.171 Which two are true about instance recovery? (Choose two.)

It is not possible if an archived log is missing.

It is performed automatically after the database is opened; however, blocks requiring recovery are not available until they are recovered.

Setting FAST_START_MTTR_TARGET to a lower value reduces instance recovery time by causing dirty buffers to be written to disk more frequently, thereby reducing the number of I/Os needed during instance recovery.

It is performed by the Recovery Writer (RVWR) background process.

Setting FAST_START_MTTR_TARGET to a higher value reduces instance recovery time by causing The log writer to write more frquently, thereby reducing the number of I/Os needed during instance recovery.

It is performed automatically while the database remains in MOUNT state. Then the database is opened.

NO.172 Which three are true about Recovery Manager (RMAN) in Oracle Database 19c and later releases? (Choose three.)

It is only possible for RMAN to connect to a pluggable database as a target if an RMAN Virtual Private Catalog is used.

It is always possible for RMAN to connect to a pluggable database as a target if any RMAN Catalog is used.

A Virtual Private Catalog used to register a container database must be created in a pluggable database.

A Virtual Private Catalog used to register a container database can be created in a pluggable database.

It is always possible for RMAN to connect to a pluggable database as a target.

A Virtual Private Catalog used to register a container database can be created in a non-container database.

NO.173 Choose the best answer. Your CDB has two regular PDBs as well as one application container with two application PDBs and an application seed. No changes have been made to the standard PDB $SEED. How many default temporary tablespaces can be assigned in the CDB?

seven

five

eight

three

six

NO.174 Which three are true about Automatic Workload Repository (AWR) snapshots?

They are generated if STATISTICS_LEVEL is set to TYPICAL.

They are always created manually.

They are always created automatically.

They are generated if STATISTICS_LEVEL is set to BASIC.

They are generated if STATISTICS_LEVEL is set to ALL.

They can be retained forever.