Evaluate the following command:<br /> SQL>ALTER SYSTEM SET db_securefile = 'IGNORE';<br /> What is the impact of this setting on the usage of SecureFiles?（）

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

查看正确答案

更多“ Evaluate the following command:<br /> SQL>ALTER SYSTEM SET db_securefile = 'IGNORE';<br /> What is the impact of this setting on the usage of SecureFiles?（）”相关的问题

第1题

[] Evaluate the following SQL statement used to create the PRODUCTS table: Which statement is true regarding this command?（） Evaluate the following SQL statement used to create the PRODUCTS table: Which statement is true regarding this command?（）

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

点击查看答案

第2题

[单选题] Evaluate the following query: SQL> SELECT TRUNC(ROUND(156.00,-1),-1)FROM DUAL; What would be the outcome?（）

A、16 B、100 C、160 D、200 E、150

点击查看答案

第3题

[单选题] Evaluate the following command: Which statement is true regarding the above command?（）

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.

点击查看答案

第4题

[单选题] Which of the following calendaring syntax expressions would evaluate to the last day of every month?（）

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

点击查看答案

第5题

[单选题] During system startup, many applications are starting that are not needed. Which of the following can be used to evaluate all startup applications?（）

A、Computer Management Utility B、Add/Remove Programs C、Autoexec.bat file D、MSCONFIG

点击查看答案

第6题

[单选题] Evaluate the following function code: Which statement is true regarding the above function? （）

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.

点击查看答案

第7题

[] Evaluate the set of SQL statements: What is true about the set?（） Evaluate the set of SQL statements: What is true about the set?（）

A、A. The DESCRIBE DEPT statement displays the structure of the DEPT table. B、B. The ROLLBACK statement frees the storage space occupies by the DEPT table. C、C. The DESCRIBE DEPT statement returns an error ORA-04043: object DEPT does not exist. D、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 owner or Master of a towing vessel shall ensure that each person that directs and controls the movement of the vessel can accomplish all of the following EXCEPT（）.

A、evaluate the danger of each closing visual or radar contact B、adjust speed with due regard for the weather and visibility C、reduce speed only where local speed limits are posted D、enter all required test and inspection results in the vessel's log or other record carried on board

点击查看答案

第9题

[单选题] Evaluate the following block of code: What is the outcome of the above code?（）

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.

点击查看答案

第10题

[] Examine the data from the ORDERS and CUSTOMERS tables. Evaluate the SQL statement: What is the result when the query is executed?（） Examine the data from the ORDERS and CUSTOMERS tables. Evaluate the SQL statement: What is the result when the query is executed?（）

A、A.
B.
C.
D. The query fails because the subquery returns more than one row.
E. The query fails because the outer query and the inner query are using different tables.