Yashwantrao Chavan Maharashtra Open University 2006 Certification TES SQL Programming - Question Paper

TES091/EE/20070811
SQL Programming
Time : 180 minutes Marks : 100
Instructions for the students :
1. All ques. are compulsory.
2. “Long ans kind ques. (LAQ)” is a supply kind ques. of 20 marks,
which require typical ans of about 60-80 lines in about 32-40 minutes.
3. “Short ans kind ques. (SAQ)” is a supply kind ques. of five marks,
which require typical ans of about 15-20 lines in about 08-10 minutes.
4. Use of non-programmable kind of scientific calculator is allowed.
5. Draw neat diagrams wherever necessary.
6. presume suitable data if necessary.

Long ans kind ques. (LAQ’s)
1. (a) Justify SQL is declarative language.
(b) describe
i) Databas ii) Datastore
iii) Dataserver iv) DBMS
v) Database engine
(c) i) With the help of a neat diagram show SQL’s place in data
center. List out the different front ends.
ii) List out different back end with its features.

2. (a) Consider Table Account info containing Account
Number, Balance and Branch Name.
i) Display records in decending order of balance.
ii) Display the record (only one) having highest balance.
(b) provide syntax of having clause with explanation.
(c) Write syntax for creating table and inserting info into
it.

3. (a) discuss the conversion with syntax.
(b) How modifications to the record entries are made ? provide syntax.
(c) When outer join is used ? provide syntax.
(d) Write syntax and scope of delete statement.




4. (a) Why store procedures are used ?
(b) discuss aggregate operations :
i) UNION ii) other than
iii) INTERSECT
provide syntax for every.

Earning:   Approval pending.