Dr Babasaheb Ambedkar Marathwada University 2010 B.C.A Computer Application RDBMS using oracle for Dr Aurangabad. - Question Paper
Printed Pages-3]
B.C.A. (Fifth Semester) RD-24-2010
FACULTY OF MANAGEMENT SCIENCE
B.C.A. (Fifth Semester) exam
May/June, 2010
RDBMS CONCEPT USING ORACLE
Paper XXVIII
(Saturday, 12-6-2010)
Time-Three Hours Maximum Marks-80
"Please check whether you have got the right ques. paper."
N.B. :- (i) Solve any 8 ques..
(ii) All ques. carry equal marks.
1. describe RDBMS. State the purpose of RDBMS. [marks 10]
2. discuss the subsequent parts of SQL with an example: [marks 10]
(a) Data manipulation language
(b) Data definition language
(c) Data control language
P.T.O.
( two ) RD-24-2010
3. Consider the subsequent table structure :
FIELD NAME
EMP NO.
DESIGNATION
SALARY
DATA kind
NUMBER
CHARACTER
NUMBER
Write down queries in SQL for the subsequent operations.
(a) Create the above table
(b) Display all records from table
(c) Display names of employee with maximum salary.
(d) Add a new column named experience
(e) Delete all rows.
4. Write in short the basic concept of E-R Model. discuss with neat diagram all symbols used in E-R diagram. [marks 10]
5. define with syntax and examples different looping statements in PL/SQL. [marks 10]
6. provide a brief account on schemas, tables and views in oracle. Write proper syntax and definition. [marks 10]
( three ) RD-24-2010
7. discuss with example any 4 built-in functions in SQL. [marks 10]
8. How to create functions in PL/SQL? discuss with syntax. [marks 10]
9. discuss the following:
(a) choose command
(b) WHERE clause
(c) HAVING clause
(d) GROUP BY clause
10. Write short notes on:
(a) Constraints
(b) Normalization
RD-24-2010 3
Printed Pages-3]
B.C.A. (Fifth Semester) RD-24-2010
FACULTY OF MANAGEMENT SCIENCE
B.C.A. (Fifth Semester) Examination
May/June, 2010
RDBMS CONCEPT USING ORACLE Paper XXVIII (Saturday, 12-6-2010)
Time-Three Hours Maximum Marks-80
Please check whether you have got the right question paper.
N.B. :- (i) Solve any eight questions.
(ii) All questions carry equal marks.
1. Define RDBMS. State the purpose of RDBMS. 10
2. Explain the following parts of SQL with an example: 10
(a) Data manipulation language
(b) Data definition language
(c) Data control language
P.T.O.
( 2 )
3. Consider the following table structure
FIELD NAME
DATA TYPE
EMP NO.
NUMBER
CHARACTER
NUMBER
DESIGNATION
SALARY
Write down queries in SQL for the following operations.
(a) Create the above table
(b) Display all records from table
(c) Display names of employee with maximum salary.
(d) Add a new column named experience
(e) Delete all rows.
4. Write in short the basic concept of E-R Model. Explain with neat diagram all symbols used in E-R diagram. 10
5. Describe with syntax and examples various looping statements in
PL/SQL.
10
6. Give a brief account on schemas, tables and views in oracle. Write
proper syntax and definition.
10
7. Explain with example any four built-in functions in SQL. 10
8. How to create functions in PL/SQL? Explain with syntax. 10
9. Explain the following:
(a) SELECT command
(b) WHERE clause
(c) HAVING clause
(d) GROUP BY clause
10. Write short notes on:
(a) Constraints
(b) Normalization
RD-24-2010
3
|
Attachment: |
| Earning: Approval pending. |
