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 …….