Hemchandracharya North Gujarat University 2006 B.Sc Computer Science 306 : Advance Database Architecture - Question Paper

AA-3606 Seat No.______
3rd Year M. Sc. (CA & IT) exam
March / April – 2006
306 : Advance Database Architecture

Time : three Hours] Total Marks: 35


one (a) What do you mean by system database 4
Object and user database object. discuss
User database objects.

(b) What is the importance of initialization 4
Parameter file ? discuss at lowest four
Parameter.

OR
(b) discuss 4 oracle background process. 4

(c) Write SQZ for displaying all open cursors 3
For a provided user’s SID.


two Attempt any 3 : 9

(i) discuss the usage of glogin.sqz and 3
Loginsal file. Where it located? How can we
change SQLPATH ?

(ii) discuss copy command of SQL-plus with 3
Set variable.

(iii) provide proper hierarchy for application, 3
Schemas, tablespaces and database file with
Example. Here application may have several
Ora and tablespace.

(iv) provide suitable example of for…loop to the 3
Cursor in PL/SQL.


one [Contd…



3 Attempt any 2 : 6

(i) Write script to list all object in the database
With more than 5 extents.

(ii) How can we move all object from 1 table
Space to a different tablespace for identical user,
Write steps for it.

(iii) provide suitable example of SQLA loader for
Loading with conditional checking.

4 Attempt any 3 : 9

(i) What is the usage of PCT free and PCT used?
provide suitable example for giving relation
ranging from them.

(ii) What is ROI? How can we see cost effective
way of viewing the performance tunning
Process?

(iii) List all DSS problems and suggest improper
strategies for resolving it.

(iv) Why locking is required? discuss. DML locks.






______________________________

Earning:   Approval pending.