Duplicates are eliminated automatically by the UNION ALL operator

The number of columns selected in each SELECT statement must be identical

The names of columns selected in each SELECT statement must be identical

The output is sorted by the UNION ALL operator

NULLS are not ignored during duplicate checking

The concatenation operator | | is always evaluated before addition and subtraction in an expression

NULLS influence the precedence of operators in an expression

The + binary operator has the highest precedence in an expression in a SQL statement

Arithmetic operators with equal precedence are evaluated from left to right within an expression

Multiple parentheses can be used to override the default precedence of operators in an expression

It succeeds and the generated undo is stored in SYSTEM.

It fails and returns the error message “ORA-30036: unable to extend segment by 8 in undo tablespace ‘UNDOTBS1’ “.

It succeeds and the least recently written undo block of UNDOTBS1 is overwritten by the generated undo.

It succeeds and the generated undo is stored in SYSAUX.

It succeeds and the least recently read undo block of UNDOTBS1 is overwritten by the generated undo

Configure a nonstandard block size for a new database

Register a new database with an available Enterprise Manager Management server

Change the standard block size of an existing database

Configure incremental backups for a new database

Enable flashback database for an existing database

It registers database services with all local and remote listeners known to the database instance

It frees resources held by abnormally terminated processes

It records checkpoint information in the control file

It frees unused temporary segments

It kills sessions that exceed idle time

writing inbound request to the common request queue from all shared server
connections

checking for outbound shared server responses on the common outbound response queue

receiving inbound requests from processes using shared server connections

sending each connection input request to the appropriate shared server input queue

broadcasting shared server session responses back to requesters on all connections

It is not possible to shrink either indexes or Index Organized Tables (IOTs)

It always eliminates all migrated rows if any exist in the table

To shrink a table it must have a PRIMARY KEY constraint

To shrink a table it must have a UNIQUE KEY constraint

To shrink a table it must have row movement enabled

Set OS_AUTHEN_PREFIX to OPS$

Have the OS administrator add KING to the OSDBA group

Grant DBA to KING

Unset REMOTE_LOGIN_PASSWORDFILE

Alter user KING to be IDENTIFIED EXTERNALLY