This preview shows page 1. Sign up to view the full content.
Unformatted text preview: ory.
QUESTION 6: Which two programming constructs can be grouped within a package? (Choose two)
Actualtests.com - The Power of Knowing 1Z0-147 Answer: A,B
The constructs that can be grouped within a package include:
Procedures and Functions
Cursors, Variables and Constants
Composite data types, such as TABLE or RECORD
C: Triggers are objects that we create are created on the tables.
D: Sequences can't be grouped inside the packages, but we can reference then inside the
E: Views are created and they are database objects, and they can't be grouped inside the
QUESTION 7: Which two statements describe the state of a package variable after executing the
package in which it is declared? (Choose two)
A. It persists across transactions within a session.
B. It persists from session to session for the same user.
C. It does not persist across transaction within a session.
D. It persists from user to user when the package is invoked.
E. It does not persist from session to session for the same user.
You can keep track of the state of a package variable or cursor, which persists throughout
the user session, from the time the user first references the variable or cursor to the time
the user disconnects.
1. Initialize the variable within its declaration or within an automatic, one-time-only
2. Change the value of the variable by means of package procedures.
3. The value of the variable is released when the user disconnects.
B: Each session will have its own value for the variables
C: It persists across the transactions and through the user session.
D: Each user has his own values and results, because each user has his own users.
QUESTION 8: Actualtests.com - The Power of Knowing 1Z0-147
Which code can you use to ensure that the salary is not increased by more than 10% at a
time nor is it ever decreased?
A. ALTER TABLE emp ADD
CONSTRAINT ck_sal CHECK (sal BETWEEN sal AND sal*1.1)...
View Full Document
This document was uploaded on 03/08/2014.
- Fall '09