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

Question:

The process of viewing the cross-tab (Single dimensional) with a fixed value of one attribute is

A.

slicing

B.

dicing

C.

pivoting

D.

both slicing and dicing

Answer» a. slicing

Question:

Which of the following function is used to find the column count of the particular resultset?

A.

getmetadata()

B.

metadata()

C.

getcolumn()

D.

get count()

Answer» a. getmetadata()

Question:

Relational Algebra is a                      query language that takes two relations as input and produces another relation as an output of the query.

A.

relational

B.

structural

C.

procedural

D.

fundamental

Answer» c. procedural

Question:

Triggers                  enabled or disabled

A.

can be

B.

cannot be

C.

ought to be

D.

always

Answer» a. can be

Question:

The command                                  such tables are available only within the transaction executing the query and are dropped when the transaction finishes.

A.

create table

B.

create temporary table

C.

create view

D.

create label view

Answer» b. create temporary table

Question:

The default extension for an Oracle SQL*Plus file is:

A.

.txt

B.

.pls

C.

.ora

D.

.sql

Answer» d. .sql

Question:

Ranking of queries is done by which of the following?

A.

group by

B.

order by

C.

having

D.

both group by and order by

Answer» b. order by

Question:

Triggers are supported in

A.

delete

B.

update

C.

views

D.

all of the mentioned

Answer» c. views