Oracle Certification Exam Question: Download Oracle Certification PDF

Explain What is the use of PARALLEL_ADAPTIVE_MULTI_USER initialization parameter?

Answer:

When we set to PARALLEL_ADAPTIVE_MULTI_USER true enables an adaptive algorithm designed to improve performance in multiuser environments that use parallel execution. The algorithm automatically reduces the request degree of parallelism based on the degree at the system load at query startup time.

Download Oracle Certification PDF Read All 25 Oracle Certification Questions

Previous Question

Next Question

How to use STANDBY_ARCHIVE_DEST parameter and explain its need?

Explain Which three statements are true regarding the data types in Oracle Database 10g/11g? (Choose
two.)
A. Only One LONG column can be used per table
B. A TIMESTAMP data type column stores only time values with fractional seconds
C. The BLOB data type column is used to store binary data in an operating system file
D. The minimum column width that can be specified for a VARCHAR2 data type column is one
E. The value for a CHAR data type column is blanked-padded to the maximum defined column
width