B.Sc. IT (304) (S05)/(204) (Old) (Sem. - 3rd) 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?