Punjab Technical University 2010-3rd Sem B.Sc Information Technology A0312 RDBMS-II - Question Paper
Roll No.
[Total No. of Pages : 02
Total No. of Questions : 13]
(Please fill this Paper ID in OMR Sheet)
B.Sc. IT (304) (S05) (LE) (Sem. - 3rd) RDBMS - II
Maximum Marks : 75
Time : 03 Hours
Instruction to Candidates:
1) Section - A is Compulsory.
2) Attempt any Nine questions from Section - B.
Section - A
(15*2 = 30)
Qi)
a) Define RDBMS with suitable example.
b) How to normalize the data?
c) What is relational database object?
d) What is redundancy? Example.
e) How to create user defined data types?
f) What is integrity? Example.
g) Define constraint. Example.
h) Define view. Example.
i) Explain how to insert and delete data in SQL with command. j) What is join operation?
k) Discuss about stored procedure?
l) Define scalar function.
m) Define trigger with example.
n) How to define authentication?
o) Write all types permissions for database.
Q2) Discuss different types of data types used in RDBMS table with example.
Q3) What is database? Why do you need relational database?
Q4) How to create table with SQL SERVER enterprise manager with example? Q5) How to avoid redundancy information?
Q6) Discuss about different types of join operation with suitable example.
Q7) Write various types of integrity with suitable example.
Q8) Explain different types of view with suitable example.
Q9) How to ensure data accuracy with SQL SERVER enterprise manager with example?
QIO) How to create stored procedure with and without using parameters with examples?
QII) How to define SQL server security access model?
Q12) How to set up different permissions on object and view?
Q13) Compare between inline table valued function and multi statement table valued function.
A-287
|
Attachment: |
| Earning: Approval pending. |
