单选题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.Evaluate the SQL statement: TRUNCATE TABLE DEPT; Which three are true about the SQL statement? ()A. It releases the storage space used by the table.B. It does not release the storage space used by the table.C. You can roll back the deletion of rows after the statement executes.D. You can NOT roll back the deletion of rows after the statement executes.E. An attempt to use DESCRIBE on the DEPT table after the TRUNCATE statement executes will display an error.F. You must be the owner of the table or have DELETE ANY TABLE system privileges to truncate the DEPT 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?()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.

4.Evaluate the following SQL statement used to create the PRODUCTS table:Which statement is true regarding this command?()A. It executes successfully but partition pruning cannot happen for this partition key.B. It produces an error because the TOTAL_VALUE column cannot be used as a partition key.C. It produces an error because compression cannot be used for the TOTAL_VALUE partition key.D. It executes successfully but the values in the TOTAL_VALUE column would not be physically stored in the partitions.

更多“单选题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 th”相关问题

  • 第1题：

    Which statements are true regarding SecureFile LOBs？（） 

    • A、 The amount of undo retained is user controlled.
    • B、 SecureFile LOBs can be used only for nonpartitioned tables.
    • C、 Fragmentation is minimized by using variable-sized chunks dynamically.
    • D、 SecureFile encryption allows for random reads and writes of the encrypted data.
    • E、 It automatically detects duplicate LOB data and conserves space by storing only one copy.

    正确答案:C,D

  • 第2题：

    Evaluate the SQL statement:TRUNCATE TABLE DEPT;Which three are true about the SQL statement? （）

    • A、It releases the storage space used by the table.
    • B、It does not release the storage space used by the table.
    • C、You can roll back the deletion of rows after the statement executes.
    • D、You can NOT roll back the deletion of rows after the statement executes.
    • E、An attempt to use DESCRIBE on the DEPT table after the TRUNCATE statement executes will display an error.
    • F、You must be the owner of the table or have DELETE ANY TABLE system privileges to truncate the DEPT table

    正确答案:A,D,F

  • 第3题：

    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.

    正确答案:B

  • 第4题：

    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

  • 第5题：

    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

  • 第6题：

    Which statement about the enabling of table compression in Oracle Database 11g is true?（）

    • A、Compression can be enabled at the table, tablespace, or partition level for direct loads only.
    • B、Compression can be enabled only at the table level for both direct loads and conventional DML.
    • C、Compression can be enabled at the table, tablespace, or partition level for conventional DML only.
    • D、Compression can be enabled at the table, tablespace, or partition level for both direct loads and conventional DML.

    正确答案:D

  • 第7题：

    单选题
    Your are the DBA supporting an Oracle 11g Release 2 database and wish to move a table containing several DATE, CHAR, VARCHAR2, and NUMBER data types, and the table’s indexes, to another tablespace. The table does not have a primary key and is used by an OLTP application. Which technique will move the table and indexes while maintaining the highest level of availability to the application?（）
    A

    Oracle Data Pump.

    B

    An ALTER TABLE MOVE to move the table and ALTER INDEX REBUILD to move the indexes.

    C

    An ALTER TABLE MOVE to move the table and ALTER INDEX REBUILD ONLINE to move the indexes.

    D

    Online Table Redefinition.

    E

    Edition-Based Table Redefinition.


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

  • 第8题：

    单选题
    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
    解析： 暂无解析

  • 第9题：

    单选题
    View the Exhibit and examine the structure of the ORDERS and ORDERJTEMS tables.  Evaluate the following SQL statement：   SELECT oi.order_id， product_jd， order_date   FROM order_items oi JOIN orders o   USING （order_id）；   Which statement is true regarding the execution of this SQL statement？（）
    A

     The statement would not execute because table aliases are not allowed in the JOIN clause.

    B

     The statement would not execute because the table alias prefix is not used in the USING clause.

    C

     The statement would not execute because all the columns in the SELECT clause are not prefixed with table aliases.

    D

     The statement would not execute because the column part of the USING clause cannot have a qualifier in the SELECT list.


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

  • 第10题：

    多选题
    Which statements are true regarding SecureFile LOBs?（）
    A

    The amount of undo retained is user controlled.

    B

    SecureFile LOBs can be used only for nonpartitioned tables.

    C

    Fragmentation is minimized by using variable-sized chunks dynamically.

    D

    SecureFile encryption allows for random reads and writes of the encrypted data.

    E

    It automatically detects duplicate LOB data and conserves space by storing only one copy.


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

  • 第11题：

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


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

  • 第12题：

    单选题
    Which statement about the enabling of table compression in Oracle Database 11g is true?（）
    A

    Compression can be enabled at the table, tablespace, or partition level for direct loads only.

    B

    Compression can be enabled only at the table level for both direct loads and conventional DML.

    C

    Compression can be enabled at the table, tablespace, or partition level for conventional DML only.

    D

    Compression can be enabled at the table, tablespace, or partition level for both direct loads and conventional DML.


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

  • 第13题：

    Which two data types can be converted to LOBs using an ALTER TABLE… MODIFY command？（）

    • A、RAW
    • B、LONG
    • C、VARCHAR
    • D、LONG RAW

    正确答案:B,D

  • 第14题：

    Which two statements are true regarding hot patching？（）

    • A、 It requires relinking of the Oracle binary.
    • B、 It does not require database instance shutdown.
    • C、 It can detect conflicts between two online patches.
    • D、 It is available for installing all patches on all platforms. 
    • E、 It works only in a single database instance environment.

    正确答案:B,C

  • 第15题：

    Which statements are true regarding system-partitioned tables？（）  

    • A、 Only a single partitioning key column can be specified.
    • B、 All DML statements must use partition-extended syntax.
    • C、 The same physical attributes must be specified for each partition.
    • D、 Unique local indexes cannot be created on a system-partitioned table.
    • E、 Traditional partition pruning and partitionwise joins are not supported on these tables.

    正确答案:D,E

  • 第16题：

    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

  • 第17题：

    Evaluate the following SQL statement used to create the PRODUCTS table：   CREATE TABLE products （product_id NUMBER（3） PRIMARY KEY， product_desc VARCHAR2（25）， qtyNUMBER（8，2）， rate NUMBER（10，2）， total_value AS （ qty * rate）） PARTITION BY RANGE （total_value） （PARTITION p1 VALUES LESS THAN （100000）， PARTITION p2 VALUES LESS THAN  （150000）， PARTITION p3 VALUES LESS THAN （MAXVALUE））  COMPRESS FOR ALL OPERATIONS；   Which statement is true regarding this command？（）  

    • A、 It executes successfully but partition pruning cannot happen for this partition key.
    • B、 It produces an error because the TOTAL_VALUE column cannot be used as a partition key.
    • C、 It produces an error because compression cannot be used for the TOTAL_VALUE partition key. 
    • D、 It executes successfully but the values in the TOTAL_VALUE column would not be physically stored in the partitions.

    正确答案:D

  • 第18题：

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

    A

    B

    B

    C

    C

    D

    D

    E

    E


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

  • 第19题：

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


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

  • 第20题：

    单选题
    Which statement about the enabling of table compression in Oracle Database 11g is true？（）
    A

     Compression can be enabled at the table， tablespace， or partition level for direct loads only.

    B

     Compression can be enabled only at the table level for both direct loads and conventional DML.

    C

     Compression can be enabled at the table， tablespace， or partition level for conventional DML only.

    D

     Compression can be enabled at the table， tablespace， or partition level for both direct loads and conventional DML.


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

  • 第21题：

    单选题
    Evaluate the following SQL statement used to create the PRODUCTS table：   CREATE TABLE products （product_id NUMBER（3） PRIMARY KEY， product_desc VARCHAR2（25）， qtyNUMBER（8，2）， rate NUMBER（10，2）， total_value AS （ qty * rate）） PARTITION BY RANGE （total_value） （PARTITION p1 VALUES LESS THAN （100000）， PARTITION p2 VALUES LESS THAN  （150000）， PARTITION p3 VALUES LESS THAN （MAXVALUE））  COMPRESS FOR ALL OPERATIONS；   Which statement is true regarding this command？（）
    A

     It executes successfully but partition pruning cannot happen for this partition key.

    B

     It produces an error because the TOTAL_VALUE column cannot be used as a partition key.

    C

     It produces an error because compression cannot be used for the TOTAL_VALUE partition key. 

    D

     It executes successfully but the values in the TOTAL_VALUE column would not be physically stored in the partitions.


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

  • 第22题：

    单选题
    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
    解析： 暂无解析

  • 第23题：

    单选题
    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


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

  • 第24题：

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


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

相关内容