Create Next App

Exam contains 181 questions

Page 1 of 31

Question 1 🔥

While backing up to an SBT channel, you determine that the read phase of your compressed Recovery Manager (RMAN) incremental level 0 backup is a bottleneck.FORCE LOGGING is enabled for the database.Which two could improve read performance? (Choose two.)

Which database solution meets these requirements?

A. Increase the size of tape I/O buffers.

Highly voted

B. Disable FORCE LOGGING for the database.

Highly voted

C. Increase the size of the database buffer cache.

Highly voted

D. Enable asynchronous disk I/O.

Highly voted

E. Increase the level of RMAN multiplexing.

Highly voted

Discussion of the question

Question 2 🔥

For which two requirements can you use the USER_TABLESPACE clause with the CREATE PLUGGABLE DATABASE command? (Choose two.)

Which database solution meets these requirements?

A. to specify a default tablespace in a PDB cloned from another PDB in the same CDB.

Highly voted

B. to exclude all tablespaces except SYSTEM, SYSAUX, and TEMP when plugging in a PDB

Highly voted

C. to include specific user tablespaces only when relocating a PDB

Highly voted

D. to specify the list of user tablespaces to include when moving a non-CDB to a PDB

Highly voted

E. to exclude a temp tablespace when plugging in a PDB

Highly voted

F. to specify the list of tablespaces to include when creating a PDB from the CDB seed

Highly voted

Discussion of the question

Question 3 🔥

Which three are true about requirements for various FLASHBACK operations? (Choose three.)

Which database solution meets these requirements?

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

Highly voted

B. FLASHBACK drop requires that the RECYCLEBIN parameter be set to ON.

Highly voted

C. FLASHBACK version query requires that the RECYCLEBIN parameter be set to ON.

Highly voted

D. FLASHBACK DATA ARCHIVE requires undo to store all versions of all rows of a table being tracked.

Highly voted

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

Highly voted

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

Highly voted

Discussion of the question

Question 4 🔥

Which three actions are performed by the Oracle Preinstallation RPM, oracle-database-server-xxxx-preinstall, for Oracle Grid Infrastructure, where xxxx is the Oracle version and release? (Choose three.)

Which database solution meets these requirements?

A. performing checks to ensure minimum configuration requirements for Oracle Grid Infrastructure are met

Highly voted

B. creating the oracle OS user

Highly voted

C. creating the OSDBA (dba) group

Highly voted

D. creating the oraInventory (oinstall) group

Highly voted

E. creating the grid OS user

Highly voted

F. configuring the OS for Oracle Automatic Storage Management shared storage access

Highly voted

Discussion of the question

Question 5 🔥

Which two are true about common objects? (Choose two.)

Which database solution meets these requirements?

A. They can be created only in CDB$ROOT.

Highly voted

B. They can be only metadata-linked in an application container.

Highly voted

C. They can exist in user-defined schemas only in application containers.

Highly voted

D. They can exist in CDB$ROOT and an application root.

Highly voted

E. They can be extended data-linked in CDB$ROOT.

Highly voted

F. They can be created only in an application root.

Highly voted

Discussion of the question

Question 6 🔥

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