多选题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 PARTITIONFALTER TABLE MOVE PARTITION
多选题
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
参考解析
解析：
暂无解析
相关考题：
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
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
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.
Which three operations can be performed as multipartition operations in Oracle?() A. Merge partitions of a list partitioned tableB. Drop partitions of a list partitioned tableC. Coalesce partitions of a hash-partitioned global index.D. Move partitions of a range-partitioned tableE. Rename partitions of a range partitioned tableF. Merge partitions of a reference partitioned index
Which two partitioned table maintenance operations support asynchronous Global Index Maintenance inOracle database 12c?() A. ALTER TABLE SPLIT PARTITIONB. ALTER TABLE MERGE PARTITIONC. ALTER TABLE TRUNCATE PARTITIOND. ALTER TABLE ADD PARTITIONE. ALTER TABLE DROP PARTITIONF. ALTER TABLE MOVE PARTITION
Which statement best describes what Cisco Smart Care Service provides?（）A、bundled technical support and maintenance for Cisco networksB、bundled, unlimited support with the purchase of any Cisco productC、technical support, maintenance, and monitoring to Cisco networksD、fee-based add-on support and tech-to-tech assistance for Cisco products
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.
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 teardownB、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 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.
Which two partitioned table maintenance operations support asynchronous Global Index Maintenance inOracle database 12c?（）A、ALTER TABLE SPLIT PARTITIONB、ALTER TABLE MERGE PARTITIONC、ALTER TABLE TRUNCATE PARTITIOND、ALTER TABLE ADD PARTITIONE、ALTER TABLE DROP PARTITIONF、ALTER TABLE MOVE PARTITION
Which two operations can be flashed back using the Flashback technology？（）A、DROP USER SMITH；B、DROP TABLE EMPLOYEES；C、DROP TABLESPACE USERS；D、ALTER TABLE SALES_REP DROP PARTITION P1；E、ALTER TABLE EMPLOYEES DROP COLUMN DESIG_ID；
Which two operations can be performed on an external table（）A、Create a view on the table.B、Create an index on the table.C、Create a synonym on the table.D、Add a virtual column to the table.E、Update the table using the UPDATE statement.F、Delete rows in the table using the DELETE command.
Your database is in NOARCHIVELOG mode. After which two operations you should take the backup of control file？（）A、adding a new user to the databaseB、dropping a user from the databaseC、dropping a table from the databaseD、dropping a data file from a tablespaceE、adding a new tablespace to the database
Which three operations can be performed as multipartition operations in Oracle?（）A、Merge partitions of a list partitioned tableB、Drop partitions of a list partitioned tableC、Coalesce partitions of a hash-partitioned global index.D、Move partitions of a range-partitioned tableE、Rename partitions of a range partitioned tableF、Merge partitions of a reference partitioned index
Which three statements are characteristic of the MEMORY storage engine?（）A、It can support transactionsB、Table contents are not saved if the server is restartedC、It cannot contain text or BLOB columnsD、It can support foreign keysE、Each table is represented on disk as an.frm fileF、Each table has a corresponding.MYI and .MYD file
多选题Your database is in NOARCHIVELOG mode. After which two operations you should take the backup of control file？（）Aadding a new user to the databaseBdropping a user from the databaseCdropping a table from the databaseDdropping a data file from a tablespaceEadding a new tablespace to the database
单选题You executed the following SQL statement to shrink the EMPLOYEES table segment stored in the EXAMPLE tablespace: ALTER TABLE employees SHRINK SPACE CASCADE; Which statement is correct in this scenario?（）AThe EMPLOYEES table will be changed to read-only mode during the shrink operation.BThe indexes created on the EMPLOYEES table will need to be rebuilt after the shrink operation is over.CThe shrink behavior will be cascaded to all dependent segments of the table that support a shrink operation.DData manipulation language (DML) operations will not be possible on the EMPLOYEES table during the COMPACTION phase of the shrink operation.
多选题Which two statements are true about simple views？（）AViews can be created as read only.BViews are data segments like tables.CViews can be created on the basis of more than one table.DData manipulation language （DML） operations cannot be performed on views.
多选题Which two of the following options are categories of Network Maintenance tasks？（）AFirefightingBInterrupt-drivenCPolicy-basedDStructuredEFoundational
多选题A warehouse fact table in your Oracle 12c Database is range-partitioned by month and accessed frequently with queries that span multiple partitions The table has a local prefixed, range partitioned index. Some of these queries access very few rows in some partitions and all the rows in other partitions, but these queries still perform a full scan for all accessed partitions. This commonly occurs when the range of dates begins at the end of a month or ends close to the start of a month. You want an execution plan to be generated that uses indexed access when only a few rows are accessed from a segment, while still allowing full scans for segments where many rows are returned. Which three methods could transparently help to achieve this result?（）AUsing a partial local Index on the warehouse fact table month column with indexing disabled to the table partitions that return most of their rows to the queries.BUsing a partial local Index on the warehouse fact table month column with indexing disabled for the table partitions that return a few rows to the queries.CUsing a partitioned view that does a UNION ALL query on the partitions of the warehouse fact table, which retains the existing local partitioned column.DConverting the partitioned table to a partitioned view that does a UNION ALL query on the monthly tables, which retains the existing local partitioned columnEUsing a partial global index on the warehouse fact table month column with indexing disabling for the table partitions that return most of their rows to the queries.FUsing a partial global index on the warehouse fact table month column with indexing disabled for the table partitions that return a few rows to the queries.
单选题You are a professional level SQL Sever 2008 Database Administrator in an international corporation named Wiikigo. You are experienced in managing databases in an enterprise-level organization, optimizing and sustaining the database life cycle. In the company, your job is to implement solutions on security, troubleshooting, deployment and optimization. A SQL Server 2008 infrastructure is managed by you. A maintenance strategy should be designed for a mission-critical database, and a large table named Orders is contained by the database. Index maintenance operations are contained in the design plan. When you design the strategy, the facts listed below should be taken into consideration. First, the users continuously access to the Orders table in the database. Secondly, a column of the xml data type is contained by Orders table. Thirdly, the new rows are regularly added to the Orders table. Fourthly, the average fragmentation for the clustered index of the Orders table is no more than 2 percent. A strategy should be designed to have the performance of the queries on the table optimized. Which action will you perform?（）AThe clustered index of the Orders table should be dropped.BThe clustered index of the Orders table offline should be rebuilt once a month.CThe clustered index of the Orders table should be excluded from scheduled reorganizing or rebuilding operations.DThe clustered index of the Orders table should be reorganized by reducing the fill factor.
单选题Which statement describes the distributed call control model in VoIP networks？（）AThe gateway voice-capable device is configured to support call control directly performing call setup， call maintenance， and call teardownBThe gateway voice-capable device has a local call routing table configured through a routing protocol.CThe gateway voice-capable device relies on a call agent to support call control.DThe gateway voice-capable device relies on a gatekeeper to support call setup， call maintenance， and call teardown.
多选题Which two operations can be performed on an external table（）ACreate a view on the table.BCreate an index on the table.CCreate a synonym on the table.DAdd a virtual column to the table.EUpdate the table using the UPDATE statement.FDelete rows in the table using the DELETE command.
多选题Which two operations can be performed on an external table（）ACreate a view on the table.BCreate an index on the table.CCreate a synonym on the table.DAdd a virtual column to the table.EUpdate the table using the UPDATE statement.FDelete rows in the table using the DELETE command
单选题You executed the following SQL statement to shrink the EMPLOYEES table segment stored in the EXAMPLE tablespace: ALTER TABLE employees SHRINK SPACE CASCADE; Which statement is correct in this scenario?（）AThe data in the segment will be compacted but the high water mark will not be adjusted BThe EMPLOYEES table will be changed to read-only mode during the shrink operation CThe indexes created on the EMPLOYEES table will need to be rebuilt after the shrink operation is overDThe shrink behavior will be cascaded to all dependent segments of the table that support a shrink operation EData manipulation language (DML) operations will not be possible on the EMPLOYEES table during the COMPACTION phase of the shrink operation
多选题Which three operations can be performed as multipartition operations in Oracle?（）AMerge partitions of a list partitioned tableBDrop partitions of a list partitioned tableCCoalesce partitions of a hash-partitioned global index.DMove partitions of a range-partitioned tableERename partitions of a range partitioned tableFMerge partitions of a reference partitioned index
多选题Which two operations can be flashed back using the Flashback technology？（）ADROP USER SMITH；BDROP TABLE EMPLOYEES；CDROP TABLESPACE USERS；DALTER TABLE SALES_REP DROP PARTITION P1；EALTER TABLE EMPLOYEES DROP COLUMN DESIG_ID；