Evaluate the following command：   SQL> CREATE TABLE design_data （id NUMBER， doc CLOB）  LOB（doc） STORE AS SECUREFILE（DEDUPLICATE）；   Which statement is true regarding the above command？（）  

A .  They are evaluated by all the three WHEN clauses regardless of the results of the evaluation of any other WHEN clause. B .  They are evaluated by the first WHEN clause. If the condition is true， then the row would be evaluated by the subsequent WHEN clauses. C .  They are evaluated by the first WHEN clause. If the condition is false， then the row would be evaluated by the subsequent WHEN clauses. D .  The INSERT statement would give an error because the ELSE clause is not present for support in case none of the WHEN clauses are true.

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 cached result becomes invalid when any structural change is done to the EMPLOYEES table. B . If the function execution results in an unhandled exception, the exception result is also stored in the cache. C . Each time the function is invoked in a different session, the current result in the result cache gets overwritten. D . If the function is invoked with a different parameter value, the existing result in the result cache gets overwritten by the latest value.

A .  It would be automatically enabled and deferred. B .  It would be automatically enabled and immediate. C .  It would remain disabled and has to be enabled manually using the ALTER TABLE command. D .  It would remain disabled and can be enabled only by dropping the foreign key constraint and re-creating it.

A . 0 B . 1 C . 0.00 D . An error 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 .  It would be automatically enabled and deferred. B .  It would be automatically enabled and immediate. C .  It would remain disabled and has to be enabled manually using the ALTER TABLE command. D .  It would remain disabled and can be enabled only by dropping the foreign key constraint and re-creating it.

A .  FREQ = MONTHLY； BYMONTHDAY = 31 B .  FREQ = MONTHLY； BYMONTHDAY = -1 C .  FREQ = DAILY； BYDAY = -1 D .  FREQ = MONTHLY； BYDAY = 31 E .  FREQ = DAILY； BYMONTHDAY = LAST_DAY

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 .  ${vals.2 } B .  ${vals ["2"]} C .  ${vals.index } D .  ${vals[index]} E .  ${vals} [index] F .  ${vals.（vals.index）} G .  ${vals[vals[index-1]]}

A . （a == "Hello"） B . （a == b） C . （a == c） D . a.equals（b） E . a.equals（d）

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 . 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 .  They are evaluated by all the three WHEN clauses regardless of the results of the evaluation of any other WHEN clause. B .  They are evaluated by the first WHEN clause. If the condition is true， then the row would be evaluated by the subsequent WHEN clauses. C .  They are evaluated by the first WHEN clause. If the condition is false， then the row would be evaluated by the subsequent WHEN clauses. D .  The INSERT statement would give an error because the ELSE clause is not present for support in case none of the WHEN clauses are true.

A . It produces an error because a fully qualified host name needs to be specified. B . It produces an error because the range of ports associated with the hosts has not been specified. C . It creates an access control list (ACL) with the user ACCT_MGR who gets the CONNECT and RESOLVE privileges. D . It creates an access control list (ACL) with the user ACCT_MGR who gets the CONNECT privilege but not the RESOLVE privilege.

A . #!/bin/ksh line is missing B . Variable name VAR is not properly initialized C . Loop variable is not incremented inside the loop D . Loop variable is not decremented inside the loo

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 . The LOB matically compressed. B . The LOB values are cached bvalues are autoy default in the buffer cache. C . The LOB values are automatically stored in encrypted mode. D . All LOB data that is identical in two or more rows in a LOB column share the same data blocks.

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 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．A. Coverage B．B. Interference C．C. Handover parameter D．D. Configuration of adjacent cell