A.listing the employees who earn the same amount of commission as employee 3
B.finding the total commission earned by the employees in department 10
C.finding the number of employees who earn a commission that is higher than the average commission of the company
D.listing the departments whose average commission is more than 600
E.listing the employees who do not earn commission and who are working for department 20 in descending order of the employee ID
F.listing the employees whose annual commission is more than 6000

A.Null values are left out of the sort.
B.Character values are displayed from Z to A
C.Date values are displayed with the earliest value first.
D.Null values are displayed last for descending sequences.
E.Numeric values are displayed with the lowest values first.

A.COMMIT
B.MERGE
C.UPDATE
D.DELETE
E.CREATE
F.DROP...

A.The SELECT statement is syntactically accurate.
B.The SELECT statement does not work because there is no HAVING clause.
C.The SELECT statement does not work because the column specified in the GROUP BY clause is not in the SELECT list.
D.The SELECT statement does not work because the GROUP BY clause should be in the main query and not in the subquery.

A.TRIM
B.REPLACE
C.TRUNC
D.TO_DATE
E.MOD
F.CASE

A.iSQL*Plus commands cannot be abbreviated.
B.iSQL*Plus commands are accessed from a browser.
C.iSQL*Plus commands are used to manipulate data in tables.
D.iSQL*Plus commands manipulate table definitions in the database.
E.iSQL*Plus is the Oracle proprietary interface for executing SQL statements.

A.Both tables have NULL values.
B.You want all unmatched data from one table.
C.You want all matched data from both tables.
D.You want all unmatched data from both tables.
E.One of the tables has more data than the other.
F.You want all matched and unmatched data from only one table.

A.Asinglerowsubquerycanretrieveonlyonecolumnandonerow.
B.Asinglerowsubquerycanretrieveonlyonerowbutmanycolumns.
C.Amultiplerowsubquerycanretrievemultiplerowsandmultiplecolumns.
D.Amultiplerowsubquerycanbecomparedusingthe"；>；"；operator.
E.AsinglerowsubquerycanusetheINoperator.
F.Amultiplerowsubquerycanusethe"；="；operator.

A.USER_CONSTRAINTS
B.USER_OBJECTS
C.ALL_CONSTRAINTS
D.USER_CONS_COLUMNS
E.USER_COLUMNS

A.You cannot roll back this statement.
B.All pending transactions are committed.
C.All views based on the DEPT table are deleted.
D.All indexes based on the DEPT table are dropped.
E.All data in the table is deleted, and the table structure is also deleted.
F.All data in the table is deleted, but the structure of the table is retained.
G.All synonyms based on the DEPT table are deleted.

A.SELECT ename, salary*12 'Annual Salary' FROM employees;
B.SELECT ename, salary*12 "Annual Salary" FROM employees;
C.SELECT ename, salary*12 AS Annual Salary FROM employees;
D.SELECT ename, salary*12 AS INITCAP("ANNUAL SALARY") FROM employees