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

单选题Which action(s) will cause a compression dictionary to be removed from a table?（）A Set the table COMPRESS attribute to NO.  B Set the table COMPRESS attribute to NO; run REORG against the table.  C Set the table COMPRESS attribute to NO; run INSPECTRES

题目
单选题
Which action(s) will cause a compression dictionary to be removed from a table?（）
A

Set the table COMPRESS attribute to NO.  

B

Set the table COMPRESS attribute to NO; run REORG against the table.  

C

Set the table COMPRESS attribute to NO; run INSPECTRESETDICTIONARY against the table.  

D

Set the table COMPRESS attribute to NO; run RUNSTATS against the table.

如果没有搜索结果或未解决您的问题，请直接 联系老师 获取答案。
相似问题和答案

第1题：

When a job exceeds the date specified in its END_DATE attribute, which of the following will happen?()

A. The job will be dropped automatically if the value of the AUTO_DROP attribute is TRUE

B. The job will only be disabled if the value of the AUTO_DROP attribute is FALSE

C. The STATE attribute of the job will be set to COMPLETED if the value of the AUTO_DROP attribute is FALSE

D. All objects referenced by the job will be dropped if the value of the AUTO_DROP attribute is TRUE and the value of the CASCADE attribute is TRUE

E. The STATE column of the job table will be set to COMPLETED for the job


参考答案：A, B, E

第2题：

Refer to the exhibit. Based upon the configuration, you need to understand why the policy routi match counts are not increasing. Which would be the first logical step to take?()

A. Confirm if there are other problematic route - map statements that precede divert.

B. Check the access list for log hits.

C. Check the routing table for 212.50.185.126.

D. Remove any two of the set clauses. (Multiple set clause entries will cause PBR to use the routing table.)


参考答案：B

第3题：

You are creating a Windows Communication Foundation (WCF) service that accepts messages from clients when they are started. The message is defined as follows:[MessageContract] public class Agent {

A. Add a MessageBodyMember attribute to the CodeName property and set the ProtectionLevel to Sign. Add a MessageBodyMember attribute to the SecretHandshake property and set the ProtectionLevel to EncryptAndSign.

B. Add a DataProtectionPermission attribute to the each property and set the ProtectData property to true.

C. Add an xmlText attribute to the CodeName property and set the DataType property to Signed. Add a PasswordPropertyText attribute to the SecretHandshake property and set its value to true.

D. Add an ImmutableObject attribute to the CodeName property and set its value property to true. Add a Browsable attribute to the SecretHandshake property and set its value to false.


参考答案：A

第4题：

The RECYCLEBIN parameter is set to ON for your database. You drop a table, PRODUCTS, from the SCOTT schema. Which two statements are true regarding the outcome of this action? （）(Choose two)

  • A、All the related indexes and views are automatically dropped
  • B、The flashback drop feature can recover only the table structure
  • C、Only the related indexes are dropped whereas views are invalidated
  • D、The flashback drop feature can recover both the table structure and its data

正确答案:C,D

第5题：

You need to meet the business requirements of the packaging department. What should you do?（）

  • A、Add the ProductSize data table and the ProductSizeDescriptor column to the Product dimension. Set the order of the ProductSKU attribute to the ProductSizeDescriptor column.
  • B、Add the ProductSize data table as a dimension and then add this dimension to the cube as a Referenced dimension. Set the order of the key attribute of the ProductSize dimension to the ProductSizeDescriptor column.
  • C、Add the ProductSize data table and the ProductSizeDescriptor column to the Product dimension. Create a user-defined hierarchy that has ProductSKU as the top-level attribute and ProductSizeDescriptor as the bottom-level attribute.
  • D、Add the ProductSize data table as a dimension and then add this dimension to the cube as a Referenced dimension. Create a user-defined hierarchy within the ProductSize dimension. Set the ProductSizeDescriptor attribute as the top-level attribute.

正确答案:A

第6题：

Which DBMS_SCHEDULER procedure(s) can be used to alter an existing job? ()

A. SET_ATTRIBUTE_NULL

B. ALTER_JOB

C. ALTER_JOB_PARAMETERS

D. ALTER

E. SET_ATTRIBUTE


参考答案：A, E

第7题：

Which are SRW package procedure or function could you use to create and then drop a temporary table in the sales report?（）

  • A、SRW.BREAK 
  • B、SRW.SET_ALTER 
  • C、SRW.REFERENCE 
  • D、SRW.DO_SQL 
  • E、SRW.RUN_REPORT
  • F、SRW.SET_FIELD

正确答案:D

第8题：

Sales details are being stored on a daily basis in the SALES_2007 table. A large amount of data is added to the table daily. To save disk space, you issued the following command:ALTER TABLE sales_2007 COMPRESS FOR ALL OPERATIONS;What would be the outcome of this command?（）

A. It produces an error because data already exists in the table.

B. It produces an error because compression can be enabled at table creation only.

C. It compresses all data added or modified henceforth but the existing data in the table is not compressed immediately.

D. It immediately compresses all existing data as well as new data, resulting from either fresh additions or modifications to existing data.


参考答案：C

第9题：

Which action(s) will cause a compression dictionary to be removed from a table?（）

  • A、Set the table COMPRESS attribute to NO.  
  • B、Set the table COMPRESS attribute to NO; run REORG against the table.  
  • C、Set the table COMPRESS attribute to NO; run INSPECTRESETDICTIONARY against the table.  
  • D、Set the table COMPRESS attribute to NO; run RUNSTATS against the table.

正确答案:B

第10题：

When a job exceeds the date specified in its END_DATE attribute, which of the following will happen?（）

  • A、The job will be dropped automatically if the value of the AUTO_DROP attribute is TRUE
  • B、The job will only be disabled if the value of the AUTO_DROP attribute is FALSE
  • C、The STATE attribute of the job will be set to COMPLETED if the value of the AUTO_DROP attribute is FALSE
  • D、All objects referenced by the job will be dropped if the value of the AUTO_DROP attribute is TRUE and the value of the CASCADE attribute is TRUE
  • E、The STATE column of the job table will be set to COMPLETED for the job

正确答案:A,B,E

更多相关问题
相关内容