Jun-2022 Free 1Z1-083 Test Questions Real Practice Test Questions [Q159-Q173] – IT Certification Exam Questions & Answers

Rate this post

Jun-2022 Free 1Z1-083 Test Questions Real Practice Test Questions

1Z1-083 Dumps Updated Jun 20, 2022 WIith 279 Questions

Q159. You notice that the performance of your production 24×7 Oracle 12c database has significantly degraded. Sometimes, you are not able to connect to the database instance because it hangs. How can you detect the cause of the degraded performance?

by performing emergency monitoring using Real-Time Automatic Database Diagnostic Monitor (ADDM) to fetch data directly from SGA for analysis

by running ADDM to fetch information from the latest Automatic Workload Repository (AWR) snapshots

by using Active Session History (ASH) data and performing hang analysis

by running ADDM in diagnostic mode

Q160. Choose three. Which three are true about using Database Upgrade Assistant (DBUA) to upgrade a database?

DBUA must be launched from the target Oracle Home.

Multiple databases with the same ORACLE_HOME can be upgraded simultaneously.

A whole database backup must exist before upgrade.

The Pre-Upgrade Information Tool script is executed by DBUA.

All pluggable databases are automatically upgraded as part of a container database upgrade.

The database must be opened in read-only mode.

Q161. Examine this configuration:
1. The ORCLdatabase data files are in Automatic Storage Management (Oracle ASM) disk group +DATA.
2. ORCLuses disk group +FRAfor 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 +DATAand +FRAdisk groups, and the LISTENER are started.

Only the ORCL database instance is started.

Only the ORCLdatabase and the ASM instances are started.

Only the ORCLdatabase instance, the Oracle ASM instance, and the +DATAand +FRAdisk groups are started.

Only the ORCLdatabase instance and the +DATAand +FRAdisk groups are started.

Q162. choose two Examine the command to duplicate a database: RMAN> DUPLICATE TARGET DATABASE TCddb PLUGGABLE DATABASE pdbl,pdb5; Which two statements are true about the DUPLICATE command?

The root and the seed database in the container database (CDB) are also duplicated.

A backup of PDB1 and PDB5 must exist before executing the command.

The SPFILE is copied along with the data files of the pluggable databases (PDBs).

An auxiliary instance must be started with the initialization parameter ENABLE_PLUGGABLE_DATABASE set to TRUE. E) The DUPLICATE command first creates a backup, and then duplicates the

Q163. 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

Q164. 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 Memory Advisor for the System Global Area.

Run the SQL Tuning Advisor.

Run the SQL Access Advisor.

Run the Memory Advisor for the shared pool.

Run the Memory Advisor for the Program Global Area.

Q165. Which two statements are true about Resource Manager plans for individual pluggable databases (PDB plans) in a multitenant container database (CDB)?

If no PDB plan is enabled for a pluggable database, then all sessions for that PDB are treated to an equal degree of the resource share of that PDB.

In a PDB plan, subplans may be used with up to eight consumer groups.

If a PDB plan is enabled for a pluggable database, then resources are allocated to consumer groups across all PDBs in the CDB.

If no PDB plan is enabled for a pluggable database, then the PDB share in the CDB plan is dynamically calculated.

If a PDB plan is enabled for a pluggable database, then resources are allocated to consumer groups based on the shares provided to the PDB in the CDB plan and the shares provided to the consumer groups in the PDB plan.

Q166. Which three are true about upgrading Oracle Grid Infrastructure? (Choose three.)

A direct upgrade can be performed only from the immediately preceding Oracle Grid Infrastructure version.

The newer version is installed in a separate Oracle Grid Infrastructure home on the same server as the existing version.

An existing Oracle base can be used.

The upgrade process will automatically install all mandatory patches for the current version of Oracle Grid Infrastructure.

Existing Oracle Database instances must be shut down before starting the upgrade.

Only the grid user can perform the upgrade.

Q167. choose three You want to duplicate one of your databases when connected to the target database and to the recovery catalog. Which three are true about this type of database duplication ) The duplication process can create backup sets or image copies

The target database must be open

The duplication process can use existing backup sets or image copies

The duplication process can use existing backup sets or image copies.

The target database must be in mount state.

The duplication -process pushes backup sets to the auxiliary instance.

The duplication process pushes image copies to the auxiliary instance.

Q168. Examine these queries and their output:

After a system crash, an instance restart and an attempted opening of the PDBs result in:

Which two are true? (Choose two.)

Data file 24 can be recovered while PDB2 is opened.

Data file 24 must be recovered while the CDB is opened.

Data file 24 can be recovered while CDB$ROOT and PDB$SEED are opened.

Data file 24 cannot be recovered while the CDB is opened.

Data file 24 must be recovered while PDB2 is closed.

Q169. Which three are true about an application seed pluggable database (PDB)? (Choose three.)

It is automatically synchronized with its application root PDB when an application is upgraded. B)It cannot be added to an application container after the application container has already been created.

A new application PDB created by cloning an application seed PDB can have an old version of the application installed after cloning completes.

It is automatically synchronized with its application root PDB when an application is installed.

It cannot be dropped from its application container.

A new application PDB created by cloning an application seed PDB can have an up-to-date version of the application installed after cloning completes.

It is not required in an application container.

Q170. Which two are true about SQL Performance Analyzer (SPA)? (Choose two.)

It is integrated with the SQL Access Advisor.

It predicts the impact of system changes on SQL workload response time.

It provides before and after execution statistics for each SQL statement in the analysis task

It offers fine-grained analysis of all the SQL statements in the analysis task as a group.

SQL statements that were originally run concurrently are run concurrently by SPA.

Q171. 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?

It fails because Data Pump cannot be container.

It creates a full export of the root

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.

Q172. The USERS tablespace consists of data files 3 and 4 and must always be online in read/write mode.
Which two are true about using RMAN to perform an open database back up of this tablespace? (Choose two.)

Backups must be done incrementally.

Backups must be contained in backup sets.

Backups can be taken only if the database is in ARCHIVELOG mode.

Backups can be done incrementally.

The database must be registered in an RMAN catalog.

Only consistent backups can be created.

Q173. You issued this command:
RMAN> BACKUP RECOVERY FILES;
Which two are true? (Choose two.)

All Oracle recovery files not in the current FRA that have not been backed up already, are backed up.

All non-Oracle files in the current FRA that have not been backed up already, are backed up.

All Oracle recovery files in the current FRA that have not been backed up already, are backed up.

All Oracle recovery files in the current fast recovery area (FRA) are backed up.

These backups can be written to disk or SBT.