Unformatted text preview: D_PLAYER_STAT(V_ID,0.0);
Which statement will successfully assign $75,000,000 to the V_MAX_TEAM_SALARY
variable from within a stand-alone procedure?
A. V_MAX_TEAM_SALARY := 7500000;
B. BB_PACK.ADD_PLAYER.V_MAX_TEAM_SALARY := 75000000;
C. BB_PACK.V_MAX_TEAM_SALARY := 75000000;
D. This variable cannot be assigned a value from outside the package.
To assign a value for a public variable which is declared in the package header, all what
you have to do is do user the following syntax
QUESTION 24: There is a CUSTOMER table in a schema that has a public
synonym CUSTOMER and you are granted all object privileges
on it. You have a procedure PROCESS_CUSTOMER that processes
customer information that is in the public synonym CUSTOMER
table. You have just created a new table called CUSTOMER
within your schema.
Which statement is true? Actualtests.com - The Power of Knowing 1Z0-147
A. Creating the table has no effect and procedure PROCESS_CUSTOMER still accesses
data from public synonym CUSTOMER table.
B. If the structure of your CUSTOMER table is the same as the public synonym
CUSTOMER table then the procedure PROCESS_CUSTOMER is invalidated and
gives compilation errors.
C. If the structure of your CUSTOMER table is entirely different from the public
synonym CUSTOMER table then the procedure PROCESS_CUSTOMER
successfully recompiles and accesses your CUSTOMER table.
D. If the structure of your CUSTOMER table is the same as the public synonym
CUSTOMER table then the procedure PROCESS_CUSTOMER successfully
recompiles when invoked and accesses your CUSTOMER table.
The procedure will first look in the owner of the procedure schema before looking for the
A, B, C
QUESTION 25: Which two statements about packages are true? (Choose two)
A. Both the specification and body are required components of a package.
B. The package specification is optional, but the package body is required.
C. The package specification is required, but the package...
View Full Document
- Fall '09
- Stored procedure, Incorrect Answers