Create Next App

Exam contains 181 questions

Page 2 of 31

Question 7 🔥

Which two are true about server-generated alerts? (Choose two.)

Which database solution meets these requirements?

A. Stateful alerts must be created by a DBA after resolving the problem.

Highly voted

B. Stateless alerts can be purged manually from the alert history.

Highly voted

C. Stateless alerts can be cleared manually.

Highly voted

D. Stateless alerts are automatically cleared.

Highly voted

E. Stateful alerts are purged automatically from the alert history.

Highly voted

Discussion of the question

Question 8 🔥

Which three are located by using environment variables? (Choose three.)

Which database solution meets these requirements?

A. the Optimal Flexible Architecture (OFA) compliant path to store Oracle software and configuration files.

Highly voted

B. the location of Oracle Net Services configuration files

Highly voted

C. the list of a disk group names to be mounted by an Oracle Automatic Storage Management (ASM) instance at startup

Highly voted

D. default directories for temporary files used by temporary tablespaces

Highly voted

E. the temporary disk space used by Oracle Installer during installation

Highly voted

F. the maximum number of database files that can be opened by a database instance

Highly voted

Discussion of the question

Question 9 🔥

Which three are true about opatchauto? (Choose three.)

Which database solution meets these requirements?

A. It performs a shutdown and then a restart of all processes in both Oracle Grid Infrastructure and Oracle Database home during the patching process.

Highly voted

B. It must be invoked by a user with root user privileges.

Highly voted

C. Patches are applied via opatchauto.

Highly voted

D. Users must always input patch plans to opatchauto.

Highly voted

E. It requires the Oracle Grid Infrastructure and Oracle Database instances to be shut down before being invoked.

Highly voted

F. It applies patches in nonrolling mode by default.

Highly voted

G. It is used to apply interim patches to Oracle Grid Infrastructure and Oracle Database home combinations.

Highly voted

Discussion of the question

Question 10 🔥

Which two are true about the character sets used in an Oracle database? (Choose two.)

Which database solution meets these requirements?

A. Single-byte character sets provide better performance than multibyte character sets.

Highly voted

B. Unicode enables information from any language to be stored using a single character set.

Highly voted

C. Unicode is the only supported character set for Oracle databases created using Database Configuration Assistant (DBCA).

Highly voted

D. Single-byte character sets always use 7-bit encoding schemes.

Highly voted

E. Multibyte character sets allow more efficient space utilization than single byte character sets.

Highly voted

F. Single-byte character sets always use 8-bit encoding schemes.

Highly voted

Discussion of the question

Question 11 🔥

Which three are true about monitoring waits for sessions and services? (Choose three.)

Which database solution meets these requirements?

A. V$SESSION_EVENT displays all waits for all past and existing sessions if the wait has occurred at least once for a session.

Highly voted

B. V$SERVICE_EVENT displays all waits for all services if the wait has occurred at least once for a service.

Highly voted

C. V$SESSION_WAIT_CLASS displays waits broken down by wait class only for waiting sessions.

Highly voted

D. V$SESSION_WAIT and V$SESSION both contain details of the event on which a non-waiting session last waited.

Highly voted

E. V$SESSION_EVENT displays all waits for all past sessions if the wait has occurred at least once for a session.

Highly voted

F. V$SESSION_WAIT and V$SESSION both contain details of the event on which a session is currently waiting.

Highly voted

Discussion of the question

Question 12 🔥

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