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

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
What are the after triggers ?
These triggers run after an insert, update or delete on a table
click to copy

DBMS → DML Commands 3

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
Which of the following is NOT an Oracle-supported trigger?
DURING
click to copy

DBMS → Joins 3

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
Which of the following is true concerning triggers?
They have an event, condition, and action.
click to copy

DBMS → Views 3

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

DBMS → Indexes 2

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 2

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 2

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 2

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

Which of the following is NOT VALID is PL/SQL?
NUM1, NUM2 number;
click to copy
Which of the following specifies a boolean expression that must be true for the trigger to fire?
Trigger Restriction
click to copy

DBMS → PL/SQL 2

Which of the following is not correct about an Exception?
Process terminates after completion of error sequence.
click to copy
Which of the following trigger will be executed before modifying each row affected by the triggering statement?
Before Row Trigger
click to copy

DBMS → Introduction to DBMS 2

Which of the following is not correct about User_DefinedExceptions ?
Raised automatically in response to an Oracle error
click to copy
Which of the following is not true in case of triggers?
Triggers accept parameters.
click to copy

DBMS → Database Architecture 2

A Stored Procedure is a
All of the above
click to copy
A database is divided into logical storage units called as
Tablespaces
click to copy

DBMS → Data Models 2

Which of the following statement is false?
Oracle checks Uniqueness of User defined errors.
click to copy
A file used to govern the initialization of the instance is known as
Parameter file
click to copy

DBMS → ER Model 2

Find the ODD one out of the following:
INSERT
click to copy
SGA stands for
System Global Area
click to copy

DBMS → Relational Model 2

Which of the following is a cursor operation?
All of the above
click to copy
This statement fails when executed: CREATE OR REPLACE TRI GGER CALC_TEAM_AVG AFTER I NSERT ON PLAYER BEGIN INSERT INTO PLAYER_BATSTAT ( PLAYER_I D, SEASON_YEAR, AT_BATS, HI TS) VALUES ( : NEW. I D, 1 997, 0, 0) ; END; To which type must you convert the trigger to correct the error?
Row
click to copy

DBMS → Normalization 2

Which of the following is not an executable statement?
DECLARE
click to copy
The OLD and NEW qualifiers can be used in which type of trigger?
Row level DML trigger
click to copy

DBMS → Functional Dependency 2

Which of the following is the clause that makes a singleton SELECT different from the normal SELECT?
INTO
click to copy
Trigger are not supported in
Views
click to copy

DBMS → SQL Basics 2

How many attributes are associated with cursors?
4
click to copy
The CREATE TRIGGER statement is used to create the trigger. THE _____ clause specifies the table name on which the trigger is to be attached. The ______ specifies that this is an AFTERINSERT trigger.
On, for insert
click to copy