In no circumstances can more work be got out of a machine than_____.A．be put into itB．is p

ws the monthly commission earned by the employee.Which three tasks would require subqueries or joins in order to be performed in a single step？（）

A.deleting the records of employees who do not earn commission

B.increasing the commission of employee 3 by the average commission earned in department 20

C.finding the number of employees who do NOT earn commission and are working for department 20

D.inserting into the table a new employee 10 who works for department 20 and earns a commission that is equal to the commission earned by employee 3

E.creating a table called COMMISSION that has the same structure and data as the columns EMP_ID and COMMISSION of the EMP table

F.decreasing the commission by 150 for the employees who are working in department 30 and earning a commission of more than 800

5 30 8006 30 2007 108 20 300The COMMISSION column shows the monthly commission earned by the employee. Which three tasks would require subqueries or joins in order to perform in a single step？ （）

A. Deleting the records of employees who do not earn commission.

B. Increasing the commission of employee 3 by the average commission earned in department 20.

C. Finding the number of employees who do NOT earn commission and are working for department 20.

D. Inserting into the table a new employee 10 who works for department 20 and earns a commission that is equal to the commission earned by employee 3.

E. Creating a table called COMMISSION that has the same structure and data as the columns EMP_ID and COMMISSIONS of the EMP table.

F. Decreasing the commission by 150 for the employees who are working in department 30 and earning a commission of more then 800.

ws the monthly commission earned by the employee.Which two tasks would require subqueries or joins in order to be performed in a single step？ （）

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

statement:SELECT *FROM empWHERE emp _ id = 3);WHERE commission = (SELECT commissionFROM empWhat is the result when the query is executed？（）

A. Exhibit A

B. Exhibit B

C. The query returns no rows

D. The query fails because the outer query is retrieving more than one column

E. The query fails because both the inner and outer queries are retrieving data from the same table.

A. An EMP table is created if a table does not exist. Otherwise, if the EMP table is appended with the loaded data.

B. The SQL* Loader data file myfile1.dat has the column names for the EMP table.

C. The SQL* Loader operation fails because no record terminators are specified.

D. Field names should be the first line in the both the SQL* Loader data files.

E. The SQL* Loader operation assumes that the file must be a stream record format file with the normal carriage return string as the record terminator.

A、DELETE * FROM　EMP

B、DELETE FROM　EMP

C、TRUNCATE TABLE　EMP

D、DELETE TABLE　EMP

A. DELETE * FROM. EMP

B. DELETE FROM EMP

C. TRUNCATE TABLE EMP

D. DELETE TABLE EMP"

name=‘JAMES‘; ENAME SAL JAMES 1050QL> UPDATE emp SET sal=sal+sal*1.2 WHERE ename=‘JAMES‘;1 row updated.SQL> SELECT ename, sal FROM emp WHERE ename=‘JAMES‘; ENAME SAL JAMES 2310View the exhibit and examine the Flashback Version Query that was executed after the preceding commands.What could be the possible cause for the query not displaying any row？（）

A. Flashback logging is not enabled for the database.

B. The changes made to the table are not committed.

C. Supplemental logging is not enabled for the database.

D. The database is not configured in ARCHIVELOG mode.

撤销U5对Emp表的查询权限，并收回U5授予其他用户的该权限，SQL语句是(51)。

A．REVOKE SELECT ON TABLE Emp FROM U5 CASCADE；

B．REVOKE SELECT ON TABLE Emp FROM U5 RESTRICT

C．REVOKE QUERY ON TABLE Emp FROM U5 CASCADE；

D．GRANT SELECT ON TABLE Emp TO U5 WITH GRANT OPTION；

A.

B.

C.

D.

E.

F.