违法和不良信息举报 联系客服
免费注册 登录

Which statement is true regarding online redefinition for th

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

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.


参考答案：B, C

第2题：

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

第3题：

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

第4题：

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

第5题：

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

第6题：

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

第7题：

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

第8题：

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.


参考答案：B, C, D

第9题：

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

第10题：

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

更多相关问题
相关内容