RDBMS -II WITH SQL SERVER, Punjab Technical University, PTU, Question Paper.

punjabtechnicaluniversity.blogspot.in

Roll No. ......................

Total No. of Questions : 13]                                                                                 [Total No. of Pages : 02

Paper ID [A0312]

(Please fill this Paper ID in OMR Sheet)

B.Sc. IT (304) (S05)/(204) (Old) (Sem. - 3rd)

RDBMS -II WITH SQL SERVER

Time : 03 Hours                                                                                Maximum Marks : 75

Instruction to Candidates:

1) Section -A is Compulsory.

2) Attempt any Nine questions from Section - B.

Section - A<

(15 × 2 = 30)

Q1)

a) What is dynamic self management capability of SQL server?

b) What are the major characteristics of data items?

c) Write the syntax to modify and delete a column from table.

d) What is the difference between table level and column level constraints?

e) Explain the concept of intension and extension.

f) How does join operations affect the performance of database?

g) List all the single-row numeric functions.

h) What are the looping statements in Transact-SQL?

i) What is difference between local and stored function?

j) Differentiate between nested and recursive triggers.

k) What is instead of trigger?

l) How does SQL SERVER specify column-level permissions?

m) What is difference between order by and group by clause?

n) Why it is necessary to establish precedence ordering for all binary, infix

operators used in an expression?

o) What operator takes Boolean operands and produces a numeric result?

Section - B

(9 × 5 = 45)

Q2) Why normalization is necessary in database? Explain the main types of

normal forms.

Q3) Briefly describe the four distinct steps in the process of database design.

What is the main objective in performing each step?

Q4) What are the different data types of SQL? Describe each in detail.

Q5) What are the properties of enterprise manager tool. Write the steps to set

these properties?

Q6) What is importance of join operation? Show the implementations of inner

join and natural join.

Q7) List all the control of flow language elements. How Case expression can be

used to return a value conditionally? Show by example.

Q8) What is the significance of views in database? Write the types of views and

how data can be modified using view?

Q9) What is the use of stored procedures? Discuss about the stored procedure

parameters.

Q10) What are the uses of triggers. Write syntax to create a trigger. How error

handling can be done in triggers.

Q11) Differentiate between windows NT authentication mode and mixed

authentication mode.

Q12) Illustrate the process to execute permission on functions.

Q13) How does scalar function differ from multistatement table valued function?