AOL

BOL

DOL

Heap

Intermediate level

Header level

Data level

Binary level

31

32

225

2065

Primary key constraint

Check constraint

Foreign key constraint

Unique constraint

View

Index

Default

Extended stored procedure

DELETE statements only.

INSERT statements only.

UPDATE statements only.

UPDATE, DELETE, INSERT and SELECT statements.

Have

The statement will produce error.

day.

Missing parameter

allow updates to system tables

locking

Setup

no of lock

First string

Second string

Start position

End position

Datafile

Device

Data Object

Material

Blank removed Column_name1, first 5 character of column_name2,2 to 4 character part of string from Column_name3

Blank removed Column_name1, last 5 character of column_name2,2 to 4 character part of string from Column_name3

Blank removed Column_name1, first 5 character of column_name2 and 2,3,4,5 character part of string from Column_name3

None of the above

1

3

2

None of the above

End case

When

then

None of the above

Current_date

Datachange

Gettime

Convert

Sensitive

Forward

Fetch

Position

True

False

Their name must begin with @

They are local to the batch or stored procedure where they are declared

They can be declared in a select statement

They cannot have a datatype of text or image

250

255

2065

1026

True

False

Index

Page allocation

Trigger creation

None of the above