Multiple choice SQL questions

Assignment

 

 

 

Solution 

Hi,

Here are the answers- Q1 : 1, Q2: 3 – 4, Q3 : 2 – 3 – 4 , Q4: 2 – 4, Q5: 5

Question 1 :1: it is necessary to first open the cursor using the syntax: OPEN name .

2: read the next tuple from the selection by using a cursor handler.

4: it is a good to close the handler when we are finished with it .

Question 2 : 3: you can call a procedure from within a function.

4:there is a difference between…..

5:you can return a result set from a procedure

Question 3 : 1: a trigger can call a stored procedure.

2 : a trigger attached to table a that preforms an operation on a table B …..

5:it is possible to combine triggers that have the same…….

Question 4 :

3: attribute iid of inventory having ……

4: create an index on the stock …….

Question 5 :3 : if the AVG and max select statemets in T2 …….