B.C.A. (Semester IV) (CGPA) Examination Mar/Apr-2018
RDMS WITH ORACLE
Time: 2½ Hours
Max. Marks: 70
Instructions: Q.1 and Q.7 are compulsory. Attempt any two questions from Q. 2 to Q.4. Attempt any one question from Q. 5 and Q.6.
Q.1
Choose the correct alternatives:
14
A is a set of tables physically stored together as one table that shares a common column.
Index
Object
Cluster
Non-index
is invalid data type.
Char
Varchar2
Varchar1
Number
Which of the following is not valid command in PL/SQL?
Update
Delete
Create
All of these
Oracle is a second generation relational database management system.
True
False
A stored procedure is a
stored in a compiled form in the database
can be shared
sequence of SQL statements
all of these
Which of the following is correct about view?
It is a virtual table
It is derived from other table
Both a and b
None of these
The select statement is used to
display the records from a table
modify structure of a table
update existing record
none of these
Which of the following is used to define code that is fired when certain action occur?
Cursor
Trigger
Both A and B
None of these
Which SQL keyword is used to sort the result set?
order
sort
order by
sort by
10) Which of the following is not a type of SQL statement?
Data Definition Language
Data Manipulation Language
Data Standard Language
Data Control Language
Page 2 of 2
SLR-CV-7
11) The update command is used to modify structure of a table.
True
False
12) Which of the following is not type of join?
equi-join
non-equi join
inner join
outer join
13) In a relational schema, each tuple is divided into fields called domains.
True
False
14) Which of the following is not predefined exception?
login_denied
no_data_found
too_many_rows
cursor_invalid
Q.2
Give the applications of triggers with suitable example.
05
What is self-join? Give one example.
05
Write not on cluster.
04
Q.3
Discuss on any five of the aggregate functions in SQL with examples.
05
Explain different conversion functions.
05
Explain like operator.
04
Q.4
Give the syntax and example of sequence and synonym.
05
Differentiate between where clause and having clause with suitable example.
05
Explain advantages of views.
04
Q.5
Write a user defined function which will accept name of the employee and will return salary of that employee.
07
What is sub-query? Explain the concept of nested sub-queries with suitable example.
07
Q.6
Write a cursor to display top 5 salaried employees.
07
What are triggers? How to create triggers?
07
Q.7
Write short note on
14
SQL and its advantages
Cursor attributes
Domain and tuple
Advantages of PL/SQL exceptions