Used to uniquely identify a row

Alias for primary key

Used to identify a column

Alias for foreign key

True

False

Dymanic

Real

Virtual

Static

Using COUNT

Using NUM

Using NUMBER

Both a and c above

True

False

SHOW DATABASES LIKE ‘%tech%’;

SHOW DATABASES LIKE ‘%tech;

SHOW DATABASES LIKE ‘'tech'%’;

SHOW DATABASES LIKE ‘tech%’;

True

False

To limit the output of a query

To limit the output of a query using an aggregate function only

When GROUP by is used

both b and c above

Table

Column

Database

All the above

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

10-JUL-00

12-JUL-00

11-JUL-00

14-JUL-00

17-JUL-00