RDBMS Development With SQL Server Question Paper of 3rd Semester BSC.IT(D) Download Previous Years Question Paper 2

Roll No.

Total No. of Questions : 07

B.Sc.(Sem.–3rd)

RDBMS DEVELOPMENT WITH SQL SERVER

RDBMS-II  IT-304/204

PAPER ID: 2037

Time : 3 Hrs.                                        

INSTRUCTION TO CANDIDATES :

1.                 Section –A is Compulsory.

2.                 Attempt any Nine questions from Section-B

Section –A

Q1)

a) What is the building block of a relational database?

b) What is the most important point to remember about creating tables?

c) What are your alternatives to the text data type? When should you use

each of them?

d) How we can sort data by using ORDER BY clause?

e) What is the difference between COMPUTE BY and GROUP BY clause?

f) What is transaction?

g) Differentiate CHECK POINTS from SAVE POINTS.

h) Describe COALESCE function.

i) What is the advantage of CHECK constraint?

j) Can you drop the indexes created by some constraints?

k) What do triggers enforce?

l) Is it possible to change the database owner?

m) Describe the REVOKE object permission command.

n) Define database audit.

o) What are the functions of DBA?

Section - B

Q2) Explain different relational database objects.

Q3) Explain different data types in SQL server 2000.

Q4) Explain different functions in SQL.

Q5) Describe with example AGGREGATE FUNCTIONS in SQL.

Q6) Describe the UPDATE statement using a lookup table.

Q7) Explain the ACID properties of a transaction.

Q8) Explain different types of integrity constraints in SQL server 2000.

Q9) Describe procedure of creating and manipulating the views.

Q10) Create a trigger that prevents you from adding a new book title without having a valid publisher.

Q11) Explain how permissions are given on stored procedures.

Q12) Explain different database roles.

Q13) What are stored procedures? Explain their uses.