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 → Relational Model 3

The EXISTS keyword will be true if:
any row in the subquery meets the condition only
click to copy
Which of the following is used to get back all the transactions back after rollback?
flashback
click to copy
The granting and revoking of roles by the user may cause some confusions when that user role is revoked. To overcome the above situation
the privilege must be granted only by roles
click to copy

DBMS → Normalization 3

How can you find rows that do not match some specified condition?
double use of not exists
click to copy
             will undo all statements up to commit?
rollback
click to copy
Which of the following is used to access the database server at the time of executing the program and get the data from the server accordingly?
dynamic sql
click to copy

DBMS → Functional Dependency 3

Which one of the following deletes all the entries but keeps the structure of the relation.
delete from instructor;
click to copy
Which of the following is not an integrity constraint?
positive
click to copy
Which of the following header must be included in java program to establish database connectivity using JDBC ?
import java.sql.*;
click to copy

DBMS → SQL Basics 3

The problem of ordering the update in multiple updates is avoided using
case
click to copy
Domain constraints, functional dependency and referential integrity are special forms of                    
assertion
click to copy
Which of the following invokes functions in sql?
callable statements
click to copy

DBMS → DDL Commands 2

The        condition allows a general predicate over the relations being joined.
on
click to copy
Which of the following is the right syntax for the assertion?
create assertion ‘assertion-name’ check ‘predicate’;
click to copy

DBMS → DML Commands 2

How many tables may be included with a join?
all of the mentioned
click to copy
Data integrity constraints are used to:
improve the quality of data entered for a specific property (i.e., table column)
click to copy

DBMS → Joins 2

Which are the join types in join condition:
all of the mentioned
click to copy
Dates must be specified in the format
yyyy/mm/dd
click to copy

DBMS → Views 2

How many join types in join condition:
5
click to copy
A                  on an attribute of a relation is a data structure that allows the database system to find those tuples in the relation that have a specified value for that attribute efficiently, without scanning through all the tuples of the relation.
index
click to copy

DBMS → Indexes 2

The operation which is not considered a basic operation of relational algebra is
join
click to copy
Which of the following is used to store movie and image files?
blob
click to copy

DBMS → Transactions 2

In SQL the statement select * from R, S is equivalent to
select * from r cross join s
click to copy
The user defined data type can be created using
create type
click to copy

DBMS → Concurrency Control 2

Which of the following creates a virtual relation for storing the query?
view
click to copy
Values of one type can be converted to another domain using which of the following?
cast
click to copy

DBMS → Deadlock 2

Materialised views make sure that
view definition is kept up-to-date
click to copy
Which of the following closely resembles Create view?
create table . . . as
click to copy

DBMS → Database Security 2

Updating the value of the view
will affect the relation from which it is defined
click to copy
In contemporary databases, the top level of the hierarchy consists of              each of which can contain            
catalogs, schemas
click to copy

DBMS → PL/SQL 2

Which of the following is used at the end of the view to reject the tuples which do not satisfy the condition in where clause?
with check
click to copy
The database administrator who authorizes all the new users, modifies the database and takes grants privilege is
all of the mentioned
click to copy

DBMS → Introduction to DBMS 2

A                    consists of a sequence of query and/or update statements.
transaction
click to copy
Which of the following is used to provide privilege to only a particular attribute?
grant update(budget) on department to raj
click to copy

DBMS → Database Architecture 2

In order to undo the work of transaction after last commit which one should be used?
rollback
click to copy
Which of the following is true regarding views?
if a user creates a view on which no authorization can be granted, the system will allow the view creation request
click to copy

DBMS → Data Models 2

In case of any shut down during transaction before commit which of the following statement is done automatically?
rollback
click to copy
If we wish to grant a privilege and to allow the recipient to pass the privilege on to other users, we append the                      clause to the appropriate grant command.
with grant option
click to copy

DBMS → ER Model 2

In order to maintain the consistency during transactions, database provides
atomic
click to copy
Which of the following is used to avoid cascading of authorizations from the user?
revoke select on department from amit, satoshi restrict;
click to copy