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 sequentiallyB、Shrink the BOOKINGS table by using the ALTER TABLE SHRINK SPACE commandC、Move the BOOKINGS table to a different location by using the ALTER TABLE MOVE commandD、Deallocate the space in the BOOKINGS table by using the ALTER TABLE DEALLOCATE UNUSED command
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
相关考题:
Which statement is true about a routing table?() A. It contains routes learned dynamically only.B. It finds the best path to each destination by using a modified shortest-path-first calculation.C. It contains only active BGP routes.D. It contains all accepted routes to all destinations.
Which statement is correct about the forwarding table?() A. The forwarding table is stored only on the PFEB. The forwarding table contains all known routesC. The forwarding table is stored on both the RE and PFED. The forwarding table is stored only on the RE
Which statement is true about a forwarding table?() A.It stores a subset of information from the routing table.B.It contains routes learned from all protocols to a destination.C.It provides a database for routes selected and placed into the routing table.D.Every routing protocol maintains its own forwarding table.
A data ( ) is a file that contains metadata - that is, data about data. A .structure B .table C .base D .dictionary
_____ is a file that contains metadata-that is, data about data.A.DocumentB.Excel table]C.Database]D.Data dictionary
Which statement is true about a forwarding table?()A、It stores a subset of information from the routing table.B、It contains routes learned from all protocols to a destination.C、It provides a database for routes selected and placed into the routing table.D、Every routing protocol maintains its own forwarding table.
Which statement is true about the routing table?()A、The routing table exists in the control plane only.B、The routing table exists in the control plane and in the forwarding plane.C、The routing table contains both active and inactive routes.D、The routing table is stored on compact flash.
Which statement is true about a routing table?()A、It contains routers learned dynamically onlyB、It finds the best path to each destination by using a modified shortest-path-first calculationC、It contains only active BGP routesD、It contains all accepted routes to all destinations
Which statement is true about the routing table?()A、The routing table exists in the control plane onlyB、The routing table exists in the control plane and the forwarding planeC、The routing table contains both active and inactive routesD、The routing table is stored on compact flash
Which two statements describe the forwarding table in the Junos OS?()A、The forwarding table contains all known routes.B、The forwarding table stores a subset of information from the routing table.C、Junos devices use the forwarding table to compare incoming packets against existing entries to determine the next hop.D、If multiple matches exist, the forwarding table uses the least-specific entry to forward packets toward the destination.
Which statement is correct about the forwarding table?()A、The forwarding table is stored only on the PFEB、The forwarding table contains all known routesC、The forwarding table is stored on both the RE and PFED、The forwarding table is stored only on the RE
Which statement is true about a routing table?()A、It contains routes learned dynamically only.B、It finds the best path to each destination by using a modified shortest-path-first calculation.C、It contains only active BGP routes.D、It contains all accepted routes to all destinations.
Which statement is true about the forwarding table?()A、The forwarding table is stored in the control plane onlyB、The forwarding table is stored in the control plane and in the forewarding planeC、The forwarding table contains both active and inactive routesD、The forwarding table can contain only sigle next hop per destination
Which two statements are true about the forwarding table?()A、The forwarding table lists each source protocol and preference for each destination.B、The forwarding table contains only active routes.C、The forwarding table is used to process transit packets.D、The forwarding table is stored in compact flash
You create a table in your database that contains 50,000 rows approximately. The queries performed on the table are complex and performed on the table frequently. Which advisor helps you achieve the best performance of database for queries by recommending the appropriate indexes?() A、SQL Access AdvisorB、 Memory AdvisorC、SQL Tuning AdvisorD、 Segment Advisor
单选题Which statement is true about a forwarding table?()AIt stores a subset of information from the routing table.BIt contains routes learned from all protocols to a destination.CIt provides a database for routes selected and placed into the routing table.DEvery routing protocol maintains its own forwarding table.
单选题Which statement is true about the forwarding table?()AThe forwarding table is stored in the control plane onlyBThe forwarding table is stored in the control plane and in the forewarding planeCThe forwarding table contains both active and inactive routesDThe forwarding table can contain only sigle next hop per destination
单选题Which statement is true about the routing table?()AThe routing table exists in the control plane onlyBThe routing table exists in the control plane and the forwarding planeCThe routing table contains both active and inactive routesDThe routing table is stored on compact flash
单选题You execute the following commands to audit database activities: SQL ALTER SYSTEM SET AUDIT_TRIAL=DB, EXTENDED SCOPE=SPFILE; SQL AUDIT SELECT TABLE, INSERT TABLE, DELETE TABLE BY JOHN By SESSION WHENEVER SUCCESSFUL; Which statement is true about the audit record that generated when auditing after instance restarts?()AOne audit record is created for every successful execution of a SELECT, INSERT OR DELETE command on a table, and contains the SQL text for the SQL Statements.BOne audit record is created for every successful execution of a SELECT, INSERT OR DELETE command, and contains the execution plan for the SQL statements.COne audit record is created for the whole session if john successfully executes a SELECT, INSERT, or DELETE command, and contains the execution plan for the SQL statements.DOne audit record is created for the whole session if JOHN successfully executes a select command, and contains the SQL text and bind variables used.EOne audit record is created for the whole session if john successfully executes a SELECT, INSERT,or DELETE command on a table, and contains the execution plan, SQL text, and bind variables used.
单选题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?()APerform EXPORT, DROP, and IMPORT operations on the BOOKINGS table sequentiallyBShrink the BOOKINGS table by using the ALTER TABLE SHRINK SPACE commandCMove the BOOKINGS table to a different location by using the ALTER TABLE MOVE commandDDeallocate the space in the BOOKINGS table by using the ALTER TABLE DEALLOCATE UNUSED command
单选题Which statement is true about the forwarding table?()AThe forwarding table is stored in the control plane only.BThe forwarding table is stored in the control plane and in the forwarding plane.CThe forwarding table contains both active and inactive routes.DThe forwarding table can contain only a single next hop per destination.
多选题Which two statements describe the forwarding table in the Junos OS?()AThe forwarding table contains all known routes.BThe forwarding table stores a subset of information from the routing table.CJunos devices use the forwarding table to compare incoming packets against existing entries to determine the next hop.DIf multiple matches exist, the forwarding table uses the least-specific entry to forward packets toward the destination.
单选题Which statement is true about a routing table?()AIt contains routes learned dynamically only.BIt finds the best path to each destination by using a modified shortest-path-first calculation.CIt contains only active BGP routes.DIt contains all accepted routes to all destinations.
单选题You create a table in your database that contains 50,000 rows approximately. The queries performed on the table are complex and performed on the table frequently. Which advisor helps you achieve the best performance of database for queries by recommending the appropriate indexes?()ASQL Access AdvisorB Memory AdvisorCSQL Tuning AdvisorD Segment Advisor
单选题Which statement is true about a routing table?()AIt contains routers learned dynamically onlyBIt finds the best path to each destination by using a modified shortest-path-first calculationCIt contains only active BGP routesDIt contains all accepted routes to all destinations
多选题Which two statements are true about the forwarding table?()AThe forwarding table lists each source protocol and preference for each destination.BThe forwarding table contains only active routes.CThe forwarding table is used to process transit packets.DThe forwarding table is stored in compact flash.
多选题Which two statements are true about the forwarding table?()AThe forwarding table lists each source protocol and preference for each destination.BThe forwarding table contains only active routes.CThe forwarding table is used to process transit packets.DThe forwarding table is stored in compact flash