Post Graduate Diploma-Post Graduate Diploma Business Management 4th Sem 402 : D.B.M.S. with Oracle(University of Pune, Pune-2013)
PGDBM (Semester – IV) Examination, 2013
COMPUTER SPECIALIZATION – I (C)
402 : D.B.M.S. with Oracle
(2008 Pattern)
Time : 3 Hours Total Marks : 70
Note :
i) Q. 1 and Q. 5 are compulsory.
ii) Solve any two questions from the remaining.
iii) Draw neat labelled diagram wherever necessary.
1. Consider following table structure to write SQL Queries.
Car Car Manufacturer
Car No. CMID
Car Name CM Name
Segment (Small/Midsize)
Colour Code
Price
CMID
Colour
Colour code
Colour Desc
A) Solve the following queries based on above tables : 10
1) Create above three tables with proper constraints (primary 1 foreign key).
2) Insert appropriate data in the above table (Add Minimum 5 records in each table).
P.T.O.
4387] – 404 -2-
B) Solve the following queries (any 5) : (5×2=10)
1) Display car details whose price is in the range of 1,00,000 to 5,00,000.
2) List car details in descending order of their price.
3) List total number of cars in each segment.
4) List car manufacturer name who was manufactured ‘Nano’ car.
5) Display details of all cars which are available in ‘silver’ colour.
6) Display car name, car manufacturer name & colour description of all car.
2. A) What are codd’s rule ? Define. 10
B) Explain 3-tier Architecture of DBMS. 10
3. A) Write a PLISQL block, which will check that whether accepted number is prime number or not. 10
B) Explain DDL statement with example. 10
4. A) Explain Date, string and conversion functions with examples. 10
B) Explain database user. 10
5. Write short notes on following (any two) : 10
a) Primary and Foreign key
b) Locks in Oracle
c) Characteries of DBMS
d) Sub-Queries in SQL.
| Earning: ₹ 7.05/- |
