Consider the following procedure: CREATE PROCEDURE dbo.P_RETRIVE_DEMO_ID deimal(

Question

Consider the following procedure: CREATE PROCEDURE dbo.P_RETRIVE_DEMO_ID deimal(8, 0)) AS DECLARE @EMP_EXISTS integer BEGIN SELECT @EMP_EXISTS = (SELECT 1 FROM EMPLOYEES WHERE EMP_ID = @EMP_ID) IF @EMP_EXISTS = 1 BEGIN SELECT 'This employee is in the system.' END ELSE BEGIN SELECT ' This employee is not in the system.' END END GO Which of the following statements is TRUE in regards to the procedure? @EMP_ID is determined in a sub-query. @EMP_EXISTS is a parameter passed into the procedure. @EMP_EXISTS will contain the same the same number as @EMP_ID if the employees is in the system. @EMP_ID is a parameter passed into the procedure.

Explanation / Answer

Answer:D

A.@EMP_ID is determined in sub query- false

Reason:EMP_ID is argument to procedure

B.@EMP_EXISTS is parameter passed to procedure -false

Reason: @EMP_EXISTS is determined and initialized inside procedure

C.@EMP_EXISTS will contain the same number as@EMP_ID if the employee is in system-false

Reason: @EMP_EXISTS is boolean where as @EMP_ID is an decimal

D. @EMP_ID is a parameter passed into procedure.True

Related Questions

Navigate

• Browse (All)
• Browse C
• Subjects

---