Tag: technology

A view can be created as read only.

A view can be created as a join on two or more tables

A view cannot have a n ORDER BY clause in the SELECT statement.

A view cannot be created with a GROUP BY clause in the SELECT statement.

TIMESTAMP

INTERVAL MONTH TO DAY

INTERVAL DAY TO SECOND

INTERVAL YEAR TO MONTH

TIMESTAMP WITH DATABASE TIMEZONE

USER_TAB_PRIVS_MADE

USER_TAB_PRIVS

USER_COL_PRIVS_MADE

USER_COL_PRIVS

Two controllers used to write data and faster than disk mirroring

Spread data between multiple drives

The process of reading and writing data on two drives simultaneously

Disk striping with parity

Using ab_project_setup.ksh

Using Run settings

Using EME Datastore Settings

None of the above

Using lookup() function

Using Generate Records component

Using re_index() function

Using next_in_sequence() function

For a group, output of rollup is a single record while that of scan is multiple records

Rollup gives the summary for a group while scan gives cumulative summary

None of (i) and (ii) are true

Both (i) and (ii) are true

File used for database connectivity

File used to define data format

File used to hold lookup data

File used to store Data Byte size

File containing intermediate data while processing

File containing static dataset which is keyed

File containing daily transaction data

Partitioned file which is non-keyed

Physical layer

encode/decode

routing, flow control

mapping interface