Question 6 which two programming constructs can be

Info iconThis preview shows page 1. Sign up to view the full content.

View Full Document Right Arrow Icon
This is the end of the preview. Sign up to access the rest of the document.

Unformatted text preview: ory. QUESTION 6: Which two programming constructs can be grouped within a package? (Choose two) A. Cursor B. Constant C. Trigger D. Sequence E. View Actualtests.com - The Power of Knowing 1Z0-147 Answer: A,B Explanation: 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 Exceptions Comments PRAGMAs Incorrect Answers 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 package. E: Views are created and they are database objects, and they can't be grouped inside the packages. 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. Answer: A,E 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 procedure. 2. Change the value of the variable by means of package procedures. 3. The value of the variable is released when the user disconnects. Incorrect Answers 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.

Ask a homework question - tutors are online