Bharathiar University 2012 B.C.A Computer Application Rdbms and oracle - Question Paper

Part III computer Applications
RDBMS AND ORACLE
part A-(10*1=10marks)
ans ALL ques..

select the accurate ans :

1. DML stands for -
a) Data manipulation language
b) Data maintenance language
c) Data making logic
d) Data markup language
2. In E-R model an attribute is represented by using
a) Ellipse b) Diamond c)Square d)Rectangle
3. refers to the use of standard SQL Statements within a procedural programming language.
a) Embedded SQL
b) Procedural SQL
c) Form based SQL
d) All the above

4. data kind used to store picture files.
a) BLOB b) JPEG
c) Vaschar d) nested table
5. - pseudo-column returns a row address.
a) data id b) primary key c) Row id d) key
6. WHERE clause can be used in statements.
a)SELECT b) DELETE c) UPDATE d) all the above
7. If choose #####(15.7) FROM DUAL query returns 16 them ##### represents.
a) CEIL b)ROUND c) Both (a) and (b)
d) None of these
8. The - statement retrieves the current row in the outcome set and advances the cursor to the next row .
a)OPEN b)FETCH c)LOOP d) CLOSE
9. A is an ordered group of elements , all of the identical kind to associate a single identifier with an entire collection.
a)array b)collection c)structure d)package
10. In general - of PL/SQL Used to calculate a value instead of performing an action
a)procedure b)function c)package d)method

part B (5*5=25marks)
ans ALL ques..
11. a) write a note on denormalization .
Or
b) write a note on integrity rules.

12. a) elements of structured query languages.
Or
b)explain the operations used to alter existing tables.
13. a) explain the different special comparison operators .
Or
b) how to restrict data during retrieval from tables? discuss with example.
14. a)explain the PL/SQL block structure with an example.
Or
b) write a note on data kind conversion in PL/SQL.
15. a) compare the differences ranging from Varrays and nested tables.
Or
b) discuss the usage of RETURN statement.

part C (5*8=40 marks)
ans ALL ques..
16. a) discuss the differences ranging from file system and database systems.
Or
b) define the concept of Normalization process with example.
17. a)explain the features of different aggregate functions in SQL.
Or
b)explain the usage of keys in table related operations.
18. a)describe the different date manipulation built-in functions.
Or
b)elaborate on the operator precedence in PL/SQL.
19. a) discuss the process of declaration in PL/SQL.
Or
b)despice the handling process of raised exceptions in PL/SQL.
20. a) define the concept of PL/SQL Packages.
Or
b) create a PL/SQL Trigger to display fault message when the provided new mark is either.

Earning:   Approval pending.