单选题Which statement is true regarding online redefinition for the migration of BasicFile LOBs to SecureFile LOBs？（）AIt cannot be done in parallel.BIt can be done at the table level or partition level.CIt does not require additional storage because the oper

题目
单选题
Which statement is true regarding online redefinition for the migration of BasicFile LOBs to SecureFile LOBs？（）
A

 It cannot be done in parallel.

B

 It can be done at the table level or partition level.

C

 It does not require additional storage because the operation is done online.

D

 Local and global indexes are maintained automatically during the operation.

相似考题

1.Which statement is true regarding online redefinition for the migration of BasicFile LOBs to SecureFile LOBs?()A. It cannot be done in parallel.B. It can be done at the table level or partition level.C. It does not require additional storage because the operation is done online.D. Local and global indexes are maintained automatically during the operation.

2.Examine the following commands for redefining a table with Virtual Private Database (VPD) policies:Which two statements are true about redefining the table?()A. All the triggers for the table are disabled without changing any of the column names or column types in the table.B. The primary key constraint on the EMPLOYEES table is disabled during redefinition.C. VPD policies are copied from the original table to the new table during online redefinition.D. You must copy the VPD policies manually from the original table to the new table during online redefinition.

3.Which statement is true regarding IPsec VPNs?()A. There are five phases of IKE negotiation.B. There are two phases of IKE negotiation.C. IPsec VPN tunnels are not supported on SRX Series devices.D. IPsec VPNs require a tunnel PIC in SRX Series devices.

4.You use the segment advisor to help determine objects for which space may be reclaimed.Which three statements are true about the advisor given by the segment advisor?()A. It may advise the use of online table redefinition for tables in dictionary managed tablespace.B. It may advise the use of segment shrink for tables in dictionary managed tablespaces it the no chained rows.C. It may advise the use of online table redefinition for tables in locally managed tablespacesD. It will detect and advise about chained rows.E. It may advise the use of segment shrink for free list managed tables.

