【C8】A．limitB．chargeC．registrationD．rate

sed later.

A．executable B．input C．output D．assignment

A. in the INTO clause of an INSERT statement

B. in the FROM clause of a SELECT statement

C. in the GROUP BY clause of a SELECT statement

D. in the WHERE clause of a SELECT statement

E. in the SET clause of an UPDATE statement

F. in the VALUES clause of an INSERT statement

A. NLS_LANG

B. NLS_COMP

C. NLS_SORT

D. None of the above

ary FROM department d INNER JOIN employee e ON d.deptno = e.deptnoA database administrator wishes to store this query within the database. Which of the following database objects can be used to accomplish this？（）

A.Alias

B.View

C.Schema

D.Trigger

What is a sub-select statement？

A．a select statement that selects a subset of fields in a table

B．a select statement that returns a subset of the data in a table

C．a select statement that appears within another select statement

D．a select statement that returns a subset of the constraints on a field

An(70) statement can perform. a calculation and store the result in a variable so that it can be used later.

A．executable

B．input

C．output

D．assignment

An(73)statement can perform. a calculation and store the result in a variable so that it can be used later。

A．assignment

B．executable

C．input

D．output

A、Select a topic that interests you.

B、Select a topic that brings something new to your listeners.

C、Select a topic that stays in your “self-caring zone”.

D、You can brainstorm when choosing content.

SELECT last_nameFROM employeesWHERE salary IN (SELECT MAX(salary)FROM employeesGROUP BY department_id);Which statement is true？（）

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.