GUG/W/18/10773 1 P.T.O
Master of Computer Management (M.C.M.-II) (CBCS Pattern) Third Semester
PMCMT303.1 Elective-I Oracle (PL/SQL Programming)
P. Pages 1 GUG/W/18/10773
Time Three Hours Max. Marks 80

Notes 1. All the questions are compulsory and carry equal marks.
2. Draw neat and labelled diagram wherever necessary.
3. Avoid vague answers.
1.
Either

Explain the database users in detail.
8

Explain Data types used in Oracle.
8
OR

How oracle act as multi-user? Explain.
8

Explain RDBMS concept in detail.
8
2.
Either

Explain command with Syntax example.
SELECT. ii) UPDATE.
8

Explain data Integrity through constraints.
8
OR

Explain Data control language.
8

Explain command with Syntax example.
ALTER TABLE. ii) INSERT.
8
3.
Either

Explain any four Numeric function with example.
8

What is join? Explain types of join.
8
OR

Explain any four Group function with example.
8

Explain case manipulation functions.
8
4.
Either

Explain basic elements of programming.
8

Explain Select….Into Statement with example.
8
OR

What is Exception? Explain predefined Exception.
8

Explain Explicit cursor Attributes in detail.
8
5.
Attempt all the questions.

Write a note on SQL *plus.
4

Write a note on commit Rollback.
4

Explain Sequence with example.
4

Write a note on Trigger.
4

*2926*