Wednesday, September 26, 2012
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)
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?
punjabtechnicaluniversity.blogspot.in Roll No......................... ... Total No. of Questions : 07] ...
Roll No……….. Total No. of Questions: 07 B.Com. (Sem.-1 st ) FINANCIAL ACCOUNTING Subject Code: BCOP-101 Paper ID: [B1101] ...
punjabtechnicaluniversity.blogspot.in Click Here for Syllabus of B-Tech 1st Year . http://ptu.ac.in/userfiles/file/engg_syllab/1st_and_...
Business Organisation and Management, Question Paper of B.Com 1st Semester,Download Previous Years Question Paper 2Roll No…….. Total No. of Questions: 07 B.Com (Sem.-1 st ) BUSINESS ORGANIATION AND MANAGEMENT Subject Code: BCOP-102 (2011 &a...
Roll No……. Total No. of Questions:07 B.COM (Sem.-1 st ) BUSINESS MATHEMATICS SUBJECT CODE: BCOP-104 (2011 Batch) PAPER ID: ...
punjabtechnicaluniversity.blogspot.in Roll No. ...................... Total No. of Questions : 13] ...
punjabtechnicaluniversity.blogspot.in Master Of Technology (M-Tech) Syllabus SYLLABUS FOR MASTER OF TECHNOLOGY (M-Tech) Br...
punjabtechnicaluniversity.blogspot.in Click Downlink for Dowload of Scheme and Syllabus of B.Com. Professional Batch 2011onwards ht...
B.Sc. IT (402) (S05) / 102 (New) (Sem. - 4th) BASIC MATHEMATICS – I, Punjab Technical University, PTU, Question paperpunjabtechnicaluniversity.blogspot.in Roll No. ................. Total No. of Questions : 13] ...
punjabtechnicaluniversity.blogspot.in Roll No . ............ Total No. of Questions : 07) ...