Somethoing about database

1. Which three statements about restrictions on package functions used in SQL are true? (Choose three.)

	a.	A function called from a DML statement can read or modify the particular table being modified by the DML statement.
	b.	A function called from a DML statement cannot read or modify the particular table being modified by the DML statement.
	c.	A function called from a query statement or from a parallelized DML statement can execute a DML statement or modify the database.
	d.	A function called from a query statement or from a parallelized DML statement cannot execute a DML statement or modify the database.
	e.	A function called from a query or DML statement can end the current transaction, create or roll back a savepoint, or alter the system or session.
	f.	A function called from a query or DML statement cannot end the current transaction, create or roll back a savepoint, or alter the system or session.

2.Examine this package:

CREATE OR REPLACE PACKAGE prod_pack

IS

CURSOR c1 is

SELECT *

FROM product;

PROCEDURE order_product

(p1 IN NUMBER, p2 IN NUMBER);

END prod_pack;

CREATE OR REPLACE PACKAGE BODY prod_pack

IS

CURSOR c2 IS

SELECT *

FROM ord;

PROCEDURE order_product

(p1 IN NUMBER, p2 IN NUMBER)

IS

BEGIN

OPEN c2;

...

END;

END prod_pack;

You execute these commands in SQL*Plus:

EXECUTE OPEN prod_pack.c1;

EXECUTE prod_pack.order_product(100,1);

Which cursor or cursors will be opened for the duration of the session, unless it is explicitly closed?

	a.	C1 only
	b.	C2 only
	c.	both C1 and C2
	d.	neither C1 nor C2