Punjab University 2011-2nd Year B.C.A Computer Application Client server comting using oracle, , - Question Paper

BCA-2nd Year
CLIENT SERVER COMPUTING USING ORACLE
Paper:BCA-12

Time Allowed:Three Hours
Maximum Marks:90

Note:-(i) Attempt 5 ques. selecting 1 ques. every from
Sections A,B,C,D.
(ii) Section E is compulsory.
(iii) All ques. carry equal marks.

SECTION-A

I. (a) elaborate the responsibilities of a client in client server

computing?Discuss.


(b) What is the significance of Codd's Rule for a RDBMS?

define.

(C) elaborate the potential benefits of using Oracle database?

Brief out.6,6,6=18

II. (a) How do you carry out conditional retrieval of rows from a

database table? explain with relevant example.

(b) How do you join a table to itself while ensuring that all

redundancies are eliminates? provide the relevant SQL statement

with proper syntax.

(c) Brief out different aggregate functions used in SQL statements.6,6,6=18

SECTION-B

III. (a) What do you mean by nested queries? Why do you write them?Discuss.

(b) List down different Group functions used in SQL*PLUS with relevant

syntax.6,12=18


IV. (a) presume a customer table containing following:

Fields Date-type

Customer-Id Integer

Customer-Name String

Order-No. String

Order-Date Date

Customer-Address String

Write relevant SQL statements for the subsequent operations:

(i) Creating table 'Customer'.

(ii) Dropping column 'Customer-Address'.

(iii)Updating 'Order-No.'column.

(b) elaborate materized views?How do they differ from inline views?Discuss.

(c) elaborate Join views?Discuss different rules of DML statements for Join

views.9,4,5=18

SECTION-C

V. (a) What do you mean by privileges in situation of database? How are

they managed?Discuss.

(b) How does PL/SQL differ from conventional programming languages?Describe.

(c) elaborate different data kinds supported by PL/SQL?Discuss.6,6,6=18


VI. (a) explain the usage of subsequent statements:

(i) REVOKE

(ii) COMMIT

(iii) GRANT.

(b) What do you mean by sequences?Why are they used?Discuss.

(c) explain the conditional controls used in PL/SQL with small

examples.6,6,6=18

SECTION-D

VII. (a) explain attributes of implicit cursor.

(b) explain a few predefined exceptions of PL/SQL which are

commonly used.

(c) Using PL/SQL, describe an exception which are occur if age is

above 30 years.6,6,6=18

VIII.(a) Differentiate ranging from true and formal arguments in PL?SQL.

(b) What do you mean by stored packages> elaborate their advantages?Discuss.

(c) Brief out different kinds of triggers used in PL/SQL.6,6,6=18


SECTION-E

IX. explain briefly:(Attempt all parts)

(a) What is a foreign key?

(b) What is an outer join?

(c) What is the use of Minus set operator?

(d) elaborate the limitations of views?

(e) What is the need of database security?

(f) What do you mean by operator precedence?

(f) How can you refer non PL/SQL variables in PL/SQL?

(g) What is a procedure in PL/SQL?

(h) How do you drop a trigger?9x2=18

Earning:   Approval pending.