SELECT * FROM Persons WHERE FirstName='Peter' AND LastName='Jackson' ;

SELECT * FROM Persons WHERE FirstName LIKE 'Peter' AND LastName LIKE 'Jackson';

SELECT FirstName='Peter', LastName='Jackson' FROM Persons

SELECT FirstName LIKE 'Peter', LastName LIKE 'Jackson' FROM Persons

SELECT * FROM Persons WHERE LastName>'Hansen' AND LastName

SELECT * FROM Persons WHERE LastName BETWEEN 'Hansen' AND 'Pettersen' ;

SELECT LastName>'Hansen' AND LastName

SELECT LastName LIKE'%Hansen%' AND LastName LIKE '%Pettersen%' FROM Persons ;

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

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

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

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

INSERT INTO Persons ('Olsen') INTO LastName ;

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

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

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

DELETE

TRUNCATE

REMOVE

None of the Above

SELECT Persons.FirstName ;

EXTRACT FirstName FROM Persons ;

SELECT FirstName FROM Persons;

EXTRACT Persons.FirstName

SELECT DIFFERENT

SELECT DISTINCT

SELECT UNIQUE

All of the above

Structured Query Language

Strong Question Language

Structured Question Language

None of the Above

True

False

LONG VARCHAR

BYTEINT

DATE

TIMESTAMP WITH ZONE

Can be the object of an IN or NOT IN clause

Can be the object of EXISTS or NOT EXISTS

Support quantifiers ALL, ANY, SOME

Support LIKE or NOT LIKE used with a

Cannot specify more than one column to match

CREATE

DROP

MODIFY

ALTER

GRANT

REPLACE

SELECT DISTINCT position, manager

SELECT position, manager DISTINCT

SELECT position, manager

SELECT position, DISTINCT manager

SQL*Plus commands cannot be abbreviated.

SQL*Plus commands are accesses from a browser.

SQL*Plus commands are used to manipulate data in tables.

SQL*Plus commands manipulate table definitions in the database.

Insert

update

select

describe

delete

rename

Selection, projection, join

Difference, projection, join

Selection, intersection, join

Intersection, projection, join

Difference, projection, product

The sort is in ascending by order by default

The sort is in descending order by default

The ORDER BY clause must precede the WHERE clause.

The ORDER BY clause is executed on the client side.

The ORDER BY clause comes last in the SELECT statement.

The ORDER BY clause is executed first in the query execution.

updating

viewing

deleting

inserting

truncating

It executes the DELACCOUNT PL/SQL routine.

It runs the DELACCOUNT.SQL script file.

It creates the DELACCOUNT file using the default file extension.

It invokes the editor to edit the contents of the DELACCOUNT file.

Substitution variables

Replacement variables

Prompt variables

Instead-of variables