Answer the following questions.
Question 1) Write down the basic features of embedded SQL.
Question 2) Distinguish between Automation stored procedures and replication stored procedures.
Question 3) Write down the four operations that should be performed for successful working of cursor?
Question 4) Demonstrate the statement used to create a table. Describe it with all possible options.
Question 5) What is advantage of using indexes? Write the statements to create and delete an index?
Question 6)(a) Write down the types of integrity constraints used in Transact-SQL.
(b) Write about control structures.
Question 7)(a) Write the queries for the following database
EMPLOYEE ANME (FNAME, LNAME, SSN SALARY DNO)
WORKS_ON (ESSN, PNO, HOURS)
PROJECTS (PNAME, PNUMBER, PLOCATION, DNUM)
For each project retrieve the project number, project name and the number of employees who work on project. Solve this query in T-SQL and relational algebra.
(b) Write down the advantages and disadvantages of triggers?
Question 8) Describe the problems of deadlock and starvation, and various approaches to deal with these problems.