University Of Pune Question Paper
P. G. D. B. M. (Semester - IV) Examination - 2010
COMPUTER
(SPECIALIZATION - I : DBMS WITH ORACLE)
(Old 2005 Pattern)
Time : 3 Hours] [Max. Marks : 60
Instructions :
(1) Question No. 1 is compulsory.
(2) Solve any two questions from the remaining.
(3) Figures to the right indicate full marks.
Q.1) Consider the following table structure to write SQL queries : [20]
TOUR Table :
Tno number(2), tname varchar2(30), startDate date, endDate date, fair
number(7), Tourtype varchar2(3) (budgeted, classic), leavingFrom
varchar2(40), goingTo varchar2(40).
TOURIST Table :
Tourist no number(5), touristName varchar2(40), address varchar2(50)
BOOKING Table :
Tno number(2), touristno number(2), tourtype, varchar2(3), noOfPersons
number(2), bookingDate date
(1) Display various tours available.
(2) List all tours which will start on 16-April-2010.
(3) List Tourists who have booked tour 2 months in advance.
(4) Create TOUR table with proper constraints.
(5) List tour name and duration of the tour.
(6) Display for which tour highest preference is given by tourists.
(7) Increase tour fair by 5% for classic tours.
(8) Display tours for “Kulu Manali”.
(9) Display total fair-amount collected for tour no. 1 which starts
on 31-March-2010.
(10) List all tourists from Pune City.
Q.2) (A) Explain Oracle Architecture. [10]
(B) Explain Select Statement with all clauses. [10]
Q.3) (A) Explain E.F. Codd’s Rules. [10]
(B) Explain Database Users. [10]
Q.4) Write short notes : (Any Four) [20]
(a) Views
(b) Constraints
(c) Predicates (like, in, between etc.)
(d) Alter Statement
(e) Data Types
P. G. D. B. M. (Semester - IV) Examination - 2010
COMPUTER
(SPECIALIZATION - I : DBMS WITH ORACLE)
(Old 2005 Pattern)
Time : 3 Hours] [Max. Marks : 60
Instructions :
(1) Question No. 1 is compulsory.
(2) Solve any two questions from the remaining.
(3) Figures to the right indicate full marks.
Q.1) Consider the following table structure to write SQL queries : [20]
TOUR Table :
Tno number(2), tname varchar2(30), startDate date, endDate date, fair
number(7), Tourtype varchar2(3) (budgeted, classic), leavingFrom
varchar2(40), goingTo varchar2(40).
TOURIST Table :
Tourist no number(5), touristName varchar2(40), address varchar2(50)
BOOKING Table :
Tno number(2), touristno number(2), tourtype, varchar2(3), noOfPersons
number(2), bookingDate date
(1) Display various tours available.
(2) List all tours which will start on 16-April-2010.
(3) List Tourists who have booked tour 2 months in advance.
(4) Create TOUR table with proper constraints.
(5) List tour name and duration of the tour.
(6) Display for which tour highest preference is given by tourists.
(7) Increase tour fair by 5% for classic tours.
(8) Display tours for “Kulu Manali”.
(9) Display total fair-amount collected for tour no. 1 which starts
on 31-March-2010.
(10) List all tourists from Pune City.
Q.2) (A) Explain Oracle Architecture. [10]
(B) Explain Select Statement with all clauses. [10]
Q.3) (A) Explain E.F. Codd’s Rules. [10]
(B) Explain Database Users. [10]
Q.4) Write short notes : (Any Four) [20]
(a) Views
(b) Constraints
(c) Predicates (like, in, between etc.)
(d) Alter Statement
(e) Data Types
0 comments:
Pen down your valuable important comments below