Database Management System Set 11
Computer Science Engineering (CSE),
Bachelor of Science in Computer Science FY (BSc CS),
Bachelor of Science in Computer Science SY (BSc CS),
Bachelor of Science in Information Technology SY (BSc IT),
Bachelor of Computer Applications (BCA),
Bachelor of Business Administration in Computer Applications (BBA [CA]),
Bachelor of Science in Information Technology (BSc IT),
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