multiply_months(x,y)

add_months(x,y)

devide_months(x,y)

upper(x)

last_day(x)

next_day(x)

first_day(x)

1 & 3

1 & 2

2 & 3

divert

convert

straight

revert

compose

decompose

translate

retranslate

colesce

coalesce

coalsce

coalese

multiply_months(x,y)

add_months(x,y)

devide_months(x,y)

upper(x)

SQL*Plus installed on the PC

Oracle Net on the PC

HTTP Server

iSQL*Plus Server

SELECT *

FROM emp

WHERE comm = NULL

There is no error in this statement.

&

#

@

$

True

False

X<>Y

X!=Y

X^=Y

X!=!Y

435600

0004356

00043560

4356

COMPATIBILITY

VERSION

System.field_status

System.current_field

I

II

III

IV

Table can have 100 column at MAX

Table can have 1000 column at MAX

Table can have 10,000 column at MAX

Table can have unlimited column

True

False

TRUNCATE

DELETE

DROP

REMOVE

B-tree index used for table having completely unique colum

REVERSE key index used for oracle parallel serve

BIT MAP index is used for low cardinality

None of these

Outer Join view (complex view) is not updateable

USER_View contain Status of view

USER_ViEw NOT contain Status of view

DML opration may NOT applied on view having Group by clasue

In compiled form

As source code

Both A & B

Not stored