The INV_HISTORY table is created using the command: <img src="https://img.ppkao.com/2018-08/yiyu/2018080211173960655.jpg" /> You would like to store the data belonging to the year 2006 in a single partition and issue the command: <img src="https://img.ppkao.com/2018-08/yiyu/2018080211173260613.jpg" /> What would be the outcome of this command? （） The INV_HISTORY table is created using the command: <img src="https://img.ppkao.com/2018-08/yiyu/2018080211173960655.jpg" /> You would like to store the data belonging to the year 2006 in a single partition and issue the command: <img src="https://img.ppkao.com/2018-08/yiyu/2018080211173260613.jpg" /> What would be the outcome of this command? （）..

第1题

[单选题] The INV_HISTORY table is created using the command： SQL>CREATE TABLE INV_HISTORY （inv_no NUMBER（3）， inv_date DATE， inv_amt NUMBER（10，2）） partition by range （inv_date） interval （numtoyminterval（1，’month’））（partition p0 values less than （to_date（’01-01-2005’，’dd-mm-yyyy’））， partition p1 values less than （to_date（’01-01-2006’，’dd-mm-yyyy’）））； The following data has been inserted into the INV_HISTORY table ： INV_NO INV_DATE INV_AMT 1 30-dec-2004 1000 2 30-dec-2005 2000 3 1-feb-2006 3000 4 1-mar-2006 4000 5 1-apr-2006 5000 You would like to&en

A、 It executes successfully，and the transition point is set to ’1-apr-2006’. B、 It executes successfully，and the transition point is set to ’15-apr-2006’. C、 It produces an error because the partitions specified for merging are not adjacent. D、 It produces an error because the date values specified in the merge do not match the date values stored in the table.

点击查看答案

第2题

[单选题] What is the result of executing a TRUNCATE TABLE command on a table that has Flashback Archivingenabled?（）

A、It fails with the ORA-665610 Invalid DDL statement on history-tracked message B、The rows in the table are truncated without being archived. C、The rows in the table are archived, and then truncated. D、The rows in both the table and the archive are truncated.

点击查看答案

第3题

[单选题] In what location are EIGRP successor routes stored?（）

A、In the routing table only. B、In the neighbor table only. C、In the topology table only. D、In the routing table and neighbor table. E、In the routing table and topology table. F、In the topology table and neighbor table.

点击查看答案

第4题

[单选题] You enabled Flashback Data Archive on the INVENTORY table.Which DDL operation is supported on the table after enabling Flashback Data Archive?（）

A、Drop the table. B、Partition the table C、Truncate the table. D、Add a column to the table. E、Rename a column in the table.

点击查看答案

第5题

[] Examine the following commands for redefining a table with Virtual Private Database (VPD) policies: Which two statements are true about redefining the table?（） Examine the following commands for redefining a table with Virtual Private Database (VPD) policies: Which two statements are true about redefining the table?（）

A、A. All the triggers for the table are disabled without changing any of the column names or column types in the table. B、B. The primary key constraint on the EMPLOYEES table is disabled during redefinition. C、C. VPD policies are copied from the original table to the new table during online redefinition. D、D. You must copy the VPD policies manually from the original table to the new table during online redefinition.

点击查看答案

第6题

[单选题] The BOOKINGS table contains online booking information. When a booking is confirmed, the details are transferred to an archival table BOOKINGS_HIST and deleted from the BOOKINGS table. There is no fixed time interval between each online booking and its confirmation. Because sufficient space is not always available from the delete operations the high-water mark (HWM) is moved up and many rows are inserted below the HWM of the table. The BOOKINGS table has Automatic Segment Space Management (ASSM) and row movement enabled. The table is accessible in 24x7 mode. What is the most efficient method to reclaim the space released by the delete operations in the BOOKINGS table？（）

A、Perform EXPORT, DROP, and IMPORT operations on the BOOKINGS table sequentially B、Shrink the BOOKINGS table by using the ALTER TABLE SHRINK SPACE command C、Move the BOOKINGS table to a different location by using the ALTER TABLE MOVE command D、Deallocate the space in the BOOKINGS table by using the ALTER TABLE DEALLOCATE UNUSED command

点击查看答案

第7题

[单选题] You discover that your Recycle Bin contains two tables with the same name, MY_TABLE. You also have a table named MY_TABLE in your schema. You execute the following statement: FLASHBACK TABLE my_table TO BEFORE DROP RENAME TO my_table2; What will be the result of executing this statement?（）

A、One of the tables is recovered from the Recycle Bin using a First In First Out (FIFO) approach. B、One of the tables is recovered from the Recycle Bin using a Last In First Out (LIFO) approach. C、Both the tables are recovered from the Recycle Bin with one table renamed to MY_TABLE2 and the other to a system-generated name. D、None of the tables are recovered from the Recycle Bin, and the statement returns an error.

点击查看答案

第8题

[单选题] You discover that your Recycle Bin contains two tables with the same name, MY_TABLE. You also have a table named MY_TABLE in your schema.You execute the following statement: FLASHBACK TABLE my_table TO BEFORE DROP RENAME TO my_table2; What will be the result of executing this statement?（）

A、One of the tables is recovered from the Recycle Bin using a First In First Out (FIFO) approach. B、One of the tables is recovered from the Recycle Bin using a Last In First Out (LIFO) approach. C、Both the tables are recovered from the Recycle Bin with one table renamed to MY_TABLE2 and the other to a system-generated name. D、None of the tables are recovered from the Recycle Bin, and the statement returns an error.

点击查看答案

第9题

[] View the exhibit and examine the TRANS table's storage information. After a massive delete operation, you executed the following statement to shrink the TRANS table: SQL> ALTER TABLE trans SHRINK SPACE CASCADE; Which statement describes the outcome of the command?（） View the exhibit and examine the TRANS table's storage information. After a massive delete operation, you executed the following statement to shrink the TRANS table: SQL> ALTER TABLE trans SHRINK SPACE CASCADE; Which statement describes the outcome of the command?（）

A、A. An error is produced. B、B. The table and all related objects are compacted and the position of the high-water mark (HWM) for the table is adjusted C、C. The table and related indexes are compacted but the position of the high-water mark (HWM) for the table remains unchanged D、D. The unused space in the table is reclaimed and returned to the tablespace and the data manipulation language (DML) triggers on the table are fired during the shrinking process

点击查看答案

请使用微信扫码支付