Hemchandracharya North Gujarat University 306 : Advance Database Architecture model question papers

Download Model question papers & previous years 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

Course: M Tech Automobile   University/board: Hemchandracharya North Gujarat University

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
Set variable.

(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.

1 [Contd…

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
Between them.

(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

Next Question Paper: 305 : Advance Programming with Java

Previous Question Paper: 401: MIS & ERP

Related Question Papers:

  • 106 : Information Technology

  • 106 : Information Technology

  • 107 : Internet & Web

  • 107 : Internet & Web

  • 105 : Basic Microcomputer Application

  • Categories

    Submit Previous Years University Question Papers 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.

    Looking for University or College admissions in India for 2020 - 2021 Academic Year?

    Top Contributors
    TodayLast 7 Daysmore...

    Awards & Gifts
    SpiderWorks Technologies Pvt Ltd, Kochi - India. © All Rights Reserved.