Manonmaniam Sundaranar University (MSU) 2011 M.C.A - exam paper

MCA Degree Examination-APRIL 2011

ORACLE

(For those who joined in July 2008 and afterwards)

PART-A [10*1=10 marks]

ans ALL ques.

1. How can replace an existing table?


2. What is purpose of normalization?

3. What is synonym?

4. What is the use of natural join?

5. What is the use of PASSWORD_REUSE_TIME?

6. Write the format for creating method

7. What are the 2 kinds of materialized views?

8. How a database links works?

9. Why cursor is required?

10. What is difference ranging from Procedure and Function?


PART-B [5*5=25 marks]

ans ALL questions, Choosing either (a) or (b).

11. (a) discuss the rules for adding or modifying a column.

Or

(b) How we can update with embedded choose statement? discuss.

12. (a) How do you replacing NOT IN with NOT exist clause? discuss with
Examples.

Or

(b) Explain the correlated subqueries with an example.

13. (a) explain the 3 standard roles in detail.

Or

(b) Explain the use of string functions to manipulate LOB values.


14. (a) How do you accessing the external table? discuss.

Or

(b) Discuss the 2 kinds of materialized views.

15. (a) discuss the enabling and disabling triggers with examples.

Or

(b) discuss the simple cursor loops with an example.


PART-C [5*8=40 marks]

ans ALL questions, Choosing either (a) or (b).

16. (a) discuss the different single value functions.

Or

(b) Explain the changes of database with examples.

17.(a) discuss advanced subqueries with examples.

Or

(b) Explain the following:
(i) Temporary tablespace
(ii) Tablespacce for system managed undo
(iii) Flash back database

18. (a)Discuss the following:
(i) Selecting data from varying array
(ii) Inserting records into a varying array.

Or

(b) discuss the manipulating and selecting LOB values.

19. (a) explain the purpose of database links with examples.


Or

(b) Explain the managing load and tuning load in detail.

20.(a) Write any syntax and segments of trigger.

Or

(b) How can we create procedure? discuss in detail.

Earning:   Approval pending.