+1 (812) 783-0640 

SQL assignment questions

Our experts provide help with both elaborate and multiple-choice questions. On this page, they have answered numerous multiple-choice SQL questions to help you get the right answers to these questions.

Multiple choice SQL questions

Assignment

multiple choice sql questions 1

multiple choice sql questions 2

multiple choice sql questions 3

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