GK One-Line Question & Answer

Which of the following specifies a boolean expression that must be true for the trigger to fire?

What is the type of Oracle backup in which all uncommitted changes have been removed from the datafiles?

The DBMS language component which can be embedded in a program is

Which of the following trigger will be executed before modifying each row affected by the triggering statement?

Which of the following is true concerning a procedure?

A DBMS query language is designed to

Which of the following is not true in case of triggers?

A CASE SQL statement is which of the following?

Which of the following is correct

A database is divided into logical storage units called as

Which of the following statements is true concerning routines and triggers?

Which of the following is a valid SQL type?

A file used to govern the initialization of the instance is known as

How many bytes does each character in the UTF8 encoding take up?

SGA stands for

PL/SQL has two types of subprograms, procedures and functions. Which subprogram isused to compute a value?

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?

Which datatype is not allowed in the definition of PL/SQL record?

The OLD and NEW qualifiers can be used in which type of trigger?

In the SQL Cursor, which attribute is TRUE when a cursor has some remaining rows to fetch, and FALSE when a cursor has no rows left to fetch?

Trigger are not supported in

For which Exception, if a SELECT statement attempts to retrieve data based on its conditions, this exception is raised when no rows satisfy the SELECT criteria?

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.

In the PL/SQL block below, how many rows will be inserted in the messages table? DECLARE v_start_salesNUMBER := 2; v_end_sales NUMBER := 100; BEGIN FOR i IN v_start_sales..v_end_sales LOOP INSERT INTO messages(msgid) VALUES v_start_sales; END LOOP; END;

What are the after triggers ?

Which collection types is also known as index-by tables, lets you look up elements Using arbitrary numbers and strings for subscript values?

Which of the following is NOT an Oracle-supported trigger?

Assigning a value to a collection element can cause exceptions, such as

Which of the following is true concerning triggers?

Which is a procedural extension of Oracle- SQL that offers language constructs similar tothose in imperative programming languages?

Which prefixes are available to Oracle triggers?

Which of the following retains duplicate rows in the result of a query or in an Aggregate expression?

Which type of entity represents a logical generalization whose actual occurrence is represented by a second, associated entity?

Which of the following is an aggregate function in SQL?

Which of the following is the preferred way to recover a database after a transaction in progress terminates abnormally?

Which command is used to add a column to an existing table?

Concurrency control is important for which of the following reasons?

A deadlock exists in the system if and only if the wait for graph:

The transaction log includes which of the following?

Rollback of transactions is normally used to: