The statement： "sear

A. Selection, projection, join

B. Difference, projection, join

C. Selection, intersection, join

D. Intersection, projection, join

E. Difference, projection, product

Examine the description of the MARKS table:SUBJ1 and SUBJ2 indicate the marks obtained by a student in two subjects.Examine this SELECT statement based on the MARKS table:What is the result of the SELECT statement?（）

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

B. The statement returns an error at the SELECT clause.

C. The statement returns an error at the WHERE clause.

D. The statement returns an error at the ORDER BY clause.

● The contractual statement of work (CSOW)

A Must be the same as the proposal statement of work

B Does not identify reporting requirements

C Can be at a different level of detail (i.e. WBS level) than the proposal statement of work

D Identifies the contractor's organizational structure for the project

E All of the above

A. The statement produces an error at line 1.

B. The statement produces an error at line 3.

C. The statement produces an error at line 6.

D. The statement returns the employee name, salary, department ID, and maximum salary earned in the department of the employee for all departments that pay less salary then the maximum salary paid in the company.

E. The statement returns the employee name, salary, department ID, and maximum salary earned in the department of the employee for all employees who earn less than the maximum salary in their department.

A.

B.

C.

D.

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

B. 1

C. 0.00

D. An error statement

听力原文：Each month the cardholder receives a statement from the bank, which lists the details of all the transactions in the month, together with the total amount outstanding.

(4)

A．Each month the cardholder receives a statement and the amount of all the transactions.

B．Each month the bank gives the cardholder a statement showing the total amount outstanding.

C．Each month the bank gives the cardholder a statement showing the compound interest.

D．Each month the bank gives the cardholder a statement showing any minimum amount that needs to be paid.

A. The DESCRIBE DEPT statement displays the structure of the DEPT table.

B. The ROLLBACK statement frees the storage space occupies by the DEPT table.

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

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

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