Download Model question papers & previous years question papers
Submit Previous Years University Question Papers
Posted Date: 29 Dec 2008 Posted By:: Darshak Member Level: Silver Points: 5 (₹ 1)
2006 Hemchandracharya North Gujarat University M Tech Automobile 306 : Advance Database Architecture Question paper
AA-3606 Seat No.______
Third Year M. Sc. (CA & IT) Examination
March / April – 2006
306 : Advance Database Architecture
Time : 3 Hours] Total Marks: 35
1 (a) What do you mean by system database 4
Object and user database object. Explain
User database objects.
(b) What is the importance of initialization 4
Parameter file ? Explain at least four
(b) Explain four oracle background process. 4
(c) Write SQZ for displaying all open cursors 3
For a given user's SID.
2 Attempt any three : 9
(i) Explain the usage of glogin.sqz and 3
Loginsal file. Where it located? How can we
Change SQLPATH ?
(ii) Explain copy command of SQL-plus with 3
(iii) Give proper hierarchy for application, 3
Schemas, tablespaces and database file with
Example. Here application may have several
Ora and tablespace.
(iv) Give suitable example of for…loop to the 3
Cursor in PL/SQL.
3 Attempt any two : 6
(i) Write script to list all object in the database
With more than five extents.
(ii) How can we move all object from one table
Space to another tablespace for same user,
Write steps for it.
(iii) Give suitable example of SQLA loader for
Loading with conditional checking.
4 Attempt any three : 9
(i) What is the usage of PCT free and PCT used?
Give suitable example for giving relation
(ii) What is ROI? How can we see cost effective
way of viewing the performance tunning
(iii) List all DSS issues and suggest appropriate
strategies for resolving it.
(iv) Why locking is required? Explain. DML locks.
Return to question paper search
and make money from adsense revenue sharing program
Are you preparing for a university examination? Download model question papers
and practise before you write the exam.