更多“Which statement is true regarding online redefinition for th”相关问题

  • 第1题：

    Which statement is true regarding Backup tasks in Cisco UCS？（）

    • A、 They are created automatically and stored on the FI
    • B、 They are created manually and exported to a remote server
    • C、 They are automatically scheduled to run every 24 hours
    • D、 They are manually scheduled and stored on the FI

    正确答案:B

  • 第2题：

    A PL/SQL procedure queries only those columns of a redefined table that were unchanged by the online table redefinition. What happens to the PL/SQL procedure after the online table redefinition?（）

    • A、It remains valid.
    • B、It becomes invalid for all options of online table redefinition but automatically gets revalidated the next time it is used.
    • C、It becomes invalid for all options of online table redefinition and is automatically recompiled during online redefinition of the table.
    • D、It becomes invalid only if the storage parameters have been modified and it automatically gets revalidated the next time it is used.

    正确答案:A

  • 第3题：

    Which two statements are true regarding the ORDER BY clause? （）

    • A、It is executed first in the query execution 
    • B、It must be the last clause in the SELECT statement 
    • C、It cannot be used in a SELECT statement containing a HAVING clause
    • D、You cannot specify a column name followed by an expression in this clause 
    • E、You can specify a combination of numeric positions and column names in this clause

    正确答案:B,E

  • 第4题：

    Which statement is true regarding Flashback Version Query？ （）

    • A、 It returns versions of rows only within a transaction.
    • B、 It can be used in subqueries contained only in a SELECT statement.
    • C、 It will return an error if the undo retention time is less than the lower bound time or SCN specified.
    • D、 It retrieves all versions including the deleted as well as subsequently reinserted versions of the rows.

    正确答案:D

  • 第5题：

    单选题
    Which statement is true regarding online redefinition for the migration of BasicFile LOBs to SecureFile LOBs？（）
    A

     It cannot be done in parallel.

    B

     It can be done at the table level or partition level.

    C

     It does not require additional storage because the operation is done online.

    D

     Local and global indexes are maintained automatically during the operation.


    正确答案： B
    解析： 暂无解析

  • 第6题：

    多选题
    You use the segment advisor to help determine objects for which space may be reclaimed. Which three statements are true about the advisor given by the segment advisor?（）
    A

    It may advise the use of online table redefinition for tables in dictionary managed tablespace.

    B

    It may advise the use of segment shrink for tables in dictionary managed tablespaces it the no chained rows.

    C

    It may advise the use of online table redefinition for tables in locally managed tablespaces

    D

    It will detect and advise about chained rows.

    E

    It may advise the use of segment shrink for free list managed tables.


    正确答案： D,C
    解析： 暂无解析

  • 第7题：

    单选题
    A PL/SQL procedure queries only those columns of a redefined table that were unchanged by the online table redefinition. What happens to the PL/SQL procedure after the online table redefinition?（）
    A

    It remains valid.

    B

    It becomes invalid for all options of online table redefinition but automatically gets revalidated the next time it is used.

    C

    It becomes invalid for all options of online table redefinition and is automatically recompiled during online redefinition of the table.

    D

    It becomes invalid only if the storage parameters have been modified and it automatically gets revalidated the next time it is used.


    正确答案： A
    解析： 暂无解析

  • 第8题：

    单选题
    You need to perform an online table redefinition of an existing SALES table to partition it into two tablespaces TBS1 and TBS2. The SALES table has a materialized view， materialized log， indexes， referential integrity constraint， and triggers with the PRECEDES clause existing on it.  What action is required for dependent objects when you perform online table redefinition？（）
    A

     The dependent materialized view should have a complete refresh performed after the online table redefinition process.

    B

     Triggers with the PRECEDES clause should be disabled before the online table redefinition process.

    C

     Referential integrity constraints must be manually enabled after the online table redefinition process.

    D

     The materialized log should be dropped before the online table redefinition process.


    正确答案： D
    解析： 暂无解析

  • 第9题：

    单选题
    The ADMIN_EMP table has columns EMPNO， ENAME， DEPTNO， and SAL. It has a materialized view EMP_MV with a materialized log and an ENAME_IDX index on the ENAME column. You need to perform an online table redefinition on the ADMIN_EMP table to move it from the TBS1 tablespace to the TBS2 tablespace in the same schema.  What action is required for the dependent objects when you perform online redefinition on the table？（）
    A

     The materialized view should have a complete refresh performed after the online table redefinition is completed.

    B

     The materialized view should have a fast refresh performed after the online table redefinition is completed.

    C

     The materialized view，materialized log，and the index should be dropped and re-created after the online table redefinition is complete.

    D

     The materialized view and materialized log should be dropped and all constraints disabled and re-created after the online table redefinition is complete.


    正确答案： D
    解析： 暂无解析

  • 第10题：

    单选题
    Which statement is true regarding syslog on Junos devices?（）
    A

    No logging is enabled by default.

    B

    By default, the information is stored in a file named events.

    C

    Only the message severity level must be configured.

    D

    You can configure the router to send log messages to the console.


    正确答案： A
    解析： 暂无解析

  • 第11题：

    单选题
    Which statement is true regarding IPsec VPNs?（）
    A

    There are five phases of IKE negotiation.

    B

    There are two phases of IKE negotiation.

    C

    IPsec VPN tunnels are not supported on SRX Series devices.

    D

    IPsec VPNs require a tunnel PIC in SRX Series devices.


    正确答案： D
    解析： 暂无解析

  • 第12题：

    Which statement is true regarding the forwarding plane?（）

    • A、The forwarding plane is contained within the Routing Engine (RE)
    • B、The forwarding plane processes and evaluates exception traffic
    • C、The forwarding plane contains the Packet Forwarding Engine (PFE)
    • D、The forwarding plane is not present on all platforms running the Junos OS

    正确答案:C

  • 第13题：

    Which statement is true regarding syslog on Junos devices?（）

    • A、No logging is enabled by default
    • B、By default the information is stored in all file named events
    • C、Only the message severity level must be configured
    • D、You can configure the router to send log messages to the console

    正确答案:D

  • 第14题：

    You need to perform an online table redefinition of an existing SALES table to partition it into two tablespaces TBS1 and TBS2. The SALES table has a materialized view， materialized log， indexes， referential integrity constraint， and triggers with the PRECEDES clause existing on it.  What action is required for dependent objects when you perform online table redefinition？（）  

    • A、 The dependent materialized view should have a complete refresh performed after the online table redefinition process.
    • B、 Triggers with the PRECEDES clause should be disabled before the online table redefinition process.
    • C、 Referential integrity constraints must be manually enabled after the online table redefinition process.
    • D、 The materialized log should be dropped before the online table redefinition process.

    正确答案:A

  • 第15题：

    多选题
    Which three table transformations can be done using online redefinition of tables？（）
    A

    A

    B

    B

    C

    C

    D

    D

    E

    E


    正确答案： D,C
    解析： 暂无解析

  • 第16题：

    单选题
    Evaluate the following statement：   Which statement is true regarding the evaluation of rows returned by the subquery in the INSERT statement？（）
    A

     They are evaluated by all the three WHEN clauses regardless of the results of the evaluation of any other WHEN clause.

    B

     They are evaluated by the first WHEN clause. If the condition is true， then the row would be evaluated by the subsequent WHEN clauses.

    C

     They are evaluated by the first WHEN clause. If the condition is false， then the row would be evaluated by the subsequent WHEN clauses.

    D

     The INSERT statement would give an error because the ELSE clause is not present for support in case none of the WHEN clauses are true.


    正确答案： A
    解析： 暂无解析

  • 第17题：

    单选题
    Which of the following statement（s）is/are TRUE regarding a twin pedestal crane set（）.
    A

    The cranes may be operated independently

    B

    The cranes may be interconnected for twin operation

    C

    When twinned，the crane rotation on the foundation assembly is unlimited

    D

    All of the above


    正确答案： A
    解析： 暂无解析

  • 第18题：

    单选题
    Which statement regarding the contents of the V$PARAMETER view is true？（）
    A

    displays only the list of default values

    B

    displays only the list of all basic parameters

    C

    displays the currently in effect parameter values

    D

    displays only the list of all advanced parameters

    E

    displays the list of all the parameter files of a database


    正确答案： B
    解析： 暂无解析

  • 第19题：

    单选题
    Your test database is running in NOARCHIVELOG mode. Which statement is true regarding the type ofbackups that can be performed on the database（）
    A

    You can perform online whole database backups.

    B

    You can performofflinewhole database backups.

    C

    You cannot perform schema-level export/import operations.

    D

    You can perform the backup of only the SYSTEM tablespace when the database is open.


    正确答案： C
    解析： 暂无解析

  • 第20题：

    单选题
    Which statement is true regarding NAT?（）
    A

    NAT is not supported on SRX Series devices.

    B

    NAT requires special hardware on SRX Series devices.

    C

    NAT is processed in the control plane.

    D

    NAT is processed in the data plane.


    正确答案： C
    解析： 暂无解析

  • 第21题：

    单选题
    Which statement is true regarding syslog on Junos devices?（）
    A

    No logging is enabled by default

    B

    By default the information is stored in all file named events

    C

    Only the message severity level must be configured

    D

    You can configure the router to send log messages to the console


    正确答案： B
    解析： 暂无解析

  • 第22题：

    单选题
    Which statement is true regarding synonyms?（）
    A

    Synonyms can be created only for a table 

    B

    Synonyms are used to reference only those tables that are owned by another user 

    C

    A public synonym and a private synonym can exist with the same name for the same table 

    D

    The DROP SYNONYM statement removes the synonym, and the table on which the synonym has been created becomes invalid


    正确答案： C
    解析： 暂无解析

相关内容