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

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.

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

Which statement is true regarding Backup tasks in Cisco UCS?()A、 They are created automatically and stored on the FIB、 They are created manually and exported to a remote serverC、 They are automatically scheduled to run every 24 hoursD、 They are manually scheduled and stored on the FI

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 trafficC、The forwarding plane contains the Packet Forwarding Engine (PFE)D、The forwarding plane is not present on all platforms running the Junos OS

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 syslog on Junos devices?()A、No logging is enabled by defaultB、By default the information is stored in all file named eventsC、Only the message severity level must be configuredD、You can configure the router to send log messages to the console

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 clauseD、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

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

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

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

多选题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?()AIt may advise the use of online table redefinition for tables in dictionary managed tablespace.BIt may advise the use of segment shrink for tables in dictionary managed tablespaces it the no chained rows.CIt may advise the use of online table redefinition for tables in locally managed tablespacesDIt will detect and advise about chained rows.EIt may advise the use of segment shrink for free list managed tables.

单选题Which of the following statement(s)is/are TRUE regarding a twin pedestal crane set().AThe cranes may be operated independentlyBThe cranes may be interconnected for twin operationCWhen twinned,the crane rotation on the foundation assembly is unlimitedDAll of the above

单选题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?()AIt remains valid.BIt becomes invalid for all options of online table redefinition but automatically gets revalidated the next time it is used.CIt becomes invalid for all options of online table redefinition and is automatically recompiled during online redefinition of the table.DIt becomes invalid only if the storage parameters have been modified and it automatically gets revalidated the next time it is used.

单选题Which statement regarding the contents of the V$PARAMETER view is true?()Adisplays only the list of default valuesBdisplays only the list of all basic parametersCdisplays the currently in effect parameter valuesDdisplays only the list of all advanced parametersEdisplays the list of all the parameter files of a database

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

单选题Your test database is running in NOARCHIVELOG mode. Which statement is true regarding the type ofbackups that can be performed on the database()AYou can perform online whole database backups.BYou can performofflinewhole database backups.CYou cannot perform schema-level export/import operations.DYou can perform the backup of only the SYSTEM tablespace when the database is open.

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

单选题Which statement is true regarding NAT?()ANAT is not supported on SRX Series devices.BNAT requires special hardware on SRX Series devices.CNAT is processed in the control plane.DNAT is processed in the data plane.

单选题Which statement is true regarding syslog on Junos devices?()ANo logging is enabled by default.BBy default, the information is stored in a file named events.COnly the message severity level must be configured.DYou can configure the router to send log messages to the console.

单选题Which statement is true regarding syslog on Junos devices?()ANo logging is enabled by defaultBBy default the information is stored in all file named eventsCOnly the message severity level must be configuredDYou can configure the router to send log messages to the console

单选题Which statement is true regarding IPsec VPNs?()AThere are five phases of IKE negotiation.BThere are two phases of IKE negotiation.CIPsec VPN tunnels are not supported on SRX Series devices.DIPsec VPNs require a tunnel PIC in SRX Series devices.

单选题Which statement is true regarding synonyms?()ASynonyms can be created only for a table BSynonyms are used to reference only those tables that are owned by another user CA public synonym and a private synonym can exist with the same name for the same table DThe DROP SYNONYM statement removes the synonym, and the table on which the synonym has been created becomes invalid