The two statements produce identical results.

The second statement returns a syntax error.

There is no need to specify DESC because the results are sorted in descending order by default.

The two statements can be made to produce identical results by adding a column alias for the salary column in the second SQL statement.

SELECT TO_DATE(SYSDATE, 'FMDAY, DD Month, YYYY') FROM dual;

SELECT TO_CHAR(SYSDATE, 'FMDD, DY Month, 'YYY') FROM dual;

SELECT TO_CHAR(SYSDATE, 'FMDay, DD Month, YYYY') FROM dual;

SELECT TO_CHAR(SYSDATE, 'FMDY, DDD Month, YYYY') FROM dual;

SELECT TO_DATE(SYSDATE, 'FMDY, DDD Month, YYYY') FROM dual;

SELECT SUBSTR( ‘Hello World’,1) FROM dual;

SELECT INITCAP(TRIM (‘Hello World’, 1,1)) FROM dual;

SELECT LOWER(SUBSTR(‘Hello World’, 1, 1) FROM dual;

SELECT LOWER(SUBSTR(‘Hello World’, 2, 1) FROM dual;

SELECT LOWER(TRIM (‘H’ FROM ‘Hello World’)) FROM dual;

The value displayed in the CALC_VALUE column will be lower.

The value displayed in the CALC_VALUE column will be higher.

There will be no difference in the value displayed in the CALC_VALUE column.

An error will be reported.

Updating

Viewing

Deleting

Inserting

Truncating

/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.

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

The indexed column is declared as NOT NULL.

The indexed columns are used in the FROM clause.

The indexed columns are part of an expression.

The indexed column contains a wide range of values.

ORDER BY SALARY > 5000

GROUP BY SALARY > 5000

HAVING SALARY > 5000

WHERE SALARY > 5000

Must begin with either a number or a letter.

Must be 1-30 characters long.

Should not be an Oracle Server reserved word.

Must contain only A-Z, a-z, 0-+, _, *, and #.

Must contain only A-Z, a-z, 0-9, _, $, and #.

Must begin with a letter.

=

LIKE

BETWEEN

NOT IN

IS

<>

SELECT last_name FROM EMP WHERE last_name LIKE ‘_A%’;

SELECT last_name FROM EMP WHERE last name =’*A%’

SELECT last_name FROM EMP WHERE last name =’_A%’;

SELECT last_name FROM EMP WHERE last name LIKE ‘*A%’

TRIM

REPLACE

TRUNC

TO_DATE

MOD

ALL

BETWEEN...AND

LIKE

OR

IN

EXISTS

UNION

INTERSECT

INSERT

PROMPT

ACCEPT

DEFINE

Exiting from SQL*Plus

System crashing

Issue of GRANT or CREATE command

None of the above

A table name can duplicate the name of any other database object, if not owned by same user.

Table names can contain $,_, and # signs.

Table names are case-sensitive.

Table names begin with a letter.

Table names are not created in Uppercase by default.

CREATE VIEW empl_vu AS SELECT * FROM employee WHERE sal > 10000 WITH READ ONLY;

CREATE VIEW empl_vu AS SELECT * FROM employee WHERE sal > 10000 WITH CHECK OPTION;

CREATE VIEW empl_vu AS SELECT * FROM employee WHERE sal > 10000 WITH CHECK CONSTRAINT;

None of the above

DELETE

SELECT

CREATE TABLE

UPDATE

DROP TABLE

DICTIONARY

TABLE_PRIVILEGES

ALL_VIEWS

USER_OBJECTS