STUPIDSID
This Qs paper appeared for DBT of
Information Technology (Semester 6)
1 (a)
Explain Transient and Persistent Objects.
5 M
1 (b)
What are Triggers? Illustrate the cases when triggers must not be used.
5 M
1 (c)
Explain and define the term Data Warehouse.
5 M
1 (d)
Explain BCNF with suitable example.
5 M
2 (a)
Explain design and implementation issues in Mobile Database.
10 M
2 (b)
Explain with proper example nested Relation in ORDBMS.
10 M
3 (a)
All electronics company have sales department Sales consider the dimensions namely
(i) Time (ii)Product (iii) Branch (iv) Location
with two measures
(i) Dollars-sold (ii) Units-sold
Design Star Schema and write DMQL for the above statement.
(i) Time (ii)Product (iii) Branch (iv) Location
with two measures
(i) Dollars-sold (ii) Units-sold
Design Star Schema and write DMQL for the above statement.
10 M
3 (b)
Explain primary horizontal fragmentation in distributed databases.
10 M
4 (a)
What are the main architectures used for building parallel databases? Give advantages and disadvantages of each.
10 M
4 (b)
Explain following concepts with example:
(i) Object identity.
(ii) Type Constructors.
(i) Object identity.
(ii) Type Constructors.
10 M
5 (a)
Consider a data warehouse for a hospital, where there are three dimensions:
(i) Doctor (ii) Patient (iii) Time
and two measures
(i) Count (ii) Charge
where charge is the fee that the doctor charges a patient for a visit.
Using the above example describe the following OLAP operations:
(i) Slice (ii) Dice (iii) Rollup (iv) Drilldown
(i) Doctor (ii) Patient (iii) Time
and two measures
(i) Count (ii) Charge
where charge is the fee that the doctor charges a patient for a visit.
Using the above example describe the following OLAP operations:
(i) Slice (ii) Dice (iii) Rollup (iv) Drilldown
10 M
5 (b)
Explain security and authorization in SQL.
10 M
6 (a)
Explain various extended features of ER diagram such as aggregation, specialization and generalization with suitable example.
10 M
6 (b)
Given a relation with eight attributes
Proj_no, Proj_name, Emp_no, Emp_name, Job_class, Charge_hrs,
Hrs_billed and Tot_charges
Normalize it upto 3rd Normal form.
Proj_no, Proj_name, Emp_no, Emp_name, Job_class, Charge_hrs,
Hrs_billed and Tot_charges
Normalize it upto 3rd Normal form.
10 M
Write short notes on:-
7 (a)
Comparison between OLTP & OLAP.
5 M
7 (b)
Two phase commit protocol.
5 M
7 (c)
Spatial Database.
5 M
7 (d)
Integrity Constraint.
5 M
More question papers from Advanced Database Management Systems