Veer Narmad South Gujarat University 2010-1st Sem M.C.A Client Server Architecture : (A.T.K.T) (External) , , - - Question Paper

RF-4811

M. C. A. (Sem. Ill) (ATKT) Examination April/May - 2010 Paper - 301 : Client Server Architecture

Time : 3 Hours]

Instructions :

(1)

6silq<3i Puunkiufl [qaim SuwiA u* qsq <KH=fl. Fillup strictly the details of signs on your answer book.

Name of the Examination :

M. C. A. (Sem. 3) (ATKT)

Name of the Subject:

301 : Client Server Architecture

-Subject Code No.:

4 8 1 1

-Section No. (1,2......): Nil

Do as directed:    14

(a) Write in brief about all possible Oracle object privileges.

OR

(a)    What are profiles? Explain any two parameters of a profile.

(b)    What are dangling references? Explain how to handle dangling references giving example.

(c)    What are packages?

Do as directed:-    14

(a) What kind of physical files are associated with an Oracle database? Write about any 1 file with its importance.

OR

(a)    Explain the 3 methods of shutting down an oracle Database.

(b)    Explain, giving appropriate example, any 2 aggregate (group) functions.

(c)    Write the syntax of FETCH statement.

Do as directed:-    14

(a) What are extents? Explain Coalescing of extents.

OR

(a)    Explain what you mean by an Oracle instance.

(b)    Explain the stages in the shutdown process of Oracle database.

(c)    Write syntax of CREATE VIEW command.

Do as directed:-    14

(a) Write in brief about Hot Backup.

OR

(a)    Explain how to define a cursor and how to process the cursor in PL/SQL.

(b)    Explain the difference between a stored procedure and a local procedure. What are their advantages and disadvantages, wherever applicable?

(c)    Write syntax of WHILE loop of PL/SQL.

Do as directed:-    14

(a) Explain the importance of MINIMUM EXTENT option of CREATE TABLESPACE :

OR

(a)    Explain the difference between row objects and column objects giving appropriate example.

(b)    Explain, giving example, how to create nested tables in Oracle. Also explain how to insert data in a nested table.

(c)    Write the syntax CREATE FUNCTION.

RF-4811]    2    [ 400 ]

Attachment: veer-narmad-south-gujarat-university-2010-m-c-a--29091-1.pdf

Earning:   Approval pending.