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 → Indexes 3

The subset of super key is a candidate key under what condition ?
Subset is a super key
click to copy
Dedicated server configuration is
One server process – One user process
click to copy
Which of the following trigger is executed once for each row in a transaction?
Row-level Triggers
click to copy

DBMS → Transactions 3

Which one of the following attribute can be taken as a primary key ?
Department
click to copy
Which of the following does not affect the size of the SGA?
Stored procedure
click to copy
Which of the following is the default trigger that is created using the CREATE TRIGGER command?
Statement level Trigger
click to copy

DBMS → Concurrency Control 3

Which one of the following cannot be taken as a primary key ?
Street
click to copy
What does a COMMIT statement do to a CURSOR?
None of the above
click to copy
Which of the following command is used to delete a trigger?
DROP TRIGGER
click to copy

DBMS → Deadlock 3

A attribute in a relation is a foreign key if the _______ key from one relation is used as an attribute in that relation .
Sub
click to copy
Which of the following is TRUE? (1) Host variables are declared anywhere in the program (2) Host variables are declared in the DECLARE section
Only 2 is TRUE
click to copy
What is the name of a trigger that initiates another trigger?
Cascading Trigger
click to copy

DBMS → Database Security 2

The relation with the attribute which is the primary key is referenced in another relation. The relation which has the attribute as primary key is called
Referenced relation
click to copy
Which of the following is NOT VALID is PL/SQL?
NUM1, NUM2 number;
click to copy

DBMS → PL/SQL 2

The ______ is the one in which the primary key of one relation is used as a normal Attribute in another relation .
Referencing relation
click to copy
Which of the following is not correct about an Exception?
Process terminates after completion of error sequence.
click to copy

DBMS → Introduction to DBMS 2

Relations produced from an E-R model will always be in:
Third normal form
click to copy
Which of the following is not correct about User_DefinedExceptions ?
Raised automatically in response to an Oracle error
click to copy

DBMS → Database Architecture 2

In ER model the details of the entities are hidden from the user. This process is called:
Abstraction
click to copy
A Stored Procedure is a
All of the above
click to copy

DBMS → Data Models 2

‘AS’ clause is used in SQL for
Rename operation.
click to copy
Which of the following statement is false?
Oracle checks Uniqueness of User defined errors.
click to copy

DBMS → ER Model 2

ODBC stands for
Open Database Connectivity
click to copy
Find the ODD one out of the following:
INSERT
click to copy

DBMS → Relational Model 2

In a Hierarchical model records are organized as
Tree.
click to copy
Which of the following is a cursor operation?
All of the above
click to copy

DBMS → Normalization 2

In an E-R diagram attributes are represented by
ellipse
click to copy
Which of the following is not an executable statement?
DECLARE
click to copy

DBMS → Functional Dependency 2

In case of entity integrity, the primary key may be
not Null
click to copy
Which of the following is the clause that makes a singleton SELECT different from the normal SELECT?
INTO
click to copy

DBMS → SQL Basics 2

The language used in application programs to request data from the DBMS is referred to as the
DML
click to copy
How many attributes are associated with cursors?
4
click to copy

DBMS → DDL Commands 2

Related fields in a database are grouped to form a
data record.
click to copy
Which of the following attribute of implicit cursor always evaluates to false?
%OPEN
click to copy

DBMS → DML Commands 2

The language which has recently become the defacto standard for interfacing application programs with relational database system is
SQL.
click to copy
Which of the following can be used to supplement declarative referential integrity, to enforce complex business rules or to audit changes to data?
Triggers
click to copy

DBMS → Joins 2

Transaction ends
When it is Committed or Rolledback
click to copy
Which of the following can initiate a trigger?
All of the above
click to copy

DBMS → Views 2

A Database Procedure is stored in the Database
Both A & B
click to copy
Which of the following SQL standard support triggers?
SQL-3
click to copy