网友您好, 请在下方输入框内输入要搜索的题目:

题目内容 (请给出正确答案)
单选题
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.


参考答案

参考解析
解析: 暂无解析
更多 “单选题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.” 相关考题
考题 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.

考题 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.

考题 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

考题 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.

考题 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.

考题 Which two data types can be converted to LOBs using an ALTER TABLE… MODIFY command?()A、RAWB、LONGC、VARCHARD、LONG RAW

考题 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

考题 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.

考题 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.

考题 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.

考题 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.

考题 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.

考题 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.

考题 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.

考题 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.

考题 多选题Which three table transformations can be done using online redefinition of tables?()AABBCCDDEE

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

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

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

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

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

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

考题 多选题Which statements are true regarding SecureFile LOBs?()AThe amount of undo retained is user controlled.BSecureFile LOBs can be used only for nonpartitioned tables.CFragmentation is minimized by using variable-sized chunks dynamically.DSecureFile encryption allows for random reads and writes of the encrypted data.EIt automatically detects duplicate LOB data and conserves space by storing only one copy.

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

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

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

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

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