Reg. No. : ..........................................
4012 Q.P. Code : [08 SC 14/11 CA 10/
11 IT 09/11 CTG 11/
11 SS 15/11 MM 12]
(For the candidates admitted from 2008 onwards)
B.Sc/B.C.A DEGREE EXAMINATION,
DECEMBER 2020.
Fifth Semester
Part III — Computer Science /Computer
Applications/Information Technology/Computer
Technology/Software Systems/Multimedia and Web
Technology
RDBMS AND ORACLE
Time : Three hours Maximum : 75 marks
SECTION A — (10 × 1 = 10 marks)
Answer ALL questions.
Choose the correct answer
1. A relational database consists of a collection of
(a) Tables
(b) Fields
(c) Records
(d) Keys
2. In the ______________normal form, a composite
attribute is converted to individual attributes.
(a) First (b) Second
(c) Third (d) Fourth
3. What is the full form of SQL?
(a) Structured Query Language
(b) Structured Query List
(c) Simple Query Language
(d) None of these
4. The user defined data type can be created using
(a) Create datatype (b) Create data
(c) Create definetype (d) Create type
5. The language used application programs to
request data from the DBMS is referred to
as ————————
(a) DML
(b) DDL
(c) Query language
(d) All of the Mentioned
6. A condition is referred to as __________
(a) Join in SQL
(b) Join condition
(c) Join in SQL and Condition
(d) None of the mentioned
2 4012
7. Which of the following is not true about the
declaration section of a PL/SQL block?
(a) This section starts with the DECLARE
keyword.
(b) It is a mandatory section.
(c) It defines all variables, cursors,
subprograms, and other elements to be used
in the program.
(d) None of the above.
8. Which of the following is the correct syntax for
creating an explicit cursor?
(a) CURSOR cursor_name IS select_statement;
(b) CREATE CURSOR cursor_name IS
select_statement;
(c) CREATE CURSOR cursor_name AS
select_statement;
(d) CURSOR cursor_name AS select_statement;
9. Which of the following has internal components
that can be manipulated individually, such as the
elements of an array, record, or table?
(a) A Composite
(b) LOB
(c) A Reference
(d) A Scalar
3 4012
10. Triggers are supported in
(a) Delete
(b) Update
(c) Views
(d) All of the mentioned
SECTION B — (5 × 5 = 25 marks)
Answer ALL questions.
All questions carry equal marks.
11. (a) Explain various types of data models and
their features in detail.
Or
(b) Compare 3NF with BCNF with the help of
suitable examples.
12. (a) Discuss on benefits of Oracle.
Or
(b) Write short notes on SQL* Plus. Name six
frequently used SQL* Plus commands.
13. (a) How will you add a new row/record and
delete existing rows/records in Oracle?
Or
(b) What is a join? Explain the different types of
joins?
4 4012
14. (a) Write a PL/SQL program to calculate
factorial of any given number.
Or
(b) Discuss cursor attributes. Explain the use of
each attributes providing appropriate
example.
15. (a) Discuss on procedures in PL/SQL with
example.
Or
(b) List the uses of Data Dictionary managing
the database.
SECTION C — (5 × 8 = 40 marks)
Answer ALL questions.
16. (a) Describe the Normalization techniques using
Functional Dependency and Multi Valued
Dependency with example.
Or
(b) Draw an E-R Diagram for Airline
Reservation System. Also identify strong and
weak entity set.
17. (a) With the help of diagram, explain
client/server Database architecture.
Or
(b) Explain the naming rules and conventions in
Oracle.
5 4012
18. (a) Discuss with examples Set Operations in
Oracle.
Or
(b) Explain with examples built-in functions in
Oracle.
19. (a) Define identifiers, literals, delimiters and
comments associated with PL/SQL with the
help of suitable examples.
Or
(b) What is exception? Explain types of
exception handling in oracle give one
example
20. (a) What is package? How a package is created?
Why package is useful? Also discuss th
components of package.
Or
(b) What is function? Explain any five functions
along with syntax and output.
——–––––––––
6 4012
