Examine the following snippet of PL/SQL code:
View the exhibit for table description of EMPLOYEES table. The EMPLOYEES table has 200 rows.
Identify open statement for opening the cursor that fetches the result as consisting of employees with JOB_ID as ‘ST_CLERK’ and salary greater than 3000. (Choose all that apply)
A.
OPEN c1 (NULL, 3000);
B.
OPEN c1 (emp_job, 3000);
C.
OPEN c1 (3000, emp_salary);
D.
OPEN c1 (‘ST_CLERK’, 3000)
E.
OPEN c1 (EMP_job, emp_salary);
Explanation:
two answers…. B , E
“two answers…. B , E”
I think three answers: B, E and D
The answer is B, D and E.
B D E
Yes B,D and D
B,D and E
BDE
D is missing a semicolon. BE are correct.
Syntax wise B,D and E are correct. But, the question states a condition “consisting of employees with JOB_ID as ‘ST_CLERK’ and salary greater than 3000”. Hence, the answer is D
Why?
emp_job and emp_salary is set to the same values as wanted. Should be B,D and E so. Or did i miss something?
BDE
B,D,E are correct
only B,E since D missing ;
OK everyone the answer is here in Oracle own Doco 🙂
LINK: http://docs.oracle.com/cd/B19306_01/appdev.102/b14261/sqloperations.htm#i45976
Looks like the answer is B,D and E.
You are right Paul. I executed the code from the link you provided:
“Example 6-23 Passing Parameters to Explicit Cursors”
so the correct answers are: B,D, E
B D E
A- NO RESULT
B – GIVES RESULT
C – NO RESULT
D- GIVES RESULT
E- GIVES RESULT
ANSWER – B D E
E,D,B 🙂
What if values of variables are changed inside the program before opening the cursor….then only option D is valid.
B, D, E
B,D,E
answer b,d,e
but in codding syntax D is wrong missing semicolon ” ; ”
M.Naj when talk about changed during execute or inside program that mean just variable is correct (A,B,C wrong because contain values) that mean E is right
so , i think this question need to see how use parameters
from that i think B and E is better answers
Dear Ali,
Mistyping…mistyping is everywhere!© B.L.
BDE.
I agree, D clearly is different since it does not have ; at the end.
Answer : B and E
although sites we backlink to beneath are considerably not related to ours, we feel they are truly really worth a go by way of, so possess a look
below youll find the link to some web pages that we assume you must visit
the time to study or pay a visit to the content or internet sites we have linked to beneath the
that could be the end of this write-up. Here you will locate some internet sites that we assume youll appreciate, just click the hyperlinks over
that could be the finish of this report. Right here you will find some web pages that we believe youll value, just click the links over
please take a look at the websites we stick to, such as this one, because it represents our picks through the web
bde
For those of you who got it wrong, You should really pay attention to cursor calls in your studies. The correct answer is B, D, E.