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

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 graphical query analyzer facility of SQL Server?

b) How does schema diagram differ from instance diagram?

c) How can we insert a result of a query into a table?

d) Describe the way to define table constraints.

e) What do you mean by base and derived relations?

f) List the group functions used in SQL.

g) How null values can be handled in SQL? Give an example.

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

i) What is foreign key?

j) Write syntax to call a procedure.

k) A statement must satisfy all constraints before the trigger is

invoked. Explain this statement with example.

1) What is the procedure to deny a permission?

m) What is difference between compute and compute by clause?

n) List the string functions used in SQL.

o) Write an query using multiple criteria to retrieve rows.

Section - B

Q2) Why higher normal forms are usually avoided? Give two examples where these normal forms are recommended strongly.

Q3) Describe the process of relational database definition. What are the inputs and outputs?

Q4) Differentiate between SQL data types and user defined data types. Explain user defined data type taking lucid examples.

Q5) Write the steps to create a table with SQL SERVER enterprise manager.

Q6) What do you mean by sub query? Describe the types of sub queries. How is a sub query used as a scalar value?

Q7) What are the integrity rules? Explain referenced integrity using example? What type of inconsistencies can be avoided using referenced integrity?

Q8) What is main difference between a relation and a view. Write syntax to create, update and delete a view.

Q9) What are the parts of a trigger? How we can issue user defined error massage during firing a trigger?

Q10) Describe the two security modes in which we can configure SQL SERVER.

Q11) Differentiate between statement permissions and object permissions.

Q12) What is the procedure to execute permissions on stored procedures?

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