1. select banner from v$version;

1. select version from v$instance;

1. select version from v$version;

Both 1 and 2

Both 2 and 3

Too_many_rows

No_Data_Found

Divide_Error

Zero_Error

Cursor_Already_Open

Cursor_Not_Closed

Invalid_Cursor

None of the Above

USER

UID

CURVAL

All are valid

>0 for positive value

0 for positive value

0 for negative value

1 for positive value

open

fetch

parse

None

RAISE_ERROR

SQLERRM

RAISE_APPLICATION_ERROR

RAISE_SERVER_ERROR

It causes the cursor to close

It loads the current row values into variables

It causes the cursor to open

It creates the variables to load the values

a) A function must return a value.

b) A procedure must return a value.

c) A function executes a PL/SQL statement.

d) A function is invoked as part of an expression.

e) A procedure must have a return data type specify in its declaration.

IN OUT

IN

OUT

RETURN

a) In the package body.

b) In the data base triggers.

c) In the package specification.

d) In the procedures declare section using the exact name in each.

Statement and Row

Statement only

Row only

Oracle Forms trigger

a) This statement creates a stored procedure named get_sal.

b) This statement returns a raise amount based on an employee id.

c) This statement creates a stored function named get_sal with a status of invalid.

d) This statement creates a stored function named get_sal.

e) This statement fails.

a) The COMMIT and ROLLBACK commands are allowed in the packaged function.

b) You can not use packaged functions in a query statement.

c) The packaged function cannot execute an INSERT, UPDATE, or DELETE statement against the table that is being queried.

d) The packaged function can execute and INSERT, UPDATE, or DELETE statement against the table that is being queried if it is used in a subquery.

e) The packaged function can execute an INSERT, UPDATEM or DELETE statement against the table that is being queried if the pragma RESTRICT REFERENCE is used.

a) An exception cannot propagate across remote procedure calls.

b) An exception raised inside a declaration immediately propagates to the current block.

c) The use of the RAISE; statement in an exception handler reprises the current exception

d) An exception raised inside an exception handler immediately propagates to the enclosing block.

a) GET.

b) GET_LINE.

c) PUT_TEXT_LINE.

d) PUT_LINE.

Manmohan

Sonia Gnadhi

Mujibur Rahman

Obama

PMON

SMON

RECO

ARCn

CKPT

True

False

Check

Unique

Not Null

Primary Key

Foreign Key