Tag: databases

True

False

A flat file called "plan_table.txt"

Oracle Table called "plan_table"

Oracle Table called "plan table"

A flat file called "plan_table.tbl"

It's advisable to choose the driving table with maximum number of records

Number of records is NOT the criteria while selecting driving table

It's advisable to choose the driving table with less number of records

Driving table is always the last table accessed by the Optimizer

Optimizer will return parse error if expressions are used on columns in the predicate

Optimizer does not use index if expressions are used on the columns in the predicate, even if one exists

It makes no difference with / without expressions on the columns in the predicate

Using expressions on the columns in the predicate won't get benefits of using Table Alias

1,A

A

Error

1

Null

7.5

5

10

Error

Last record

First record

Can't be decided.

10th row

1st row

no rows returned

First 10 rows

System tablespace

Default tablespace for the user

Users tablespace

Oracle will give an error

TO_CHAR

LOWER

MAX

CEIL

LPAD