Advance Database System paper | Awkum mardan

Govt Post Graduate College Mardan

MODEL PAPER Examination Spring 2016)

Semester: 8th, BS (computer science)

Time All0wed:2h.30m                                                                                                 Marks: 60

Advance Database System

SECTION A

Note: Attempt all questions: 

Q.No.1: Fill in the blanks from the multiple choices given at the end of each blank.   (4)

1- The relational algebra is ………………….

 …………………Selects a subset of rows from relation.

2- Real RDBMSs treat relations as …………… of tuples.

3- OLAP stands for……………….

4- …………..is the task of dividing a table into a set of smaller tables.

5- R( S = …….. – (R – S)

Q.No.2: Give short answers to the following questions.                         (6)

                

-Differentiate between Join and Union.

-What is equi-join?

-Differentiate between Set and Bags?

-What is a Data cube?

-Differentiate between OLTP and OLAP.

-What do you know by relational algebra?

-What is Selection (σ ) .

                                       SECTION B                                                 (10)

Q.No.3:  What is outer join? Also explain its types.

Q.No.4:what is fragmentation ?Also explain its types.

Q.NO.5: what is distributed databases?what are the advantages of Distributed 

                Databases

Q.NO.6: what is OLAP.Explain olap operations rollup,drill down and slice.

This tutorial is provided by Quiz Door-by Admin: Mubassir Ali Swabi

……BEST OF LUCK………

Note: These two term refers...Awkum: Abul wali khan university MardanAndGpgc m: Government post graduate college Mardan