GUG/W/18/842 1 P.T.O
Bachelor of Commerce (Computer Application) II Fourth Semester
244 Paper-IV Database Programming with Oracle
P. Pages 2 GUG/W/18/842
Time Three Hours Max. Marks 80

Notes 1. All questions are compulsory and carry equal marks.
2. Draw neat and labeled diagram and use supporting data wherever necessary.
3. Avoid vague answers and write specific answers related to questions.
EITHER.
1.

What are the different SQL Tools? Explain why oracle is called as multi-user system.
8

What is SQL? What are the various sub languages of SQL.
OR
8

List various internal data types supported by oracle with suitable example of each.
8

Explain different components and elements of SQL in detail.
8
EITHER.
2.

What do you mean by constraints? Explain various constraints used during creation of table.
8

Explain following predicates with example.
LIKE BETWEEN
IN IS NULL
OR
8

What is the purpose of INSERT statement. Explain with syntax.
8

Write a SQL statement to give a grant of table EXAM to user XYZ with insertion and deletion privileges.
8
EITHER.
3.

What do you mean by group functions and explain various group functions.
8

Define subquery. Explain the use of subquery in DML statement using suitable example.
OR
8

Explain following date functions.
NEXT-DAY LAST-DAY
ADD-MONTHS MONTHS-BETWEEN
8
*0652*
GUG/W/18/842 2

Create a view that retrieves the information about employees whose salaries are greater than 15000. Consider suitable table that keep the employee information along with salary.
ETHER.
8
4.

What is the need of PL/SQL? Explain and write the structure of PL/SQL block.
8

Write an exception handling code to trap the error of receiving rows that expected and an unknown error.
OR
8

What is cursor for LOOP? Explain the processing of cursor for loop using suitable example.
8

Create a function that returns the update salary of an employee on the basis of empno, increase the salary by 10%.
8
5.
Solve all the Questions.
List the various types of user.
4
How user and password are created in oracle? Explain,
4
What are the advantages and disadvantages of sequence.
4
Explain various types of triggers.
4