Tag: databases

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.