COMMIT

MERGE

UPDATE

DELETE

CREATE

DROP

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-9, _, *, and #

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

Must begin with a letter

SELECT ename, salary*12 'Annual Salary' FROM employees;

SELECT ename, salary*12 "Annual Salary" FROM employees;

SELECT ename, salary*12 AS Annual Salary FROM employees;

SELECT ename, salary*12 AS INITCAP("ANNUAL SALARY") FROM employees

=

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

CASE

WHERE

HAVING

RESTRICT

GROUP BY

ORDER BY

INSERT

UPDATE

SELECT

DESCRIBE

DELETE

RENAME

create groups of data

sort data in a specific order

convert data to a different format

Retrieve data based on an unknown condition

Removes the table

Removes all rows from a table

shortens the table to 10 rows

Removes all columns from a table

Removes foreign keys from a table

"&"

ACCEPT

PROMPT

"&&"

A.A view can be created as read only

B.A view can be created as a join on two or more tables.

C.A view cannot have an ORDER BY clause in the SELECT statement

D.A view cannot be created with a GROUP BY clause in the SELECT statement

E.A view must have aliases defined for the column names in the SELECT statement

SELECT last_name, 12*salary*commission_pct FROM emp;

SELECT last_name, 12*salary* (commission_pct,0) FROM emp;

SELECT last_name, 12*salary*(nvl(commission_pct,0)) FROM emp

SELECT last_name, 12*salary*(decode(commission_pct,0)) FROM emp;

SUM(start_date)

AVG(start_date)

COUNT(start_date)

AVG(start_date, end_date)

MIN(start_date)

MAXIMUM(start_date)

0

1

0.00

An error statement

The statement executes successfully and returns the student ID and sum of all marks for each student who obtained more than the average mark in each subject.

The statement returns an error at the SELECT clause.

The statement returns an error at the WHERE clause.

The statement returns an error at the ORDER BY clause.

SELECT TO_CHAR(2000, '$#,###.##') FROM dual;

SELECT TO_CHAR(2000, '$0,000.00') FROM dual;

SELECT TO_CHAR(2000, '$9,999.00') FROM dual;

SELECT TO_CHAR(2000, '$9,999.99') FROM dual;

SELECT TO_CHAR(2000, '$2,000.00') FROM dual;

SELECT TO_CHAR(2000, '$N,NNN.NN') FROM dual;

The underlying tables must have data.

You need SELECT privileges on the view.

The underlying tables must be in the same schema.

You need SELECT privileges only on the underlying tables.

SELECT ENAME FROM EMP WHERE SYSDATE-HIRE_DATE > 5;

SELECT ENAME FROM EMP WHERE HIRE_DATE-SYSDATE > 5;

SELECT ENAME FROM EMP WHERE (SYSDATE-HIRE_DATE)/365 > 5;

SELECT ENAME FROM EMP WHERE (SYSDATE-HIRE_DATE)* 365 > 5;

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.