Create Next App

Exam contains 181 questions

Page 6 of 31

Question 31 🔥

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

Which database solution meets these requirements?

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

Highly voted

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

Highly voted

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

Highly voted

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

Highly voted

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

Highly voted

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

Highly voted

Discussion of the question

Question 32 🔥

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

Which database solution meets these requirements?

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

Highly voted

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

Highly voted

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

Highly voted

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

Highly voted

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

Highly voted

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

Highly voted

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

Highly voted

Discussion of the question

Question 33 🔥

You are managing this configuration:1. CDB1 is a container database.2. PDB1 and PDB2 are two pluggable databases in CDB1.3. USER1.EMP is a table in PDB1 and USER2.DEPT is a table in PDB2.CDB1 user SYS executes these commands after connecting successfully to PDB2:Which two are true? (Choose two.)

Which database solution meets these requirements?

A. The inserts on USER1.EMP remain uncommitted when the session connected to PDB2.

Highly voted

B. The inserts on USER1.EMP were committed when the session inserted a row into USER2.DEPT.

Highly voted

C. The insert on USER2.DEPT fails because of the active transaction in the parent container.

Highly voted

D. The insert on USER2.DEPT is a recursive autonomous transaction by the child session and is committed.

Highly voted

E. The inserts on USER1.EMP were rolled back when the session connected to PDB2.

Highly voted

F. The insert on USER2.DEPT is uncommitted.

Highly voted

G. The inserts on USER1.EMP were committed when the session connected to PDB2.

Highly voted

Discussion of the question

Question 34 🔥

Examine this configuration:1. CDB1 is an Oracle Database 12c Release 2 database containing pluggable databases PDB$SEED, PDB1, and PDB2.2. PDB$SEED is open READ ONLY3. PDB1 is open READ WRITE4. PDB2 is MOUNTED.5. ORACLE_HOME is /u01/app/oracle/product/18.1.0/dbhome_1.You execute these commands before upgrading the database to the current release:For which databases will fixup scripts be created?

Which database solution meets these requirements?

A. CDB1, PDB$SEED, PDB1, and PDB2

Highly voted

B. PDB$SEED, PDB1, and PDB2 only

Highly voted

C. CDB1 and PDB$SEED only

Highly voted

D. CDB1, PDB1, and PDB2 only

Highly voted

E. CDB1, PDB$SEED, and PDB1 only

Highly voted

Discussion of the question

Question 35 🔥

Which two are true about Oracle Flashback features? (Choose two.)

Which database solution meets these requirements?

A. FLASHBACK QUERY can retrieve REDO records from ONLINE and ARCHIVED REDO LOG files.

Highly voted

B. FLASHBACK VERSION QUERY can retrieve REDO records from ONLINE and ARCHIVED REDO LOG files.

Highly voted

C. FLASHBACK TABLE can undrop a column.

Highly voted

D. FLASHBACK DROP can undrop an index when undropping a table.

Highly voted

E. After a database is restored from flashback logs using the FLASHBACK DATABASE command, it is sometimes rolled forward using redo logs.

Highly voted

Discussion of the question

Question 36 🔥

Which three are true about thresholds, metrics, and server-generated alerts? (Choose three.)

Which database solution meets these requirements?

A. All metrics are instance related.

Highly voted

B. Cleared stateful alerts are displayed by querying DBA_ALERT_HISTORY.

Highly voted

C. A space usage management alert is automatically cleared after the underlying problem is resolved.

Highly voted

D. They are generated by SMON when a tablespace is 97% full.

Highly voted

E. Metrics are statistical counts for a specific unit.

Highly voted

F. STATISTICS_LEVEL must be set to ALL to generate alerts.

Highly voted

Discussion of the question

Ready to Pass Your Certification Test

oracle 1Z0_083

Exam contains 181 questions

Lorem ipsum dolor sit amet consectetur. Eget sed turpis aenean sit aenean. Integer at nam ullamcorper a.

Company

Product

Resources

Follow us