0

NULL

Depends on the scale and precision of the datatype.

Without initialization, a variable cannot be used in the executable section of the block.

When you disconnect from your session abnormally

After PL/SQL block is executed successfully

When you issue TRUNCATE command at SQL prompt

When COMMIT command is issued

When each UPDATE statement is executed

If-Then-Else

While loop

GOTO

DECODE

0

8

7

NULL

SQL statements can be on one or more lines.

Keywords cannot be split across lines.

SQL statements are not case-sensitive, unless indicated.

Keywords can be abbreviated.

Place a slash on the last line in the buffer.

You can use arithmetic operators in any clause of a SQL statement.

DROP INDEX

ALTER TABLE ....... DROP PRIMARY KEY CASCADE

ALTER TABLE ....... DROP CONSTRAINT

DROP TABLE

DECLARE V_Destination_India Number;

DECLARE V_123, V_213, V_132 Varchar2(10);

DECLARE V_sys Boolean := 1;

DECLARE V_destination_India Number(4);

DECLARE V_Hiredate NOT NULL DATE := '01-JAN-00';

EXISTS

SUBSTR

TRIM

FLOOR

COUNT

UPPER

To add six new services to the SERVICE table

To change MACHINE_ID 123456 to 456789 and change all others to 900000

To change MACHINE_ID 123456 to 456789

To add new services to the SERVICE table until finished

Parameter has to be used in this cursor to make its execution successful.

Correlated subquery cannot be used in CURSOR declaration.

Correlated FROM clause subquery cannot be used in CURSOR declaration.

AND logical operator cannot be used in WHERE clause of cursor declaration.

No logical error.

Declaration

Execution

Exception

Header

simple

two tier

n tier

client server

TO PRINT

TO COPY

TO CONVERT

TO SEE THE RESULT OF PL/SQL PROGRAMS ON DISPLAY

ASCII

ANSCI

ORACLE

DBMS

2

3

6

12

1

2

3

5

On any DML

On any DDL

On both

On none

Oracle Library Cache

Oracle Parallel Query

Oracle Recovery Manager

Oracle Multithreaded Server

The column is populated by sequence

The column contains many different values

The column is mainly used for value range scans

The columns implementing an inverted list attribute.

Small table rarely retrieved with a full table scan

Large table rarely retrieved with a full table scan

Small table frequently retrieved with a full table scan

Large table frequently retrieved with a full table scan