Question:

What do data warehouses support?

A.

olap

B.

oltp

C.

olap and oltp

D.

operational databases

Answer» a. olap

Question:

The operation of moving from finer- granularity data to a coarser granularity (by means of aggregation) is called a                  

A.

rollup

B.

drill down

C.

dicing

D.

pivoting

Answer» a. rollup

Question:

What are the different in triggers?

A.

define, create

B.

drop, comment

C.

insert, update, delete

D.

all of the mentioned

Answer» c. insert, update, delete

Question:

If there are n tuples in the partition and the rank of the tuple is r, then its                  is defined as (r −1)/(n−1).

A.

ntil()

B.

cum_rank

C.

percent_rank

D.

rank()

Answer» c. percent_rank

Question:

Inorder to simplify the null value confusion in the rank function we can specify

A.

not null

B.

nulls last

C.

nulls first

D.

either nulls last or first

Answer» d. either nulls last or first

Question:

Which of the following invokes functions in sql?

A.

prepared statements

B.

connection statement

C.

callable statements

D.

all of the mentioned

Answer» c. callable statements