Annamalai University 2008-2nd Year B.Sc Computer Science " 641RELATIONAL DATABASE MANAGEMENT SYSTEMS " (-X) (PART-III) 6609 - Question Paper

2

 

6.             What is Exception Handling? Briefly explain.

 

7.             What is Procedure? Briefly explain.

 

8.             Write short notes on Triggers.

 

9.             Give the importance of Dynamic PL/SQL.

 

10.         Explain the concepts of LOBs.

 

SECTION-B (320=60)

Answer any THREE questions

All questions carry equal marks

 

11.         Explain the various built-in functions with examples.

 

12.         Discuss the usage of REF and DEREF operators in detail.

 

13.         Explain the advantages of SQLCODE and SQLERRM.

 

14.         Explain implicit and explicit cursors in detail.

 

15.         What is SQL? Explain the various features of SQL.

 

======

 

 

 

 

 

 

 

Register Number: 6609

 

Name of the Candidate:

 

B.Sc DEGREE EXAMINATION, 2008

 

(COMPUTER SCIENCE)

 

(SECOND YEAR)

 

(PART-III)

 

(PAPER-X)

641. RELATIONAL DATABASE

MANAGEMENT SYSTEMS

 

(New Regulations)

(Including Lateral Entry)

Dec) (Time: 3 Hours

Maximum: 100 Marks

 

SECTION-A (85=40)

Answer any EIGHT questions

1.             What is DBMS? Briefly explain.

 

2.             What is View? Explain with an example.

 

3.             What is Object-Oriented Partition?

 

4.             What do you mean by nested tables? Explain.

 

5.             Explain briefly the data types in PL/SQL.