term1 Definition1term2 Definition2term3 Definition3
Please sign in to your Google account to access your documents:
Question: 1
Examine the following command:SQL>ALTER SESSIONSET plsql_warnings *'enable: severe','enable: performance', 'ERROR: 05003';What is the implication of theabove command?
A. It issues a warningwhenever ERROR: 05003 occur during compilation.
B. It causes the compilationto fail whenever the warning ERROR.05003 occurs.
C. It issues warnings wheneverthe code causes an unexpected action or wrong results performance problems.
D. It causes the compilationto fail whenever the code gives wrong results or contains statements that arenever executed.
Answer: C
It issues warnings whenever the code causes an unexpected action or wrong results performance problems
Question: 2
Which two tasks should be created as functions insteadof as procedures? (Choose two.)
A. Reference host or bindvariables in a PL7SQL block of code
B.Tasks that compute and return multiple values to the calling environment
C. Tasks that compute a valuethat must be returned to the calling environment
D.Tasks performed in SQL that increase data independence by processing complexdata analysis within the Oracle server, rather than by retrieving the data intoan application
Answer: A, C
Reference host or bind variables in a PL7SQL block of code
Tasks that compute a value that must be returned to the calling environment
Question: 5
What would be the outcome whenthe code is executed?
A. It executes successfully.
B. It gives an error becausethe SAL variable is not visible in the increase function.
C. It gives an error becausethe increase function cannot be called from the RAISE_SALARY procedure.
D.It gives an error because the increase function and the RAISE_SALARY procedureshould be declared at the beginning of the declare section before all the otherdeclarations.
Need help typing ? See our FAQ (opens in new window)
Please sign in to create this set. We'll bring you back here when you are done.
Discard Changes Sign in
Please sign in to add to folders.
Sign in
Don't have an account? Sign Up »
You have created 2 folders. Please upgrade to Cram Premium to create hundreds of folders!