搜题

【多选题】

Evaluate the following statements:<br /> <img src="https://nimg.ppkao.com/2018-08/yiyu/201808020932369103.jpg?sign=05ef9e6ed9606a5f9c27c622ca712122&t=62d1b218" /><br /> What are the two consequences of the above statements?（）

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.

查看正确答案

更多“ Evaluate the following statements:<br /> <img src="https://nimg.ppkao.com/2018-08/yiyu/201808020932369103.jpg?sign=05ef9e6ed9606a5f9c27c622ca712122&t=62d1b218" /><br /> What are the two consequences of the above statements?（）”相关的问题

第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.

点击查看答案

账号：登录

答题记录

我的收藏

我的题库

客服

TOP

请使用微信扫码支付

订单号：
遇到问题请联系在线客服