Punjab Technical University 2009-6th Sem B.Tech Computer Science and Engineering - - RELATIONAL DATABASE MANAGEMENT SYSTEMS -- II - Question Paper

UNIVERSITY ques. PAPER,MAY 2009
RELATIONAL DATABASE MANAGEMENT SYSTEMS-II(CS-302)
Time Allowed:3Hours Maximum Marks:60
Instruction To Candidate:
1. Section-A is compulsary.
2. Attempt any 4 ques. from Section-B.
3. Attempt any 2 ques. from Section-C.
SECTION-A
Q.1.(a)What do you mean by the term data independence?
(b)What is indexing?When do we go for it?
(c)What is relational data structure?Give examples.
(d)Differentiate ranging from the SQL and embedded SQL.
(e)Describe the term QBE.
(f)What is the purpose of the using triggers in a data base system?
(g)Differentiate ranging from SQL and PL/SQL.
(h)What are defaults?Is there a column to which a default can't be bound?
(i)How candidate key is various from primary key and super key?
(j)What is sequence?How it is created in PL/SQL?
SECTION-B
Q.2.What is data base model?Discuss in brief the advantage of relational model.
Q.3.CREATE INDEX myindex ON myTable(myColumn).What kind of index will created after executing
this statement?
Q.4.What are the different integrity constraints supported by Oracle server?
Q.5.Compare and contrast the terms: Relational algebra and Relational calculus.
Q.6.What is Normalization and its need. explain the Anomalies in 3NF relations.
SECTION-C
Q.7.(a)What is stored procedure? Why do we need them? How are they various from functions and
triggers?
(b)Describe the terms: Cursor and package in the situation of SQL server.
Q.8.Differentiate the following:
(a)Subqueries and Corelated queries.
(b)Security and Integrity
(c)Partial and Transitive DePENDENCY
(d)SQL and Oracle Server
Q.9.Write short note on the following:
(a)Transact-SQL PLUS
(b)Data base Recovery techniques.

Earning:   Approval pending.