Which stages are performed when the above block is executed?

View the Exhibit and examine the structure of the EMP table.

Which stages are performed when the above block is executed? (Choose all that apply)

View the Exhibit and examine the structure of the EMP table.

Which stages are performed when the above block is executed? (Choose all that apply)

A.
Bind

B.
Parse

C.
Fetch

D.
Execute

Show Hint

← Previous question

Next question →

Leave a Reply 17

B C D

piero

a b c d

alex

It does not bind. B, C and D is the right answer

Vladimir

piero is right,
A, B, C, D

take a trace from this code, and you will see:

PARSING IN CURSOR #284891264 len=249 dep=1 uid=48 oct=2 lid=48 tim=96683132336 hv=121690216 ad=’b5165864′ sqlid=’59hm65n3n1q38′
INSERT INTO EMPLOYEES ( EMPLOYEE_ID , FIRST_NAME , LAST_NAME , EMAIL , PHONE_NUMBER , HIRE_DATE , JOB_ID , SALARY , COMMISSION_PCT ) VALUES ( 1001 , ‘Name’ , ‘Surname’ , ‘mail’ , ’02’ , SYSDATE , ‘ST_CLERK’ , :B1 + 2500 , 0.1 )
END OF STMT
PARSE #284891264:c=0,e=11,p=0,cr=0,cu=0,mis=0,r=0,dep=1,og=1,plh=0,tim=96683132335
BINDS #284891264:
Bind#0
oacdty=02 mxl=22(21) mxlc=00 mal=00 scl=00 pre=00
oacflg=13 fl2=206001 frm=00 csi=00 siz=24 off=0
kxsbbbfp=1138e028 bln=22 avl=02 flg=09
value=2800
EXEC #284891264:c=0,e=339,p=0,cr=1,cu=14,mis=0,r=1,dep=1,og=1,plh=0,tim=96683132717

Marco

From Oracle University guide:

Bind: After parsing, the Oracle server may need values from or for any bind variable in the
statement. The process of obtaining these values is called binding variables. This stage
may be skipped if the statement does not contain bind variables.

No bind variables here, so no binding phases.

martin

there is a bind variable v_sal in insert

roman

B C D

julio

THE CORRECT ANSWER IS “D”.

@pablox_co

(A) B C D

(A) The problem here is to know: v_sal is Binded? I think it does. It does not have to be only a variable :var_name to go for the Bin phase

dames

Binding is the assignment of values to PL/SQL variables in SQL statements.
Binding of v_sal in the exhibit is handled transparently by pl/sql.
Therefore, I side to:
A,B,C,D

dames

EDIT
max 3 to ans select, so finally B,C,D

Alisa

There are 4 stages to a SQL statement.
1. Parse
2. Bind. The bind step only occurs when a SQL stmt contain one or more bind variables.
3. Execute. The server executes the stmt. For any SQL operation except SELECT, this is the last step
4. Fetch. The fetch operation retrieves the rows that satisfy the query. The fetch operation will continue until all rows of query have been returned