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 file 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 different in triggers?
  • define, 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 prefixes are available to Oracle triggers?
  • : new only
  • : old only
  • both :new and : old
  • neither :new nor : old
Q7 | Any recursive view must be defined 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 specifies 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 defined 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 first
  • either nulls last or first
Q13 | The command                                  such tables are available only within the transaction executing the query and are dropped when the transaction finishes.
  • 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 fixed value of one attribute is
  • slicing
  • dicing
  • pivoting
  • both slicing and dicing
Q16 | The operation of moving from finer- 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 find tuples that are in one relation but are not in another.
  • union
  • set-difference
  • difference
  • 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