some querstions 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.When invoking a procedure, you can specify the arguments using the positional method by listing the values in

the order of the argument list.

Which method would you use to list values in an arbitrary order?

	a.	FIFO
	b.	list
	c.	type
	d.	named

3.The organization for which the database is designed is referred to as

	A.	the enterprise
	B.	the entity
	C.	the universe of discourse
	D.	the metadata

4.A stored function uses the ____ statement to return a value.

	a.	PROCESS
	b.	EXIT
	c.	RETURN
	d.	END

5.Procedure A, which is a local procedure in your database, references procedure B. Procedure B is located on a

remote server, and the time dependency mode has been set to TIMESTAMP . After performing a dependency

check, the Oracle server detects a mismatch between the timestamps of the A and B procedures and identifies

that procedure B was recompiled after procedure A.

Which three statements are true about the two procedures? (Choose three.)

	a.	Procedure A will remain valid.
	b.	Procedure A will become invalid.
	c.	Procedure B will become invalid.
	d.	Procedure B need not be recompiled.
	e.	You must recompile procedure A.
	f.	Procedure A will be successfully recompiled when it is called the second time.