Wednesday, October 17, 2012

PostgreSQL quiz: stored procedure execution

Assume that you have a table contact and a stored procedure called insert_contact as the following screenshots

image

image

Which one below is correct?

A. CALL insert_contact(‘John’,'Tran’);

B. EXECUTE insert_contact(‘John’,’Tran’);

C. SELECT insert_contact(‘John’,’Tran’)

D. Both A & B

E. Error in the store procedure code

F. None of the above

 

Answer: [C]

Highlight to find out the answer.

No comments:

Post a Comment