Quick Revision

GK One-Line Question & Answer

15541+ short questions with short answers, covering every category and sub-category on the site — no long articles to scroll through. Good for a fast recap before an exam, or a few minutes of daily practice.

Looking for exam process/strategy questions instead? Try the Exam Preparation FAQ →

DBMS → DDL Commands 3

Which of the following function is used to find the column count of the particular resultset?
getmetadata()
click to copy
Inorder to simplify the null value confusion in the rank function we can specify
either nulls last or first
click to copy
Which of the following is the comparison operator in tuple relational calculus
=
click to copy

DBMS → DML Commands 3

Which of the following is used as the embedded SQL in COBOL?
exec sql <embedded sql statement > end-exec
click to copy
The command                                  such tables are available only within the transaction executing the query and are dropped when the transaction finishes.
create temporary table
click to copy
In domain relaional calculus “there exist”
Э x (p1(x))
click to copy

DBMS → Joins 3

Which of the following is used to distinguish the variables in SQL from the host language variables?
–
click to copy
OLAP stands for
online analytical processing
click to copy
A set of possible data values is called
domain
click to copy

DBMS → Views 3

Which of the following is used to access large objects from a database ?
all of the mentioned
click to copy
The process of viewing the cross-tab (Single dimensional) with a fixed value of one attribute is
slicing
click to copy
An                  is a set of entities of the same type that share the same properties, or attributes.
entity set
click to copy

DBMS → Indexes 2

A                      is a special kind of a store procedure that executes in response to certain action on the table like insertion, deletion or updation of data.
triggers
click to copy
The operation of moving from finer- granularity data to a coarser granularity (by means of aggregation) is called a                  
rollup
click to copy

DBMS → Transactions 2

Triggers are supported in
views
click to copy
In SQL the cross-tabs are created using
slice
click to copy

DBMS → Concurrency Control 2

What are the after triggers?
these triggers run after an insert, update or delete on a table
click to copy
What do data warehouses support?
olap
click to copy

DBMS → Deadlock 2

The variables in the triggers are declared using
@
click to copy
Which one of the following is the right syntax for DECODE?
decode (expression, search, result [, search, result]… [, default])
click to copy

DBMS → Database Security 2

The default extension for an Oracle SQL*Plus file is:
.sql
click to copy
Relational Algebra is a                      query language that takes two relations as input and produces another relation as an output of the query.
procedural
click to copy

DBMS → PL/SQL 2

Which of the following is NOT an Oracle- supported trigger?
during
click to copy
Which of the following is a fundamental operation in relational algebra?
none of the mentioned
click to copy

DBMS → Introduction to DBMS 2

What are the different in triggers?
insert, update, delete
click to copy
Which of the following is used to denote the selection operation in relational algebra?
sigma (greek)
click to copy

DBMS → Database Architecture 2

Triggers                  enabled or disabled
can be
click to copy
For select operation the                  appear in the subscript and the                         argument appears in the paranthesis after the sigma.
predicates, relation
click to copy

DBMS → Data Models 2

Which prefixes are available to Oracle triggers?
both :new and : old
click to copy
The                        operation, denoted by −, allows us to find tuples that are in one relation but are not in another.
set-difference
click to copy

DBMS → ER Model 2

Any recursive view must be defined as the union of two subqueries: a                query that is nonrecursive and a                      query.
base, recursive
click to copy
Which is a unary operation:
generalized selection
click to copy

DBMS → Relational Model 2

Ranking of queries is done by which of the following?
order by
click to copy
Which is a join condition contains an equality operator:
equijoins
click to copy

DBMS → Normalization 2

In rank() function if one value is shared by two tuples then
the rank order continues by leaving one rank in the middle
click to copy
Which of the following is not outer join?
all of the mentioned
click to copy

DBMS → Functional Dependency 2

The                      function that does not create gaps in the ordering.
dense_rank()
click to copy
The assignment operator is denoted by
<-
click to copy

DBMS → SQL Basics 2

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).
percent_rank
click to copy
Which of the following symbol is used in the place of except?
¬
click to copy