Top 1000+ Solved DataBase Management System (DBMS) MCQ Questions Answer
Q. 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
Q. The function that does not create gaps in the ordering.
a. intense_rank()
b. continue_rank()
c. default_rank()
d. dense_rank()
Q. OLAP stands for
a. online analytical processing
b. online analysis processing
c. online transaction processing
d. online aggregate processing
Q. Which one of the following is the right syntax for DECODE?
a. decode (search, expression, result [, search, result]… [, default])
b. decode (expression, result [, search, result]… [, default], search)
c. decode (search, result [, search, result]… [, default], expression)
d. decode (expression, search, result [, search, result]… [, default])
Q. 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
Q. For select operation the appear in the subscript and the argument appears in the paranthesis after the sigma.
a. predicates, relation
b. relation, predicates
c. operation, predicates
d. relation, operation
Q. Which of the following is a fundamental operation in relational algebra?
a. set intersection
b. natural join
c. assignment
d. none of the mentioned
Q. Which of the following is used to denote the selection operation in relational algebra?
a. pi (greek)
b. sigma (greek)
c. lambda (greek)
d. omega (greek)
Q. Which is a unary operation:
a. selection operation
b. primitive operation
c. projection operation
d. generalized selection
Q. Which is a join condition contains an equality operator:
a. equijoins
b. cartesian
c. natural
d. left
Q. Which of the following is not outer join?
a. left outer join
b. right outer join
c. full outer join
d. all of the mentioned