Saurastra University 2006 Post Graduate Diploma Computer Science & Management Software Engg& Access - Question Paper
SP-9411 Seat Seat No.
Illllllllllllllllllllllll
* S P - 9 4 1 1 *
P.G.D.C.A. (Sem. II) Examination April/May - 2006 RDBMS Using Oracle
[Total Marks : 100
Time : 3 Hours]
1 Answer the following questions : (any four)
20
(a) Explain database writer (DBWn).
(b) Discuss Checkpoint.
(c) Write note on Data Dictionary Cache.
(d) List various table spaces. Explain any two.
(e) Explain Redo Log Buffer.
(f) describe Oracle Instance.
2 Answer the following questions : (any four) 20
(a) Write difference between DBMS v/s RDBMS
(b) List out different data types in Oracle. Explain any two of them in detail.
(c) Explain pattern matching with an example.
(d) Discuss logical operators in Oracle with an example.
(e) List out DML command in Oracle. Explain any two of them with an example.
(f) Write note on joins with an example.
3 Answer the following questions : (any four) 20
(a) Discuss view in Oracle.
(b) What is save point in Oracle? Explain in detail.
(c) Discuss PL/SQL block with an example.
(d) Distinguish % TYPE and %ROWTYPE.
(e) What is nested table in Oracle? Explain with an example.
(f) Write note on trigger.
(b) INSTR ( )
(d) TO_DATE ( )
(a) NVL ( )
(c) SUBSTR ( )
(e) NEXT_DAY ( ) (f) GREATEST ( )
(ii) Explain exception handling in detail.
(iii) Distinguish the following :
(a) Nested table v/s VARRAY
(b) Function v/s Procedure
(iv) Write a note on cursor.
5 Attempt the following : 20
Consider the following Tables :
Employee Dept
Empno Deptno
Ename DeptName
City
Salary
Deptno.
Write queries for the following :
(a) Display total salary Departmentwise with department name.
(b) List the name of employee who belongs to the same department and same city.
(c) Display total salary whose department is SALES.
(d) Consider the above tables - write a PL/SQL block that reads a department name and increment in salary for all the employee of that department. The increment in salary is to be applied only if the total salary of that department after increment does not exceed Rs. 75,000.
(e) Consider the above tables - write a procedure which read department number and calculate total salary that department.
SP-9411] 2 [ 900/23-21 ]
|
Attachment: |
| Earning: Approval pending. |
