Interview Questions

Instance is an object not an attribute

A database trigger is procedural code that is automatically executed in response to certain events on a particular table or view in a database. The trigger is mostly used for maintaining the integrity of the information on the database.

Syntax:

CREATE OR REPLACE TRIGGER [Trigger Name] [Before / After / Instead Of]

ON [schema].[table]

<PL/SQL subprogram>

Types of PL/SQL triggers : 

> Row trigger          - The trigger fires for each ROW affected.

> Statement trigger - The trigger is fired once when the condition is matched

> Before and After trigger - The BEFORE trigger run the trigger action before the insert, update or delete statement. The AFTER trigger runs the trigger action after the insert, update or delete statement is executes.

It is the folder that contains web applications. The folder that has been published as virtual folder by IIS can only contain web applications

True, the given statement that xml preserves white spaces is correct.

No. The mode is specified via the SYSCTL DD card in the JCL.

$_SERVER and $_ENV arrays contain different information. The information depends on the server and operating system being used. Most of the information can be seen of an array for a particular server and operating system. The syntax is as follows:

foreach($_SERVER as $key =>$value)

{ echo “Key=$key, Value=$value\n”; }

1)Divide by zero        – This is raised when any number is attempted to divide by zero.

2)TOO MANY ROWS   - A SELECT INTO statement returns more than one row.

3)CASE_NOT_FOUND - No choice in the WHEN clause of a case statement is selected.

4)LOGIN_DENIED      - An attempt to login with an invalid username or password.

5)PROGRAM_ERROR  - An internal PL/SQL problem.