Teradata

DATAllegro

Netezza

Greenplum

Petadata

Exadata

Megadb

OracleMPP

Teradata

Netezza

DATAllegro

Sybase IQ

30-MAR-00

31-MAR-00

15-MAR-00

THERE IS NO FUNCTION LIKE LAST_DAY

ganesh

gANESH

Ganesh

THERE IS NO FUNCTION LIKE initsmall();

GADDE

Gadde

gADDE

THERE IS NO FUNCTION LIKE initcap();

GADDE

Gadde

gADDE

THERE IS NO FUNCTION LIKE initcap();

Error generates

Temporary table is created with name "employee" and it get removed at the end of transaction.

similar to normally creating table.

created in database permenantly

USER_COMMENTS

USER_ALL_COMMENTS

USER_TAB_ALL

USER_TAB_COMMENTS

When trying to enter NULL value for P_Id then 100 will be placed there.

P_Id value starts from 1 and then it is auto incremented by value 1 upto 100.

Generates error as there is no constraint like "AUTO_GENERATE".

P_Id value starts from 100 and then it is auto incremented by value 1.

Returns current system date and time.

Returns only current time

Returns only current date.

There is no function like now();

1601.916

2000

1598

1598.916

NULLORNULL

GEGE

OR

2

SQL%ROWCOUNT, SQL%ISFOUND,SQL%NOTFOUND,SQL%ISOPEN

SQL%ROWCOUNT, SQL%FOUND,SQL%NOTFOUND,SQL%OPEN

SQL%ROWCOUNT, SQL%FOUND,SQL%NOTFOUND,SQL%ISOPEN

All of the above

2

3

4

None of the above

DROP gen_email_name;

REMOVE gen_email_name;

DELETE gen_email_name;

DROP FUNCTION gen_eamil_name;

Yes

No

1 & 2

None of the above

A stored procedure uses the DELCLARE keyword in the procedure specification to declare formal parameters

A stored procedure is named PL/SQL block with at least one parameter declaration in the procedure specification.

A stored procedure must have at least one executable statement in the procedure body.

A stored procedure uses the DECLARE keyword in the procedure body to declare formal parameters.

14

10

12

None of the above

Row level DML trigger

Row level system trigger

Statement level DML trigger

Row level application trigger