Create Next App

Exam contains 181 questions

Page 12 of 31

Question 67 🔥

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

Which database solution meets these requirements?

A. Recovery begins from the beginning of the CURRENT redo log group.

Highly voted

B. Recovery begins from the last checkpoint position that was calculated by the Database Writer before instance failure.

Highly voted

C. Recovery begins from the start of any ACTIVE redo log group or the start of the CURRENT log group if no other group is ACTIVE.

Highly voted

D. Recovery reads redo until the end of the redo thread. SMON rolls back any dead transactions, and then the database is opened.

Highly voted

E. Recovery begins from the last checkpoint position that was recorded in the control file by the checkpoint process (CKPT).

Highly voted

F. Recovery reads redo until the end of the redo thread, and then opens the database. SMON then rolls back any dead transactions.

Highly voted

Discussion of the question

Question 68 🔥

Examine this configuration:1. The ORCL database data files are in Automatic Storage Management (Oracle ASM) disk group +DATA.2. ORCL uses disk group +FRA for 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?

Which database solution meets these requirements?

A. The ORCL database, the Oracle ASM instances, the +DATA and +FRA disk groups, and the LISTENER are started.

Highly voted

B. Only the ORCL database instance is started.

Highly voted

C. Only the ORCL database and the ASM instances are started.

Highly voted

D. Only the ORCL database instance, the Oracle ASM instance, and the +DATA and +FRA disk groups are started.

Highly voted

E. Only the ORCL database instance and the +DATA and +FRA disk groups are started.

Highly voted

Discussion of the question

Question 69 🔥

Which four are true about a Recovery Manager (RMAN) duplication without a TARGET connection? (Choose four.)

Which database solution meets these requirements?

A. The NOREDO clause must be used if the backups of the database being duplicated were taken when the database was in NOARCHIVELOG mode.

Highly voted

B. The UNDO TABLESPACE clause is always required when no connection exists to the TARGET instance.

Highly voted

C. RMAN ג€pushesג€ the backups of the database to be duplicated over the network to the auxiliary instance.

Highly voted

D. The NOREDO clause can be used if the backups of the database being duplicated were taken when the database was in ARCHIVELOG mode.

Highly voted

E. RMAN SBT-based backups of the database to be duplicated can be used by the auxiliary instance.

Highly voted

F. The UNDO TABLESPACE clause is always required when no connection exists to the recovery catalog and the TARGET database is closed.

Highly voted

G. The UNDO TABLESPACE clause is always required when no connection exists to the recovery catalog and the TARGET database is opened.

Highly voted

H. RMAN disk-based backups of the database to be duplicated can be used by the auxiliary instance.

Highly voted

Discussion of the question

Question 70 🔥

Which three are true? (Choose three.)

Which database solution meets these requirements?

A. Virtual Private Database (VPD) policies on objects in an application root are automatically synchronized with all application PDBs contained in the application container.

Highly voted

B. Application-common TSDP policies are always container specific.

Highly voted

C. Application-common Transparent Security Data Protection (TSDP) policies can be created only within an application install/patch BEGIN-END block.

Highly voted

D. Application-common Oracle Label Security (OLS) policies cannot be created in an application root outside an install/patch BEGIN-END block.

Highly voted

E. Fine-grained auditing (FGA) policies in an application root are automatically synchronized to all application PDBs contained in the application container.

Highly voted

F. Application-common OLS policies can be created in an application root inside an install/patch BEGIN-END block.

Highly voted

G. Unified auditing can be automatically synchronized to all application PDBs in an application container.

Highly voted

Discussion of the question

Question 71 🔥

Which three are true about Automatic Workload Repository (AWR)? (Choose three.)

Which database solution meets these requirements?

B. Its collection level is determined by the value of the STATISTICS_LEVEL database parameter.

Highly voted

C. By default, AWR snapshots are retained for 7 days.

Highly voted

D. The taking of AWR snapshots can be disabled.

Highly voted

E. AWR data is stored in the SYSTEM tablespace.

Highly voted

A. By default, AWR snapshots are taken every 60 minutes.

Highly voted

Discussion of the question

Question 72 🔥

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