Evaluate these two SQL statements: SELECT last_name, salary , hire_date FROM EMPLOYEES ORDER BY salary DESC; SELECT last_name, salary, hire_date FROM EMPLOYEES ORDER BY 2 DESC; What is true about them? （）

A .  An ACL can be applied to multiple interlaces. B .  An ACL wildcard mask is identical to an IP subnet mask. C .  There may be multiple ACLs per protocol， per direction， and per interface. D .  There is an "implicit deny" at the end of an ACL and will result in a dropped packet. E .  An ACL acts on all packets， those flowing thru the router and those originated by the router itself. F .  An ACL will be processed from top to bottom and may have multiple matches that will act on the packet that is being tested.

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 . Selection, projection, join B . Difference, projection, join C . Selection, intersection, join D . Intersection, projection, join E . Difference, projection, product

A . The two statements produce identical results. B . The second statement returns a syntax error. C . There is no need to specify DESC because the results are sorted in descending order by default. D . The two statements can be made to produce identical results by adding a column alias for the salary column in the second SQL statement.

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 . 0 B . 1 C . 0.00 D . An error statement

A . The DESCRIBE DEPT statement displays the structure of the DEPT table. B . The ROLLBACK statement frees the storage space occupied 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.

A . The value displayed in the CALC_VALUE column will be lower. B . The value displayed in the CALC_VALUE column will be higher. C . There will be no difference in the value displayed in the CALC_VALUE column. D . An error will be reported.

A .  FREE_SPACE indicates only the space that is currently unallocated. B .  ALLOCATED_SPACE indicates only the space currently allocated and in use. C .  FREE_SPACE indicates only the space that is currently allocated and available for reuse. D .  ALLOCATED_SPACE indicates both the space currently allocated and used，and the space that is available for reuse. E .  FREE_SPACE indicates both the space that is currently allocated and available for reuse，and the space that is currently unallocated.

A . It releases the storage space used by the table. B . It does not release the storage space used by the table. C . You can roll back the deletion of rows after the statement executes. D . You can NOT roll back the deletion of rows after the statement executes. E . An attempt to use DESCRIBE on the DEPT table after the TRUNCATE statement executes will display an error. F . You must be the owner of the table or have DELETE ANY TABLE system privileges to truncate the DEPT table

A . Partitions of PURCHASE_ORDER_ITEMS have system-generated names. B . Both PURCHASE_ORDERS and PURCHASE_ORDER_ITEMS tables are created with four partitions each. C . Partitions of the PURCHASE_ORDER_ITEMS table exist in the same tablespaces as the partitions of the PURCHASE_ORDERS table. D . The PURCHASE_ORDER_ITEMS table inherits the partitioning key from the parent table by automatically duplicating the key columns. E . Partition maintenance operations performed on the PURCHASE_ORDER_ITEMS table are automatically reflected in the PURCHASE_ORDERS table.

A .  （i = = l） B .  （i = = d） C .  （d = = l） D .  （i.equals（d）） E .  （i.equals（i）） F .  （i.equals（42））

A . It forces BasicFiles to be created even if the SECUREFILE option is specified to create the LOB B . It forces SecureFiles to be created even if the BASICFILE option is specified to create the LOB C . It does not allow the creation of SecureFiles and generates an error if the SECUREFILE option is specified to create the LOB D . It ignores the SECUREFILE option only if a Manual Segment Space Management tablespace is used and creates a BasicFile

A .  （i ==1） B .  （i == d） C .  （d == 1） D .  （i.equals （d）） E .  （d.equals （i）） F .  （i.equals （42）

A .  It forces BasicFiles to be created even if the SECUREFILE option is specified to create the LOB B .  It forces SecureFiles to be created even if the BASICFILE option is specified to create the LOB C .  It does not allow the creation of SecureFiles and generates an error if the SECUREFILE option is specified to create the LOB D .  It ignores the SECUREFILE option only if a Manual Segment Space Management tablespace is used and creates a BasicFile

A . FREE_SPACE indicates only the space that is currently unallocated. B . ALLOCATED_SPACE indicates only the space currently allocated and in use. C . FREE_SPACE indicates only the space that is currently allocated and available for reuse. D . ALLOCATED_SPACE indicates both the space currently allocated and used, and the space that is available for reuse. E . FREE_SPACE indicates both the space that is currently allocated and available for reuse, and the space that is currently unallocated.

A . The results are not sorted. B . The results are sorted numerically. C . The results are sorted alphabetically. D . The results are sorted numerically and then alphabetically.

A .  available only in autonomous APs B .  available in autonomous and lightweight APs C .  a feature of WDS in autonomous APs D .  a feature of WDS in lightweight APs E .  requires at least one AP and one Wireless LAN Services Module

A . It executes successfully but partition pruning cannot happen for this partition key. B . It produces an error because the TOTAL_VALUE column cannot be used as a partition key. C . It produces an error because compression cannot be used for the TOTAL_VALUE partition key. D . It executes successfully but the values in the TOTAL_VALUE column would not be physically stored in the partitions.

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.

A . 46 and 45 B . 46 and 45.93 C . 50 and 45.93 D . 50 and 45.9 E . 45 and 45.93 F . 45.95 and 45.93

A . 0 B . 1 C . 0.00 D . An error statement

<img src='https://img2.soutiyun.com/ask/uploadfile/2019-03-27/b0aed9f70f3cf7c71c4d975acbe48082.jpg' /> A. The value displayed in the CALC_VALUE column will be lower. B. The value displayed in the CALC_VALUE column will be higher. C. There will be no difference in the value displayed in the CALC_VALUE column. D. An error will be reported.

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.