What does the TRUNCATE statement do?()
第1题:
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.
第2题:
A. 0
B. 1
C. 0.00
D. An error statement
第3题:
● 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
第4题:
第5题:
Click the Exhibit button and examine the data in the EMPLOYEES table.Examine the subquery: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.
第6题:
A. It fails with the ORA-665610 Invalid DDL statement on history-tracked message
B. The rows in the table are truncated without being archived.
C. The rows in the table are archived, and then truncated.
D. The rows in both the table and the archive are truncated.
第7题:
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.
第8题:
The EMPLOYEES table contains these columns:You need to write a query that will produce these results:1. Display the salary multiplied by the commission_pct.2. Exclude employees with a zero commission_pct.3. Display a zero for employees with a null commission value.Evaluate the SQL statement:What does the statement provide?()
A. All of the desired results
B. Two of the desired results
C. One of the desired results
D. An error statement
第9题:
第10题:
After applying the policy-rematch statement under the security policies stanza, what would happen to an existing flow if the policy source address or the destination address is changed and committed?()