Procedure - Quiz
1. Which of the below statements are true for procedure?
a. Procedures are reusable processing blocks, and describe a sequence of data transformations.
b. Procedures can have multiple input and output parameters
c. A procedure can be created as read only (without side-effects) or read-write (with side-effects)
d. All of the above
2. Which SQL syntax is used to create a read only procedure?
a. READS SQL DATA
b. READS PROCEDURE
c. NO-SIDE-EFFECT
d. READ-ONLY
3. Which of the following is true?
a. A Read-write procedure cannot call another read-write procedure
b. A read-write procedure can call both read-write and read only procedures
c. A read only procedure cannot call read-write procedure
d. All of the above
4. SAP HANA only supports Read-Only Procedure.
a. True
b. False
Answer:
1. d
2. a
3. b,c
4. b
No comments:
Post a Comment