some querstions about DATABASE 1.Which three statements about restrictions on pa
ID: 3726817 • Letter: S
Question
some querstions about DATABASE
1.Which three statements about restrictions on package functions used in SQL are true? (Choose three.)
A function called from a DML statement can read or modify the particular table being modified by the DML statement.
A function called from a DML statement cannot read or modify the particular table being modified by the DML statement.
A function called from a query statement or from a parallelized DML statement can execute a DML statement or modify the database.
A function called from a query statement or from a parallelized DML statement cannot execute a DML statement or modify the database.
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.
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?
FIFO
list
type
named
3.The organization for which the database is designed is referred to as
the enterprise
the entity
the universe of discourse
the metadata
4.A stored function uses the ____ statement to return a value.
PROCESS
EXIT
RETURN
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.)
Procedure A will remain valid.
Procedure A will become invalid.
Procedure B will become invalid.
Procedure B need not be recompiled.
You must recompile procedure A.
Procedure A will be successfully recompiled when it is called the second time.
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.
Explanation / Answer
Answers:
1. b,d & f.
2. a) FIFO method
3. a) the enterprise.
4. c) RETURN statement
Related Questions
Navigate
Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.