Answer the following problems.
problem 1) prepare down the basic features of embedded SQL.
problem 2) Distinguish between Automation stored procedures and replication stored procedures.
problem 3) prepare down the four operations that should be performed for successful working of cursor?
problem 4) Demonstrate the statement used to create a table. Describe it with all possible options.
problem 5) What is advantage of using indexes? prepare the statements to create and delete an index?
problem 6)(a) prepare down the types of integrity constraints used in Transact-SQL.
(b) prepare about control structures.
problem 7)(a) prepare 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) prepare down the advantages and disadvantages of triggers?
problem 8) Describe the problems of deadlock and starvation, and various approaches to deal with these problems.