Give You Free Regular Updates on 1Z0-083 Exam Questions Jun 25, 2022 [Q157-Q171] – IT Certification Exam Questions & Answers

Rate this post

Give You Free Regular Updates on 1Z0-083 Exam Questions Jun 25, 2022

Achieve the 1Z0-083 Exam Best Results with Help from Oracle Certified Experts

Average Salary of Oracle Database Administration II Exam Number: 1Z0-083 Certified Professionals

The average salary is between $69k and $127k.

Oracle 1Z0-083 Exam Syllabus Topics:

Topic	Details
Topic 1	Compress and Encrypt RMAN Backups Explore the structure of PDBs Backup non database files
Topic 2	Perform Backup and Recover CDBs and PDBs Create a new PDB from the CDB seed Clone PDBs and Application containers
Topic 3	Plug and unplug operations with PDBs and application containers Manage Application PDBs – Oracle Database: Managing Multitenant Architecture Ed 1
Topic 4	Employ the best Oracle Database recovery technology for your failure situation Install, upgrade and Patch applications

Q157. Which two are true about flashback features in Oracle Database 19c and later releases? (Choose two.)

Flashback logs areautomatically purged when DB_FLASHBACK_RETENTION_TARGET is set lower than the time they have already been retained.

Flashback logs are monitored and proactively deleted when beyond the retention period defined in DB_FLASHBACK_RETENTION_TARGET only after there is space pressure.

Flashback logs are monitored and proactively deleted when beyond the retention period defined in DB_FLASHBACK_RETENTION_TARGET before there is space pressure.

Flashback logs are monitored for being older than the retentionperiod defined in DB_FLASHBACK_RETENTION_TARGET and can be deleted by an administrator written event trigger.

Flashback logs are automatically purged whenever the value of
DB_FLASHBACK_RETENTION_TARGET is changed.

Q158. Which two are true about monitoring waits for sessions and services?

v$session_wait and v$session both contain details of the event on which a waiting session is currently waiting.

v$session_wait_class displays waits broken down by wait class only for waiting sessions.

v$service_event displays wait counts for every wait event whether waited on or not, for each service.

v$session_wait and v$session both contain details of the event on which a non-waiting session last waited.

v$session_event displays all waits for all past and existing sessions if the wait has occurred at least once for a session.

Q159. Which two are true about the Oracle dataabse methodology? (Choose two.)

The Oracle Database time model should be used to find the database and instance areas most in need of tuning.

Tuning activities should stop once the user is satisfied with performance.

Tuning activities should stop once agreed service levels for performance have been met.

The database instance memory should always be tuned before tuning any file systems.

SQL statements should always be tuned before tuning any file systems.

The alert log should be used to find the database and instance areas most in need of tuning.

Q160. Choose two. Which two are true about an RPM-based Oracle Database installation?

It includes the Oracle Preinstallation RPM.

From Oracle Database 18c, a single RPM can be used to install only Oracle Database Server for a single instance.

It requires an Unbreakable Linux Network (ULN) subscription.

It performs a software-only Oracle Database installation.

It uses a service configuration script to create a single-instance database as part of the installation.

Q161. Which three are true about RMAN persistent configuration settings, administration, and their effects? (Choose three.)

A target database’s persistent RMAN configuration settings are always stored in the target’s control file

Backup older than the recovery window retention policy are always deleted automatically if the backup location has insufficient space.

Backups written to the fast recovery area (FRA) that are oboslete based on the redundancy retention policy can be deleted automatically to free space.

The RMAN SHOW ALL command displays only settings with nondefault values.

A target database’s persistent RMAN configuration settings are always synchronized automatically with the RMAN catalog.

The V$RMAN_CONFIGURATION view displays only settings with valuesthat have been modified. G)A DBA must specify either a redundancy retention policy or a recovery window retention policy.

Q162. You must transport the UNIVERSITYtablespace from one database to another.
The UNIVERSITYtablespace is currently open read/write.
The source and destination platforms have different endian formats.
Examine this list of actions:
1. Make the UNIVERSITY tablespace read-only on the source system.
2. Export the UNIVERSITYtablespace metadata using EXPDP.
3. Convert the UNIVERSITYtablespace data fies to the destination platform format using RMANon the source system.
4. Copy the UNIVERSITYtablespace data files to the destination system.
5. Copy the Data Pump dump set to the destination system.
6. Convert the UNIVERSITYtablespace data files to the destination platform format using RMAN on the destination system.
7. Import the UNIVERSITYtablespace metadata using IMPDP.
8. Make the UNIVERSITY tablespace read/write on the destination system.
Which is the minimum number of actions required, in the correct order, to transport the UNIVERSITY tablespace?

1, 2, 4, 5, 7, 8

