True

False

SELECT * FROM Persons SORT BY 'FirstName' DESC

SELECT * FROM Persons SORT 'FirstName' DESC

SELECT * FROM Persons ORDER BY FirstName DESC

SELECT * FROM Persons ORDER FirstName DESC

OPEN

EXTRACT

SELECT

GET

UPDATE

MODIFY

SAVE

SAVE AS

ADD NEW

INSERT INTO

ADD RECORD

INSERT NEW

Strong Question Language

Structured Query Language

Structured Question Language

Strong Query Language

SELECT * FROM Persons

SELECT [all] FROM Persons

SELECT Persons

SELECT FROM Persons

SELECT DIFFERENT

SELECT UNIQUE

SELECT DISTINCT

SELECT EXACT

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

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

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

INSERT VALUES ('Jimmy', 'Jackson')

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

INSERT ('Olsen') INTO Persons (LastName)

INSERT INTO Persons ('Olsen') INTO LastName

INSERT INTO Persons ('Olsen')

DELETE ROW FirstName='Peter' FROM Persons

DELETE FROM Persons WHERE FirstName = 'Peter'

DELETE FirstName='Peter' FROM Persons

REMOVE FROM Persons WHERE FirstName = 'Peter'

DELETE

COLLAPSE

REMOVE

ERASE

EXTRACT FirstName FROM Persons

SELECT FirstName FROM Persons

SELECT Persons.FirstName

SELECT * FROM Persons

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

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

SELECT * FROM Persons WHERE FirstName<>'Peter' AND LastName<>'Jackson'

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

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

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

SELECT LastName>'Hansen' AND LastName

SELECT LastName<>'Hansen' AND LastName<>'Pettersen' FROM Persons

CREATE TABLE EMP (empno NUMBER(4), ename VARCHAR2(35), deptno NUMBER(7,2) NOT NULL, CONSTRAINT emp_deptno_fk FOREIGN KEY deptno REFERENCES dept deptno);

CREATE TABLE EMP (empno NUMBER(4), ename VARCHAR2(35), deptno NUMBER(7,2) CONSTRAINT emp_deptno_fk REFERENCES dept (deptno));

CRETE TABLE EM (empno NUMBER(4), ename VARCHAR2(35) deptno NUMBER (7,2) NOT NULL, CONSTRAINT em_deptno_fk REFERENCES dept (deptno) FOREIGN KEY (deptno));

CREATE TABLE EMP (empno NUMBER (4), ename VARCHAR2(35), deptno NUMBER(7,2) FOREIGN KEY CONSTRAINT emp deptno fk REFERENCES dept (deptno));

The DESCRIBE DEPT statement displays the structure of the DEPT table

The ROLLBACK statement frees the storage space occupied by the DEPT table.

The DESCRIBE DEPT statement returns an error ORA-04043: object DEPT does not exist

The DESCRIBE DEPT statement displays the structure of the DEPT table only if there is a COMMIT statement introduced before the ROLLBACK statement.

/SQL * Plus commands cannot be abbreviated

/SQL* Plus commands are accessed from a browser.

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

/SQL* Plus command manipulate table definitions in the database

/SQL* Plus is the Oracle proprietary interface for executing SQL statements.

True

False

Redundancy is controlled

graphical and statistical capabilities

proprietary formats may limit arichival quality of data

Providing multiple user interfaces