Question:

OLAP stands for

A.

online analytical processing

B.

online analysis processing

C.

online transaction processing

D.

online aggregate processing

Answer» a. online analytical processing

Question:

A                      is a special kind of a store procedure that executes in response to certain action on the table like insertion, deletion or updation of data.

A.

procedures

B.

triggers

C.

functions

D.

none of the mentioned

Answer» b. triggers

Question:

In SQL the cross-tabs are created using

A.

slice

B.

dice

C.

pivot

D.

all of the mentioned

Answer» a. slice

Question:

Which of the following header must be included in java program to establish database connectivity using JDBC ?

A.

import java.sql.*;

B.

import java.sql.odbc.jdbc.*;

C.

import java.jdbc.*;

D.

import java.sql.jdbc.*;

Answer» a. import java.sql.*;

Question:

Which of the following is used to distinguish the variables in SQL from the host language variables?

A.

.

B.

–

C.

:

D.

,

Answer» b. –

Question:

In rank() function if one value is shared by two tuples then

A.

the rank order continues as counting numbers

B.

the rank order continues by leaving one rank in the middle

C.

the user specifies the order

D.

the order does not change

Answer» b. the rank order continues by leaving one rank in the middle

Question:

Which of the following is used to access large objects from a database ?

A.

setblob()

B.

getblob()

C.

getclob()

D.

all of the mentioned

Answer» d. all of the mentioned

Question:

What are the after triggers?

A.

triggers generated after a particular operation

B.

these triggers run after an insert, update or delete on a table

C.

these triggers run after an insert, views, update or delete on a table

D.

all of the mentioned

Answer» b. these triggers run after an insert, update or delete on a table

Question:

Which of the following is used as the embedded SQL in COBOL?

A.

exec sql <embedded sql statement >;

B.

exec sql <embedded sql statement > end-exec

C.

exec sql <embedded sql statement >

D.

exec sql <embedded sql statement > end exec;

Answer» b. exec sql <embedded sql statement > end-exec

Question:

The                      function that does not create gaps in the ordering.

A.

intense_rank()

B.

continue_rank()

C.

default_rank()

D.

dense_rank()

Answer» d. dense_rank()