B.C.A. (Semester IV) (CGPA) Examination Oct/Nov-2017
RDBMS with Oracle
Day Date: Monday, 13-11-2017 Max. Marks: 70
Time: 02.30 PM to 05.00 PM
Instructions: Q.1 and Q.7 are compulsory.
Attempt any two questions from Q. 3 and 4.
Attempt any one question from Q. 5 and 6.
Q.1 Choose the correct alternatives: 07
Create, alter and drop are commands.
Data definition language Data manipulation language
Data control language None of these
The variables in the triggers are declared using


The constraint can only be applied at column level
Not Null Primary key
Foreign key None of these
A PL/SQL block begins with section.
End Start
Main Declare
A sub-query is also termed as
Nested sub query Nested query
Sub query None of these
All loop statements must end with an statement.
End loop End if
Else None of these
Select round (44.444,1) from dual;
44.44 44.4
40 44
Q.1 Fill in the blanks. 04
Function that act on set of values are called as
The convert a value of a DATE data type to CHAR
value.
A value can be inserted into the columns of any data type.
Raw data types are used to store data.
Q.1 State whether the true or false. 03
Count (Expression) function returns the number of rows where
expression is not null.
Unions can be used in sub queries.
Joining a table itself is called Equi Join.
Page 2 of 2
SLR-CD-12
Q.2 Explain different operators used in SQL with example. 05
Explain the Group by and Having clause with example. 05
Write the different between RDBMS and DBMS. 04
Q.3 What is join? Explain different types of joins. 05
Write a PL/SQL block to test given number is Armstrong or not by using
procedure.
05
Explain aggregate function with example. 04
Q.4 Explain exception handling in PL/SQL 05
Write a PL/SQL block to check number is prime or not. 05
What is trigger? Give the applications of triggers. 04
Q.5 What is Cursor? Explain types of cursor with example. 07
Write a PL/SQL block to accept a number from user and print it in reverse
order.
07
Q.6 Explain different integrity constraint with example. 07
What is DDL and DML? Explain Insert, Update and Delete commands with
suitable example.
07
Q.7 Write short notes on the following (Any two) 14
Views
Differentiate between PL/SQL function and procedure
Looping statement in PL/SQL.