B.C.A. (Semester IV) (CGPA) Examination, 2017
RDBMS WITH ORACLE
Day Date: Saturday, 15-04-2017 Max. Marks: 70
Time: 02.30 PM to 05.00 PM
N.B. Q.1 and Q.7 are compulsory.
Attempt any two questions from Q. to 4.
Attempt any one question from Q. 5 and 6.
All question carry equal marks.
Q.1 Choose correct alternatives: 14
buffer which will store the results of the recent query.
cursor table view all
Which SQL keyword is used to sort the result set?
Order Sort Order by None
The can only be applied at column level.
Foreign key Primary key Not null None of these
function ignores null values.
max count sum count
The statement in SQL which allows changing the definition of
a table is
Select Update Create Alter
The RDBMS terminology for a row is
Tuple Relation Attribute All of the above
is used for appending two strings.

is used to provide alias to a table or
view.
Sequence Synonym Cluster Index
assignment operator in PL/SQL.
None of above
10) A primary key that consists of more than one field is
called a
Composite key Secondary key
Group key All of these
11) What does the following SQL statement do?
Select From Customer Where Cust_Type ="Best";
Selects all the fields from the Customer table for each row
with a cust_ type "best"
Selects the"*" field from the Customer table for each row
with a cust_type "best"
Page 1 of 2
SLR-U 17
Selects fields with in them from the Customer table.
Selects all the fields from the Customer table for each row
with a cust_type"*"
12) What is the result of the "SELECT CEIL FROM DUAL"
query?
3.5 3.0 4 3.7
13) When implementing security in a DBMS, which of the
following is not supported by the GRANT command?
Providing DELETE privileges
Changing passwords
Removing privileges of other people
Providing SELECT privileges
14) Consider the following four tasks.
Changing data in one or more rows in a table
ii) Defining a View
iii) Removing a row from a table
iv) Removing a view
Which SQL keywords have to be used to accomplish the
above four tasks?
ALTER ii) CREATE iii) DELETE iv) DROP
ALTER ii) CREATE iii) INSERT iv) DELETE
UPDATE ii) CREATE iii) DELETE iv) DROP
UPDATE ii) CREATE iii) DROP iv) UPDATE
Q.2 Write the difference between DBMS and RDBMS 05
List the DML commands? Explain with syntax. 05
Explain any four string functions with example. 04
Q.3 What is stored procedure? Explain IN OUT parameters with
suitable example.
05
What is exception in Oracle? Explain structure of exception
handling with suitable example.
05
Write the difference between SQL and PL/SQL. 04
Q.4 Write a PL/SQL to check entered number is prime or not. 05
Explain Cartesian Join and Equi-Join with syntax. 05
What is view? Explain with example. 04
Q.5 Explain different Integrity constraints in details. 07
Explain different looping statements in PL/SQL. 07
Q.6 What is cursor? Explain types of cursor with suitable example. 07
What is function? Explain with suitable example. 07
Q.7 Write short notes on the following (Any 14
Sub Queries and Nesting Queries with example
Trigger with example
Indexes with example