Database Management System Set 11

Learning Mode Previous Next

On This Page

This set of DataBase Management System (DBMS) Multiple Choice Questions & Answers (MCQs) focuses on Database Management System Set 11

Q1 | The variables in the triggers are declared using

–

Q2 | The default extension for an Oracle SQL*Plus ﬁle is:

.txt

.pls

.ora

.sql

Q3 | Which of the following is NOT an Oracle- supported trigger?

before

during

after

instead of

Q4 | What are the diﬀerent in triggers?

deﬁne, create

drop, comment

insert, update, delete

all of the mentioned

Q5 | Triggers enabled or disabled

can be

cannot be

ought to be

always

Q6 | Which preﬁxes are available to Oracle triggers?

: new only

: old only

both :new and : old

neither :new nor : old

Q7 | Any recursive view must be deﬁned as the union of two subqueries: a query that is nonrecursive and a query.

base, recursive

recursive, base

base, redundant

view, base

Q8 | Ranking of queries is done by which of the following?

group by

order by

having

both group by and order by

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

the rank order continues as counting numbers

the rank order continues by leaving one rank in the middle

the user speciﬁes the order

the order does not change

Q10 | The function that does not create gaps in the ordering.

intense_rank()

continue_rank()

default_rank()

dense_rank()

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

ntil()

cum_rank

percent_rank

rank()

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

not null

nulls last

nulls ﬁrst

either nulls last or ﬁrst

Q13 | The command such tables are available only within the transaction executing the query and are dropped when the transaction ﬁnishes.

create table

create temporary table

create view

create label view

Q14 | OLAP stands for

online analytical processing

online analysis processing

online transaction processing

online aggregate processing

Q15 | The process of viewing the cross-tab (Single dimensional) with a ﬁxed value of one attribute is

slicing

dicing

pivoting

both slicing and dicing

Q16 | The operation of moving from ﬁner- granularity data to a coarser granularity (by means of aggregation) is called a

rollup

drill down

dicing

pivoting

Q17 | In SQL the cross-tabs are created using

slice

dice

pivot

all of the mentioned

Q18 | What do data warehouses support?

olap

oltp

olap and oltp

operational databases

Q19 | Which one of the following is the right syntax for DECODE?

decode (search, expression, result [, search, result]… [, default])

decode (expression, result [, search, result]… [, default], search)

decode (search, result [, search, result]… [, default], expression)

decode (expression, search, result [, search, result]… [, default])

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

relational

structural

procedural

fundamental

Q21 | For select operation the appear in the subscript and the argument appears in the paranthesis after the sigma.

predicates, relation

relation, predicates

operation, predicates

relation, operation

Q22 | The operation, denoted by −, allows us to ﬁnd tuples that are in one relation but are not in another.

union

set-diﬀerence

diﬀerence

intersection

Q23 | Which of the following is a fundamental operation in relational algebra?

set intersection

natural join

assignment

none of the mentioned

Q24 | Which of the following is used to denote the selection operation in relational algebra?

pi (greek)

sigma (greek)

lambda (greek)

omega (greek)

Q25 | Which is a unary operation:

selection operation

primitive operation

projection operation

generalized selection

Previous Next