Questions Search

This website covers previous years question papers of various universities and colleges in India. Moreover, the information on admission to various courses from various universities/institutes/colleges are also available. Also the latest teaching faculty plus teachers jobs, Government jobs, Banking Jobs, and other jobs are regularly updated to help jobless candidates. Admit cards of various recruitment of Govt organisation are updated. Search your terms using the search box provided.

Follow by Email

Friday, December 18, 2015

P. G. D. B. M. (Semester - IV),2010 Question Paper,University Of Pune Question Paper,COMPUTER (SPECIALIZATION - I : DBMS WITH ORACLE)

University Of Pune Question Paper
P. G. D. B. M. (Semester - IV) Examination - 2010
(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 no number(5), touristName varchar2(40), address varchar2(50)
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

No comments:

Post a Comment

Pen down your valuable important comments below