1, 2, 4, 6, 7, 8

1, 2, 3, 4, 5, 7, 8

1, 2, 3, 4, 5, 6, 7, 8

2, 4, 5, 6, 7

Q163. Which three are true about requirements for various flashback operations?

flashback version query requires undo to retrieve all versions of a row that existed between two points in time.

flashback drop requires that the recyclebin parameter be set to on.

flashback data archive requires undo to store all versions of all rows of a table being tracked.

flashback transaction query requires undo to retrieve all versions of a row that existed between two points in time.

flashback drop requires undo to retrieve all versions of a row that existed between two points in time.

flashback version query requires that the recyclebin parameter be set to on.

Q164. Choose three. Which three are true about configuring CONTROLFILE AUTOBACKUP by using RMAN?

The control file is backed up whenever a new tablespace is created.

The server parameter file (SPFILE) is automatically backed up each time the control file is backed up.

The control file is backed up whenever a new table is created.

The control file is backed up whenever an RMAN backup is successfully recorded in the catalog.

It requires the use of fast recovery area (FRA).

The control file is backed up automatically each time the SPFILE is backed up manually.

Q165. Choose two. Which two are true about a read-only Oracle home?

It is enabled by performing a software-only Oracle Database installation and then running the roohctl -enable script.

It requires the Rapid Home Provisioning service.

Its configuration data and log files reside in subdirectories under the Oracle home.

It is enabled by performing an Oracle Database installation with database creation and then running the roohctl -enable script.

It contains an image that can be distributed across multiple servers.

Q166. choose three Which three are true about Transparent Data Encryption (TDE)?

It uses a single master key for a database.

It replaces secure application roles.

It encrypts only data on the client.

It stores the current and all past master keys in the keystore.

Master encryption keys are managed by Oracle Database Vault.

It can encrypt data at the column level.

Q167. While backing up to the Oracle Fast Recovery Area (FRA), you determined the backup is taking too long and suspect a performance bottleneck.
Which three are true about diagnosing and tuning these problems? (Choose three.)

If an RMAN BACKUP VALIDATE command takes roughly the same time as an actual backup, then both read and write I/O are likely bottlenecks.

Setting DBWR_IO_SLAVES to a non zero value can improve backup performance when using synchronous I/O.

If an RMAN BACKUP VALIDATE command takes noticeably less than an actual backup, then write I/O is a likely bottleneck.

If an RMAN BACKUP VALIDATE command takes roughly the same time as an actual backup, then read I/O is a likely bottleneck.

Data files with a high value in V$BACKUP_SYNC_IO.DISCRETE_BYTES_PER_SECOND are a potential performance bottleneck when synchronous I/O is used.

Setting DBWR_IO_SLAVESto a non zero value can improve backup performance when using asynchronous I/O/

Data files with a high value in V$BACKUP_ASYNC_IO.SHORT_WAITS are a potential performance bottleneck when asynchronous I/O is used.

Q168. Which three are true about Optimizer Statistics Advisor? (Choose three.)

It can be run only manually.

It is part of the DBMS_ADVISOR package.

It can recommend changes to improve the statistics gathering process.

It always analyzes all schemas in the database.

It runs automatically every night by default.

It is part of the DBMS_STATS package.

https://mikedietrichde.com/2017/08/22/oracle-optimizer-statistics-advisor-in-oracle-database-12-2-0-1/
https://www.oracle.com/technetwork/database/bi-datawarehousing/twp-bp-for-stats-gather-19c-5324205.pdf Reference:
https://oracle-base.com/articles/12c/optimizer-statistics-advisor-12cr2

Q169. Which two are true about gathering optimizer statistics?

Executing dbms_stats.gather_database_stats while connected to a PDBopened in read/write mode gathers object statistics for that PDB.

System statistics can be gathered only while connected to cdb$root.

Executing dbms_stats.gather_database_stats while connected to cdb$root gathers object statistics in all open pluggable databases (PDBs).

Executing dbms_stats.gather_database_stats while connected to cdb$root gathers object statistics only in cdbSroot.

Executing dbms_stats.gather_database_stats while connected to cdb$root gathers object statistics in all open PDBs except pdb$seed.

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

Database Replay

Automatic Database Diagnostic Monitor (ADDM) Compare Period report

Active Session History (ASH) report

SQL Performance Analyzer

Q171. Choose three. Which three capabilities require the use of the RMAN recovery catalog?

using RMAN stored scripts

creating encrypted backups

creating customized reports about a single database’s backups

using the REPORT SCHEMA command to list a database’s data files and tablespaces at times in the past

using the KEEP FOREVER clause with the BACKUP command

using the REPORT SCHEMA command to list a database’s current data files and tablespaces

Loading …