Create Next App

Exam contains 181 questions

Page 7 of 31

Question 37 🔥

Examine this configuration:1. CDB1 is a container database.2. PDB1 and PDB2 are pluggable databases in CDB1.3. PDB1 and PDB2 are OPEN in READ WRITE mode.You execute these commands successfully:Which two are true? (Choose two.)

Which database solution meets these requirements?

A. Uncommitted transactions in PDB1 have been rolled back.

Highly voted

B. PDB1 is closed.

Highly voted

C. Uncommitted transactions in CDB1 and PDB1 have been rolled back.

Highly voted

D. CDB1 is shut down.

Highly voted

E. CDB1 is in MOUNT state

Highly voted

Discussion of the question

Question 38 🔥

Which three are true about Automatic Workload Repository (AWR), Automatic Database Diagnostic Monitor (ADDM), and the Manageability Monitor (MMON) background process? (Choose three.)

Which database solution meets these requirements?

A. ADDM can recommend shrinking the buffer cache.

Highly voted

B. ADDM can recommend extending the buffer cache.

Highly voted

C. By default, MMON creates an AWR snapshot every 30 minutes.

Highly voted

D. ADDM performs its analysis only when a DBA requests it.

Highly voted

E. By default, AWR snapshots are automatically purged after eight days.

Highly voted

F. AWR snapshots must be deleted when no longer required by ADDM.

Highly voted

Discussion of the question

Question 39 🔥

Examine the command for creating pluggable database PDB2 in container database CDB2.Select three options, any one of which is required for it to execute successfully. (Choose three.)

Which database solution meets these requirements?

A. Add the FILE_NAME_CONVERT clause to the statement and set the PDB_FILE_NAME_CONVERT parameter.

Highly voted

B. Add only the CREATE_FILE_DEST clause to the statement.

Highly voted

C. Set only the PDB_FILE_NAME_CONVERT parameter.

Highly voted

D. Set the PDB_FILE_NAME_CONVERT parameter and enable OMF.

Highly voted

E. Enable only OMF.

Highly voted

F. Add the FILE_NAME_CONVERT clause to the statement and enable Oracle Managed Files (OMF)

Highly voted

Discussion of the question

Question 40 🔥

Which two are true about Recovery Manager (RMAN) diagnostic message output? (Choose two.)

Which database solution meets these requirements?

A. Media Management messages for SBT devices are always written to sbtio.log.

Highly voted

B. RMAN error stacks should be read from the bottom up as that is the order in which errors are generated.

Highly voted

C. RMAN error stacks should be read from the top down as that is the order in which errors are generated.

Highly voted

D. The RMAN LOG command line clause causes output issued during RMAN command compilation to be written to a log file and to standard output.

Highly voted

E. The RMAN LOG command line clause causes output issued during RMAN command compilation to be written to a log file only.

Highly voted

F. Media Management messages for SBT devices are written to an Oracle trace file.

Highly voted

Discussion of the question

Question 41 🔥

Which three are true about managing memory components in an Oracle database instance? (Choose three.)

Which database solution meets these requirements?

A. With Automatic Shared Memory Management, the database instance can increase the Large Pool size by reducing the Shared Pool size.

Highly voted

B. With Automatic Memory Management, the database instance can increase the System Global Area size by reducing the Program Global Area size.

Highly voted

C. Automatically tuned and resized System Global Area components will always revert to their initial sizes after an instance restart.

Highly voted

D. Automatic Memory Management must be used together with locking the System Global Area into physical memory.

Highly voted

E. With Automatic Shared Memory Management, the database instance can increase the Program Global Area size by reducing the System Global Area size.

Highly voted

F. On Line Transaction Processing systems often use less Program Global Area than Decision Support Systems.

Highly voted

Discussion of the question

Question 42 🔥

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