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.<br /> What is the most efficient method to reclaim the space released by the delete operations in the BOOKINGS table？（）..

第1题

[单选题] 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.

点击查看答案

第2题

[单选题] 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.

点击查看答案

第3题

[] 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.

点击查看答案

第4题

[单选题] 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.

点击查看答案

第5题

[单选题] 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.

点击查看答案

第6题

[] 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

点击查看答案

第7题

[单选题] 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、An error is produced. B、The table and all related objects are compacted and the position of the high-water mark (HWM) for the table is adjusted C、The table and related indexes are compacted but the position of the high-water mark (HWM) for the table remains unchanged 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

点击查看答案

第8题

[单选题] What type of constraint is used to ensure that each row inserted into the EMPLOYEE table with a value in the WORKDEPT column has a row with a corresponding value in the DEPTNO column of the DEPARTMENT table?（）

A、A check constraint on the EMPLOYEE table B、A unique constraint on the EMPLOYEE table WORKDEPT column C、A foreign key reference from the DEPARTMENT tables DEPTNO column to the WORKDEPT column of the EMPLOYEE table D、A foreign key reference from the EMPLOYEE tables WORKDEPT column to the DEPTNO column of the DEPARTMENT table

点击查看答案

第9题

[单选题] Which statement is correct about the forwarding table?（）

A、The forwarding table is stored only on the PFE B、The forwarding table contains all known routes C、The forwarding table is stored on both the RE and PFE D、The forwarding table is stored only on the RE

点击查看答案

请使用微信扫码支付