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 → Introduction to DBMS 3

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
What are the different in triggers?
insert, update, delete
click to copy

DBMS → Database Architecture 3

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
Triggers                  enabled or disabled
can be
click to copy

DBMS → Data Models 3

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
Which prefixes are available to Oracle triggers?
both :new and : old
click to copy

DBMS → ER Model 3

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
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

DBMS → Relational Model 2

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 2

             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 2

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 2

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

Which of the following is the right syntax for the assertion?
create assertion ‘assertion-name’ check ‘predicate’;
click to copy
Which of the following function is used to find the column count of the particular resultset?
getmetadata()
click to copy

DBMS → DML Commands 2

Data integrity constraints are used to:
improve the quality of data entered for a specific property (i.e., table column)
click to copy
Which of the following is used as the embedded SQL in COBOL?
exec sql <embedded sql statement > end-exec
click to copy

DBMS → Joins 2

Dates must be specified in the format
yyyy/mm/dd
click to copy
Which of the following is used to distinguish the variables in SQL from the host language variables?
–
click to copy

DBMS → Views 2

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
Which of the following is used to access large objects from a database ?
all of the mentioned
click to copy

DBMS → Indexes 2

Which of the following is used to store movie and image files?
blob
click to copy
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

DBMS → Transactions 2

The user defined data type can be created using
create type
click to copy
Triggers are supported in
views
click to copy

DBMS → Concurrency Control 2

Values of one type can be converted to another domain using which of the following?
cast
click to copy
What are the after triggers?
these triggers run after an insert, update or delete on a table
click to copy

DBMS → Deadlock 2

Which of the following closely resembles Create view?
create table . . . as
click to copy
The variables in the triggers are declared using
@
click to copy

DBMS → Database Security 2

In contemporary databases, the top level of the hierarchy consists of              each of which can contain            
catalogs, schemas
click to copy
The default extension for an Oracle SQL*Plus file is:
.sql
click to copy

DBMS → PL/SQL 2

The database administrator who authorizes all the new users, modifies the database and takes grants privilege is
all of the mentioned
click to copy
Which of the following is NOT an Oracle- supported trigger?
during
click to copy