MYSQL DATABASE QUESTION 1. Which of the following is the replacement character f

Question

MYSQL DATABASE QUESTION

1. Which of the following is the replacement character for BINDING values in a DYNAMIC statement

a. !

b. *

c. #

d. ?

2. "Create a Named Row Data Type (NAME_DETAIL) with the following columns : NAME VARCHAR(100), AGE INTEGER, GENDER CHAR(1)"

3. Write a loop that iterates a cursor CUR1 that uses this SELECT : SELECT EMPTIME FROM EMPPROJACT and sums up the EMPTIMES into a variable V_TOTAL_TIME on each iteration

4. CREATE just the concatinated string for a DYNAMIC SQL statement SET to a variable @stringSQL that would UPDATE a table : VARIABLES table name : FINAL_TABLE column : FINAL_COLUMN value : FINAL_TOTAL

Explanation / Answer

1ANS

(B) *

2ANS

Related Questions

Navigate

• Browse (All)
• Browse M
• Subjects

Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.