Punjab Technical University 2006-1st Sem M.Sc Information Technology -(IT) RDBMS With ORACLE - Question Paper

1105
M.Sc. (IT) 104 RDBMS With ORACLE
M.Sc. (IT) Ist Semester (2096)

Time: 3Hours Max Marks:75

Note: part A is compulsory and have 13 short ans ques. (40-60 words) of two marks every.
part B have 12 long ans ques. of five marks each, out of which candidate have to attempt any nine ques..

Part A (15x2=30)

1.
a. Differentiate ranging from SQL and PLSQL.
b. What are cursors?
c. Differentiate ranging from functions and triggers.
d. How views are various from tables?
e. Give any 2 DML commands. discuss them with suitable example.
f. What are LOB and BLOB?
g. When do we use raw and long raw data types?
h. What is explicit cursor?
i. What do you mean by “Instead of’’ trigger?
j. Is package overloading possible?
k. How many values can be returned through procedures?
l. Can DDL statement be executed in PLSQL?
m. Explain durability.
n. Explain outer join with the help of an example.
o. Explain NVL function with the help of example.


Part B (9x5=45)
2. What are various kinds of joins in SQL? discuss with the help of example.
3. Explain the different constraints in DBMS with the help of example.
4. Differentiate ranging from a relation and relational schema.
5. Give the 3 level schema of DBMS.
6. What are the different data kinds used in SQL.
7. Consider the subsequent Insurance database

Person (id, name, address)
Car (reg, year,model)
Accidents (date, driver, model)
Owns (id, reg)
Log (reg, date, driver)

Perform the subsequent querries:
(a) Find the total number of people whose cars were involved in accidents in the year 2005.
(b) Add a new customer to database.
(c) Find the number of accidents in which car belonging to “XYZ” was involved.
8. Consider the subsequent table:
Employee (emp_id, name, designation, salary, department)
Create a user described PLSQL code to compute the total salary of 1st n
Records of employee table. The value of n is passed to a cursor as a
Parameter.
9. Give the different advantages and disadvantages of DBMS.
10. What are the different functions of database administrator?
11. Explain the 3 level architechture of DBMS.
12. Differentiate ranging from ER and relational data base administrator.
13. Give the different feature of Oracle.

Earning:   Approval pending.