Create Next App

Exam contains 181 questions

Page 11 of 31

Question 61 🔥

A database is configured in ARCHIVELOG mode.A full RMAN backup exists but no control file backup to trace has been taken.A media failure has occurred.In which two scenarios is incomplete recovery required? (Choose two.)

Which database solution meets these requirements?

A. after losing a SYSAUX tablespace data file

Highly voted

B. after losing all members of an INACTIVE online redo log group

Highly voted

C. after losing all members of the CURRENT online redo log group

Highly voted

D. after losing all copies of the control file

Highly voted

E. after losing an UNDO tablespace that is in use

Highly voted

Discussion of the question

Question 62 🔥

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

Which database solution meets these requirements?

A. It is not possible if an archived log is missing.

Highly voted

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

Highly voted

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

Highly voted

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

Highly voted

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

Highly voted

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

Highly voted

Discussion of the question

Question 63 🔥

Which two are true about Oracle Optimizer Statistics, their use, and their collection? (Choose two.)

Which database solution meets these requirements?

A. The number of table rows is considered when evaluating the cost of accessing a table using an index.

Highly voted

B. Index balanced B*Tree height is considered when evaluating the cost of using an index.

Highly voted

C. The Statistics Advisor can help recommend the best way to gather statistics.

Highly voted

D. Statistics collected using DBMS_STATS always yield the best optimizer result.

Highly voted

E. The Statistics Advisor generates actions for all recommendations.

Highly voted

Discussion of the question

Question 64 🔥

A container database (CDB) contains two pluggable databases PDB1 and PDB2.The LOCAL_UNDO_ENABLED database property is set to FALSE in the CDB.Data file 24 of PDB2 was deleted and you need to restore and recover it.The only RMAN backup that exists was created with the BACKUP DATABASE command while connected to CDB$ROOT.Which three are true? (Choose three.)

Which database solution meets these requirements?

A. Data file 24 can be recovered only while connected to PDB2.

Highly voted

B. Data file 24 can be restored and recovered while connected to CDB$ROOT.

Highly voted

C. Data file 24 can be restored only while connected to CDB$ROOT.

Highly voted

D. Data file 24 can be restored only while connected to PDB2.

Highly voted

E. Data file 24 can be recovered while connected to PDB2.

Highly voted

F. Data file 24 can be recovered while connected to CDB$ROOT.

Highly voted

Discussion of the question

Question 65 🔥

Which two are true about data movement between a non-CDB and a PDB using Data Pump? (Choose two.)

Which database solution meets these requirements?

C. A new PDB is automatically created when importing a non-CDB into a CDB.

Highly voted

D. Oracle attempts to convert common users to conventional users when moving schemas from a PDB to a non-CDB.

Highly voted

E. Moving data from a PDB to a non-CDB is only possible by using transportable tablespace export and import.

Highly voted

F. Moving data from a non-CDB to a PDB is only possible by using conventional export and import.

Highly voted

A. Tablespaces are automatically created as needed while importing full exports in either a non-CDB or a PDB.

Highly voted

B. Oracle attempts to convert conventional database users to local users when moving schemas from a non-CDB to a PD

Highly voted

Discussion of the question

Question 66 🔥

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