Tag: databases

Quizzes (243) Questions (4862)

Questions Related to databases

Multiple choice technology databases

Your database contains at least one undo tablespace. You attempt to start an instance in Automatic Undo Management mode, but without specifying an undo tablespace in the initialization parameter file. What happens?

  1. The instance will not start.

  2. The instance starts up and uses the SYSTEM rollback segment for all undo entries.

  3. The instance starts up and uses the SYSTEM tablespace for the automatic undo segments.

  4. The instance starts up and uses the first available undo tablespace for the automatic undo segments.
Reveal answer Fill a bubble to check yourself
D Correct answer
Full explanation
Multiple choice technology databases

When WORKAREA_SIZE_POLICY is set to AUTO, the work areas are sized to accomplish which two goals? (Choose two)

  1. To tune memory using the existing *_AREA_SIZE parameters.

  2. To allocate memory to work areas in order to optimize throughput only.

  3. To allocate memory to work areas in order to optimize response time only.

  4. To allocate memory to work areas in order to optimize both throughput and response time.

  5. To ensure that the overall size of the PGA will never exceed the value of PGA_AGGREGATE_TARGET.
Reveal answer Fill a bubble to check yourself
D,E Correct answer
Full explanation
Multiple choice technology databases

In what way are the two initialization parameters PGA_AGGREGATE_TARGET and WORKAREA_SIZE_POLICY related to each other?

  1. The default value for PGA_AGGREGATE_TARGET depends on the setting of WORKAREA_SIZE_POLICY.

  2. You must provide a non-default value for PGA_AGGREGATE_TARGET before setting

  3. The value of PGA_AGGREGATE_TARGET can only be changed dynamically (that is, when the instance is

  4. You must not provide a non-default value for PGA_AGGREGATE_TARGET before setting
Reveal answer Fill a bubble to check yourself
B Correct answer
Full explanation
Multiple choice technology databases

Expand MOLAP

  1. Multiple Dimensions Online Analytical Processing

  2. Multiple Dimensions Online Analysis Processing

  3. Multidimensional Online Analysis Processing

  4. Multidimensional Online Analytical Processing
Reveal answer Fill a bubble to check yourself
D Correct answer
Full explanation