Tag: technology

Database

Host systems

Input/Output data

All of the above

Create and drop a materialized view

Grant and revoke the role to and from other users

Enable the role and exercise any privileges in the role's privilege domain

Select from a table

Load the appropriate add-in

Have all required applications running on the desktop

Set initial and end conditions as part of the test

None of the above

Bitmap

B-Tree

Partitioned

Reverse key

File -> Settings -> Run

Tools -> Options -> Run

Automation -> Results

Both b and C

Check “Save still image captures to results” and select the option “Always”

Check “Save still image captures to results” and select the option “For errors”

Check “Save still image captures to results” and select the option “On errors and warnings”

All the above

Bitmap

Btree

Unique

partitioned

True

False

The shared pool CANNOT be dynamically resized.

The shared pool contains only fixed structures

The shared pool consists of the library cache and buffer cache.

The shared pool stores the most recently executed SQL statements and the most recently

A transaction completes.

The instance is started.

The instance is shut down

The current online redo log group is filled