itgle.com

Evaluate the following command:SQL>ALTER SYSTEM SET db_securefile = ‘IGNORE‘;What is the impact of this setting on the usage of SecureFiles?()A. It forces BasicFiles to be created even if the SECUREFILE option is specified to create the LOBB. It forces Se

题目
Evaluate the following command:SQL>ALTER SYSTEM SET db_securefile = ‘IGNORE‘;What is the impact of this setting on the usage of SecureFiles?()

A. It forces BasicFiles to be created even if the SECUREFILE option is specified to create the LOB

B. It forces SecureFiles to be created even if the BASICFILE option is specified to create the LOB

C. It does not allow the creation of SecureFiles and generates an error if the SECUREFILE option is specified to create the LOB

D. It ignores the SECUREFILE option only if a Manual Segment Space Management tablespace is used and creates a BasicFile


相似考题
更多“Evaluate the following command:SQL>ALTER SYSTEM SET db_securefile = ‘IGNORE‘;What is the impact of this setting on the usage of SecureFiles?() ”相关问题
  • 第1题:

    importjava.util.*;

    classKeyMaster{

    publicinti;

    publicKeyMaster(inti){this.i=i;}

    publicbooleanequals(Objecto){returni==((KeyMaster)o).i;}

    publicinthashCode(){returni;}

    }

    publicclassMapIt{

    publicstaticvoidmain(String[]args){

    Setset=newHashSet();

    KeyMasterk1=newKeyMaster(1);

    KeyMasterk2=newKeyMaster(2);

    set.add(k1);set.add(k1);

    set.add(k2);set.add(k2);

    System.out.print(set.size()+:”);

    k2.i=1;

    System.out.print(set.size()+:”);

    set.remove(k1);

    System.out.print(set.size()+:”);

    set.remove(k2);

    System.out.print(set.size());

    }

    }

    Whatistheresult?()


    参考答案:F

  • 第2题:

    要使“商品”表中所有商品的单价上浮10%,正确的SQL命令是( )。

    A. ALTER商品SET单价=单价*1.1 FOR ALL

    B. UPDATE商品SET单价=单价+单价*10%

    C. UPDATE商品SET单价=单价*1.1 FOR ALL

    D. UPDATE商品SET单价=单价*1.1


    正确答案:C
    更新表中元组的值,使用UPDATE命令,一次可以更新表中的一个或多个属性值。UPDATE短语之后指定更新数据所属的表,将新的属性值或表达式赋值给对应的属性名(SET单价=单价*1.1),并置于SET短语之后。用 WHERE短语可以对元组进入限制,即对符合条件的元组进行更新。若无WHERE短语则是对表中的所有元组进行更新,%表示运算符。故答案为c。

  • 第3题:

    Althoughtheyagreethatlifeisimportantandshouldberespected,theyfeelthatthequalityoflifeshouldnot(ignore).


    正确答案:
    be ignored

  • 第4题:

    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

  • 第5题:

    Whichofthefollowingprintersusesachargeddrumtotransfertonertopaper?()

    A.thermal

    B.laser

    C.inkjet

    D.impact


    参考答案:B

  • 第6题:

    可以使用下面语句修改数据表中的数据

    A.UPDATE 表名 SET 列名=值

    B.UPDATE 表名 列名=值

    C.ALTER 表名 ADD 列名=值

    D.ALTER 表名 MODIFY 列名=值


    D