多选题Which two partitioned table maintenance operations support asynchronous Global Index Maintenance inOracle database 12c?（）AALTER TABLE SPLIT PARTITIONBALTER TABLE MERGE PARTITIONCALTER TABLE TRUNCATE PARTITIONDALTER TABLE ADD PARTITIONEALTER TABLE DROP

题目

多选题

Which two partitioned table maintenance operations support asynchronous Global Index Maintenance inOracle database 12c?（）

ALTER TABLE SPLIT PARTITION

ALTER TABLE MERGE PARTITION

ALTER TABLE TRUNCATE PARTITION

ALTER TABLE ADD PARTITION

ALTER TABLE DROP PARTITION

ALTER TABLE MOVE PARTITION

参考答案和解析

正确答案： A,C

解析：暂无解析

如果没有搜索结果或未解决您的问题，请直接联系老师获取答案。

相似问题和答案

第1题：

Evaluate the following statements: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.

参考答案：B, C

第2题：

Which two partitioned table maintenance operations support asynchronous Global Index Maintenance inOracle database 12c?()

A. ALTER TABLE SPLIT PARTITION

B. ALTER TABLE MERGE PARTITION

C. ALTER TABLE TRUNCATE PARTITION

D. ALTER TABLE ADD PARTITION

E. ALTER TABLE DROP PARTITION

F. ALTER TABLE MOVE PARTITION

参考答案：C, E

第3题：

Life cycle costing is the total cost to the customer for the acquisition and ownership over its full life. Life cycle costing categories include the cost of _____, _____, and _____.

A . R & D, maintainability, operation and support.

B . R & D, production, operation and support.

C . Acquisition, operations, maintenance.

D . Production, operations, maintenance.

E . None of the above

正确答案：C

第4题：

A DBA has been asked to create a table which will contain a substantial amount of detailed sales information for each calendar month and maintain it to contain only the last 12 months. Which of the following methods will facilitate the online removal of the oldest month’s data?（）

A、Create an MQT that selects the oldest month of data with the REFRESH IMMEDIATE option.
B、Create 12 separate tables, create a view based on all 12, drop the table with the oldest month's data then drop and re- create the view.
C、Create a range partitioned table, partitioned by month, and use the ALTER TABLE statement to detach the oldest month and attach storage for new data.
D、Create a single table, extract the data to be retained using UNLOAD with a SELECT statement, drop and re-create the table then load only the data to be retained.

正确答案:C

第5题：

Which is a restriction on a list partitioned table？（）

A、You cannot create global range partitioned indexes on the table.
B、The optimizer will not execute partition wise joins on the table’s partitions.
C、You must include at least one element in the value list of each partition of the table, even if that element is the keyword NULL.
D、Partition pruning will not occur during query optimizer if a range of values is included in the query predicate.

正确答案:C

第6题：

Which three operations can be performed as multipartition operations in Oracle?()

A. Merge partitions of a list partitioned table

B. Drop partitions of a list partitioned table

C. Coalesce partitions of a hash-partitioned global index.

D. Move partitions of a range-partitioned table

E. Rename partitions of a range partitioned table

F. Merge partitions of a reference partitioned index

参考答案：A, B, F

第7题：

Which statement best describes what Cisco Smart Care Service provides?（）

A、bundled technical support and maintenance for Cisco networks
B、bundled, unlimited support with the purchase of any Cisco product
C、technical support, maintenance, and monitoring to Cisco networks
D、fee-based add-on support and tech-to-tech assistance for Cisco products

正确答案:C

第8题：

74 Life cycle costing is the total cost to the customer for the acquisition and ownership over its full life. Life cycle costing categories include the cost of _____, _____, and _____.

A. R & D, maintainability, operation and support.

B. R & D, production, operation and support.

C. Acquisition, operations, maintenance.

D. Production, operations, maintenance.

E. None of the above

正确答案：B

第9题：

Which statement describes the distributed call control model in VoIP networks？（）

A、The gateway voice-capable device is configured to support call control directly performing call setup， call maintenance， and call teardown
B、The gateway voice-capable device has a local call routing table configured through a routing protocol.
C、The gateway voice-capable device relies on a call agent to support call control.
D、The gateway voice-capable device relies on a gatekeeper to support call setup， call maintenance， and call teardown.

正确答案:A

第10题：

Which two partitioned table maintenance operations support asynchronous Global Index Maintenance inOracle database 12c?（）

A、ALTER TABLE SPLIT PARTITION
B、ALTER TABLE MERGE PARTITION
C、ALTER TABLE TRUNCATE PARTITION
D、ALTER TABLE ADD PARTITION
E、ALTER TABLE DROP PARTITION
F、ALTER TABLE MOVE PARTITION

正确答案:C,E

Which two partitioned table maintenance operations support a

题目

参考答案和解析

相似问题和答案

更多相关问题

相关内容