<=30 characters

<=40 characters

<=32 characters

<=20 characters

True

False

True

False

All matched columns returns NULLS.

All unmatched columns returns NULLS.

All matched and unmatched columns returns NULLS.

Cant say

Functions

Package body

Triggers

Cursor

Foreign Key

Primary Key

Check

Unique

Not Null

drop foreign keys

cascade constraints

this is not possible in oracle

clear references

maximum length for varchar is 2000 bytes and for varchar2 is 4000 bytes

varchar is used to store fixed length character data, varchar2 is for variable length character data

varchar data type is not supported in oracle

varchar is applicable only to PL/SQL

1

2

3

0

4

Primary key access

Access via unique index

Table access by ROWID

Full table scan

8

2

3

4

5

03-JUL-00

10-JUL-00

12-JUL-00

11-JUL-00

17-JUL-00

*

/

-

@

System tablespace

Users tablespace

Default tablespace for the user

Oracle will give an error

Undefined

select * from EMP where nvl(EMPNO, '00000') = '59384'

select * from EMP where EMPNO = '59384'

select EMPNO, LASTNAME from EMP where EMPNO = '59384'

select 1 from EMP where EMPNO = '59834'

INSTR

SUBSTRING

SUBSTR

POS

DROP

DELETE

CASCADE

TRUNCATE

Column

1966_Invoices

Catch_#22

#Invoices

None of the above

Anything Goes

Shared Nothing

Shared Everything

Dual Redundant

5392845.324

871039453.1

97234512.123

1234567.12