INSERT INTO Persons VALUES ('Jimmy', 'Jackson')

INSERT ('Jimmy', 'Jackson') INTO Persons

INSERT VALUES ('Jimmy', 'Jackson') INTO Persons

INSERT ('Jimmy', 'Jackson') INTO Persons

INSERT ('Olsen') INTO Persons (LastName)

INSERT INTO Persons (LastName) VALUES ('Olsen')

INSERT INTO Persons ('Olsen') INTO LastName

INSERT FROM Persons ('Olsen') INTO LastName

UPDATE Persons SET LastName='Hansen' INTO LastName='Nilsen'

UPDATE Persons SET LastName='Nilsen' WHERE LastName='Hansen'

MODIFY Persons SET LastName='Hansen' INTO LastName='Nilsen

MODIFY Persons SET LastName='Nilsen' WHERE LastName='Hansen'

DELETE FROM Persons WHERE FirstName = 'Peter'

DELETE FirstName='Peter' FROM Persons

DELETE ROW FirstName='Peter' FROM Persons

DELETE FROM Persons WHERE FirstName <> 'Peter'

SELECT COUNT() FROM Persons

SELECT COLUMNS() FROM Persons

SELECT COLUMNS(*) FROM Persons

SELECT COUNT(*) FROM Persons

Four

Three

Two

Only one

True

False

QUEST TOAD FOR ORACLE 9

None

SCOOTER SOFTWARE BEYOND COMPARE 3

EMBARCADERO DB ARTISAN 8

True

False

varchar

int

text

binary

Image

SQL Developer

SQLWays

Both a and b

Only a

MYSQL

SQL Server

DB2

Oracle

All of the above/ Any database suggested by client

A procedure that is very small

A procedure being invoked by another procedure

A procedure that is not used by application

System stored procedures

timestamp

varchar

datetime

number

raw

@@trancount

@@rowcount

@@sqlstatus

@@rescount

inserted

updated

deleted

created

Checkpoint (CKPT)

Database Writer (DBWR)

Process Monitor (PMON)

Log Writer (LGWR)

Database Buffer Cache

Shared Pool

Data Dictionary

Redolog Group

Redolog Buffer

Database

Controlfile

Table

Datafile

Index

Redolog Group

Datafile

Controlfile

Redolog Group

Archivelogs

Password File