Exception

Executable

Declarative

Anonymous

UNIQUE

NOT NULL

CHECK

PRIMARY KEY

17000.00

17000*****

**17000.00

An error statement

NNNNNNN

########

1000000

1000000.00

True

False

2017

1917

1900

2000

True

False

binary data up to 4 gigabytes

character data up to 4 gigabytes

a hexadecimal string representing the unique address of a row in its table

raw binary data of variable length up to 2 gigabytes

No Rows returned

10 rows of Emp table

Error

8 is displayed 10 times

True

False

True

False

TRUNC=To_Date('09-Jan-02,DD-MON-YY,'YEAR',"Date" from Dual;

Select TRUNC(To_Date('09-Jan-02,DD-MON-YY,YEAR')) "DATE" from Dual;

Date =TRUNC(To_DATE('09-Jan-02','DD-MON-YY'),'YEAR'),'YEAR)"DATE: from DUAL;

SELECT TRUNC(TO_DATE('12-Feb-99','DD-MON-YY'), 'YEAR') "Date " FROM DUAL;

Any outer join

A left outer join

A cross join

A right outer join

1

2

3

None of these

It returns employees who have 50% of the salary greater than $23,000:

It returns employees who have 50% commission rate or salary greater than $23,000:

It returns employees who have 50% of salary less than $23,000:

None of the above

Convert '10'to 10

Convert 10 to '10'

Convert 'TEN' to 10

Convert a date to a character expression

SELECT SUBSTR ('HelloWorld',1) FROM dual;

SELECT LOWER (SUBSTR ('HellowWorld', 2,1) FROM dual;

SELECT LOWER (SUBSTR('HellowWorld', 2,1) FROM dual;

SELECT LOWER (TRIM ('H' FROM 'Hello World')) FROM dual;

Immediately after the SELECT clause

Before the WHERE clause

After the ORDER BY clause

After the WHERE clause

=

OR

IN

AND

0

1

0.00

An error statement