3

4

1

None

Column

1966_Invoices

#Invoices

Catch_#22

Default tablespace for the user

Oracle will give an error

System tablespace

Users tablespace

cursor CAPITALS is

select CITY, STATE

into my_city, my_state

from CITIES where CAPITAL = 'Y';

When the datatypes of SELECT clause and INTO clause do not match

When a SELECT statement returns more than one row

When a SELECT statement returns no rows

When INTO statement is missing in the SELECT statement

True

False

NULL

Undefined

Header

Declarative

Executable

Exception

10-JUL-00

17-JUL-00

12-JUL-00

11-JUL-00

No. of rows returned by SQL statement are HIGH

No. of rows returned by SQL statement are FEW

No. of rows returned by SQL statement are > 10000

No. of rows returned by SQL statement are > 50000

Avoid full table scan

Avoid index scan

Avoid network traffic

Avoid cartesian join

Columns that contains values with less variation in the number of duplicates

Columns that contains values with large variation in the number of duplicates

Columns that contains values with no variation in the number of duplicates

Columns that contains values with ZERO variation in the number of duplicates

Exp

Imp

Explain Plan

vi Editor

The more heavily indented an access path is, the earlier it is executed

The more heavily indented an access path is, the later it is executed

If two steps are indented at the same level, the uppermost statement is executed first

If two steps are indented at the same level, the uppermost statement is executed last

Right to Left processing of Source (Tables, views etc.) by Parser

Left to Right processing of Source (Tables, views etc.) by Parser

Bottom to Up processing of WHERE condition clauses

Up to Bottom processing of WHERE condition clauses

Using NULL / NOT NULL on indexed columns won’t use INDEX

Using NULL / NOT NULL on indexed columns gives ERROR

Using NULL / NOT NULL on indexed columns disables INDEX

Using NULL / NOT NULL on indexed columns makes the INDEX unusable

True

False

Automated Database Deployment Monitor

Automated Database Development Monitor

Automated Database Diagnostic Monitor

Automated Database Distributed Monitor

V$SQL

V$SQL_STAT

V$SQLSTATS

V$SQL_STATISTICS

Equi Join

Outer Join

Non-Equi Join

Cartesian Join

True

False