Returns current date

Generate the access plan

Suggests performance hints that can be implemented

Drop and create the stored procedure

Attributes and Fields

Fields and Records

Records and Fields

Fields and Attributes

TO_CHAR

TO_DATE

MAX

LPAD

A special way of selecting data

The process of adding primary key to a table

The process of arranging information stored in a database in a way, which removes redundancy and ambiguity.

A special way of retrieving data

Rollback

Rollup

CUBE

Commit

abc%

%abc_

%abc

%abc%

Rollup

Rollback

CUBE

Commit

Rollup

Rollback

CUBE

I and III both

NUMBER

LONG

VARCHAR2

RAW

1 , 1 and 1

0 , 1 and 0

1 , 0 and -1

0 , 0 and -1

NUMBER is the subtype of INTEGER data type

PLS_INTEGER is the subtype of BINARY_INTEGER

POSITIVE data type is defined in SYS package.

None of the above.

Only nested tables need initilization.

Index-by tables is a persistent collection

nested tables are known as associative arrays.

VARRAYs hold fixed number of elements

NATURAL

NATURALN

POSITIVE

SIGNTYPE

CURRVAL

LEVEL

ROWNUM

COUNT

True

False

NVL

NULLIF

DECODE

COALESCE

ALTER TABLE DROP COLUMN

ALTER TABLE DROP CONSTRAINT

ALTER TABLE DISABLE CONSTRAINT

-

TABLE

VARCHAR2

SEQUENCE

INDEX

an XML file

a Web Page

an excel template

a text file

CONNECT

RENAME

INSERT

DELETE