Examinethecommand:SQL>DBMS_STATS.SET_TABLE_PREFS(’SH’,’CUSTOMERS’,’PUBLISH’,’false’);Whichstatementdescribestheeffectoftheabovecommand()A.AutomaticstatisticscollectionisstoppedfortheCUSTOMERStable.B.StatisticsfortheCUSTOMERStablearelockedandcannotbeoverwr

题目
Examinethecommand:SQL>DBMS_STATS.SET_TABLE_PREFS(’SH’,’CUSTOMERS’,’PUBLISH’,’false’);Whichstatementdescribestheeffectoftheabovecommand()

A.AutomaticstatisticscollectionisstoppedfortheCUSTOMERStable.

B.StatisticsfortheCUSTOMERStablearelockedandcannotbeoverwritten.

C.ExistingstatisticsfortheCUSTOMERStablebecomeunusableforthequeryoptimizer.

D.Subsequently，statisticsgatheredontheCUSTOMERStablearestoredaspendingstatistics

相似考题

1.［A］ present ［B］ publish ［C］ deliver ［D］ pursue

2.（ 12 ）下列布尔变量定义中，正确并且规范的是A )BOOLEAN canceled = false;B)boolean canceled = false;C)boolean CANCELED = false;D)boolean canceled = FALSE;

3.Principles of Marketing Marketing is the part of your business where money is made. In order to succeed in business, the following two principles of marketing should be kept in mind. First, customers are the mainstay of any business. Attracting customers to a business makes the difference between succeeding and failing. Therefore, the business needs to direct all activities towards satisfying the customers’ needs. If customers are satisfied, there is a chance that they will be retained for a long time and possibly permanently. Undoubtedly they are likely to talk to other potential customers. Another principle for a business is that profitable sales volume is more important than maximum sales volume. The profitable sales volume is the volume of sales that actually will earn a business the most profit. And the maximum sales volume simply refers to the biggest sum of retail sales. Since the aim of most businesses is to make as much profit as possible, businesses value profits more than the volume of sales. A large volume of sales may result in a low profit margin, therefore, it is important for marketers to focus on their profitable sales volume. Decide if each of the following statement is TRUE (T) or FALSE (F).1. In order to succeed in business, three principles of marketing should be kept in mind.()2. If customers are satisfied, they will be likely to encourage more people to buy the products or services.()3. The profitable sales volume is the volume of sales that will bring a business profit.()4. The maximum sales volume refers to the biggest sum of retail sales.()5. Profitable sales volume is as important as the maximum sales volume.()

4.下面程序段的输出结果为( )。 pubUCClassTeS { public static voidmain(StringargS[]) { booleaha,b，c； a=(3＜5)； b=(a==tme)； System.Out.phntln("a="+a+"b="+b)； c=(b==false)； SyStem.out.println("b="+b+"C="+c)； } }A．a=tme b=falSeB．a=true b=false b=true c=false b=true C=tmeC．a=true b=trueD．a=falSe b=false b=true c=falSe b=tme c=falSe

更多“Examinethecommand:SQL>DBMS_STATS.SET_TABLE_PREFS(’SH’,’CUSTOMERS’,’PUBLISH’,’false’);Whichstatementdescribestheeffectoftheabovecommand() ”相关问题

  • 第1题：

    下面哪个函数可以返回逻辑值TRUE()。

    A、AND(TRUE，TRUE，FALSE)

    B、OR(TRUE，TRUE，FALSE)

    C、OR(FALSE，FALSE，FALSE)

    D、NOT(TRUE)


    答案：B

  • 第2题：

    Examine the following command that is executed for the TRANSPORT table in the SH schema:Which statement describes the significance of this command?()

    A. It collects statistics into the pending area in the data dictionary

    B. It creates a virtual hidden column in the CUSTOMERS_OBE table

    C. It collects statistics with AUTO_SAMPLE_SIZE for ESTIMATE_PERCENT

    D. It creates a histogram to hold skewed information about the data in the columns


    参考答案：B

  • 第3题：

    Youexecutedthefollowingcommands：SQL>ALTERSESSIONSETOPTIMIZER_USE_PENDING_STATISTICS=false；SQL>EXECUTEDBMS_STATS.SET_TABLE_PREFS（’SH’，’CUSTOMERS’，’PUBLISH’，’false’）；SQL>EXECUTEDBMS_STATS.GATHER_TABLE_STATS（’SH’，’CUSTOMERS’）；WhichstatementiscorrectregardingtheabovestatisticscollectionontheSH.CUSTOMERStableintheabovesession？（）

    A.Thestatisticsarestoredinthependingstatisticstableinthedatadictionary.

    B.Thestatisticsaretreatedasthecurrentstatisticsbytheoptimizerforallsessions.

    C.Thestatisticsaretreatedasthecurrentstatisticsbytheoptimizerforthecurrentsessionsonly.

    D.Thestatisticsaretemporaryandusedbytheoptimizerforallsessionsuntilthissessionterminates.


    参考答案：A

  • 第4题：

    下列布尔变量定义中，正确并且规范的是

    A．BOOLEANcanceled=false；

    B．booleancanceled=false；

    C．booleanCANCELED=false；

    D．booleancanceled=FALSE；


    正确答案：B
    解析：Java中标识符是区分字母大小写的，boolean、false都是关键字，变为大写后不正确，故选项A、选项D都不正确。Java中的变量名一般为小写字母，只有常量才用大写字母，所以选项C也不正确。

  • 第5题：

    为使标题栏上的这两个按钮消失，而保留其他按钮，没置窗体属性时，正确的是

    A．ControlBox=True、MaxButton=False、MinButton=True

    B．ControlBox=False、MaxButton=True、MinButton=True

    C．ControlBox=True、MaxButton=False、MinButton=False

    D．ControlBox=False、MaxButton=False、MinButton=False


    正确答案：C
    解析：ControlBox、MaxBuRon和MinButton属性都影响窗体标题栏上的按钮，其中ControlBox为False，则标题栏上的所有按钮消失，这显然与题意不符，所以选项B和D肯定是错误的。MaxButton和MinButton属性分别决定最大化按钮和最小化按钮是否显示，只有当二者都为False时，这两个按钮才都不显示。

  • 第6题：

    下列选项中,哪个是程序的运行结果class Test{public static void main(String[] args) {int a = 3;int b = 6;System.out.print(a==b);System.out.print(aSystem.out.print(a!=b);System.out.print(a>=b);}}

    A.false false true false

    B.false false true true

    C.false true true false

    D.true false false true


    答案：C
    解析：3==6(错)，3<6(对)，3!=6(对)，3>=6(错)

  • 第7题：

    A为True，B为False，则"AandB"和"AOrB"的值分别是（）

    • A、True，True
    • B、True，False
    • C、False，True
    • D、False，False

    正确答案:C

  • 第8题：

    You executed the following commands：   SQL> ALTER SESSION SET OPTIMIZER_USE_PENDING_STATISTICS = false； SQL> EXECUTE DBMS_STATS.SET_TABLE_PREFS（’SH’， ’CUSTOMERS’， ’PUBLISH’，’false’）； SQL> EXECUTE DBMS_STATS.GATHER_TABLE_STATS（’SH’， ’CUSTOMERS’）；   Which statement is correct regarding the above statistics collection on the SH.CUSTOMERS table in the above session？（）

    • A、 The statistics are stored in the pending statistics table in the data dictionary.
    • B、 The statistics are treated as the current statistics by the optimizer for all sessions.
    • C、 The statistics are treated as the current statistics by the optimizer for the current sessions only.
    • D、 The statistics are temporary and used by the optimizer for all sessions until this session terminates.

    正确答案:A

  • 第9题：

    UNIX系统下sh命令使用正确的是（）

    • A、sh run
    • B、sh ip int br
    • C、sh version
    • D、sh aibi.sh

    正确答案:D

  • 第10题：

    单选题
    You want to capture column group usage and gather extended statistics for better cardinality estimates for the CUSTOMERS table in the SH schema. Examine the following steps: 1. Issue the SELECT DBMS_STATS.CREATE_EXTENDED_STATS (‘SH’, ‘CUSTOMERS’) FROM dual statement. 2. Execute the DBMS_STATS.SEED_COL_USAGE (null, ‘SH’, 500) procedure. 3. Execute the required queries on the CUSTOMERS table. 4. Issue the SELECT DBMS_STATS.REPORT_COL_USAGE (‘SH’, ‘CUSTOMERS’) FROM dual statement. Identify the correct sequence of steps.（）
    A

    3，2，1，4

    B

    2，3，4，1

    C

    4，1，3，2

    D

    3，2，4，1


    正确答案： B
    解析： 暂无解析

  • 第11题：

    单选题
    You need to produce a report for mailing labels for all customers. The mailing label must have only the customer name and address. The CUSTOMERS table has these columns: Which SELECT statement accomplishes this task?（）
    A

    SELECT*   FROM customers;

    B

    SELECT name, address   FROM customers;

    C

    SELECT id, name, address, phone   FROM customers;

    D

    SELECT cust_name, cust_address   FROM customers;

    E

    SELECT cust_id, cust_name, cust_address, cust_phone   FROM customers;


    正确答案： C
    解析： 暂无解析

  • 第12题：

    单选题
    Examine the command：  SQL> DBMS_STATS.SET_TABLE_PREFS（’SH’， ’CUSTOMERS’， ’PUBLISH’， ’false’）； Which statement describes the effect of the above command（）
    A

    Automatic statistics collection is stopped for the CUSTOMERS table.

    B

    Statistics for the CUSTOMERS table are locked and cannot be overwritten.

    C

    Existing statistics for the CUSTOMERS table become unusable for the query optimizer.

    D

    Subsequently， statistics gathered on the CUSTOMERS table are stored as pending statistics.


    正确答案： B
    解析： 暂无解析

  • 第13题：

    You executed the following commands:Which statement is correct regarding the above statistics collection on the SH.CUSTOMERS table in the above session?()

    A. The statistics are stored in the pending statistics table in the data dictionary.

    B. The statistics are treated as the current statistics by the optimizer for all sessions.

    C. The statistics are treated as the current statistics by the optimizer for the current sessions only.

    D. The statistics are temporary and used by the optimizer for all sessions until this session terminates.


    参考答案：A

  • 第14题：

    Examinethecommand:SQL>ALTERUSERskdACCOUNTLOCK;Whichtwostatementsaretrueafterthecommandisexecuted()

    A.TheSKDusercannotlogintothedatabaseinstance.

    B.TheobjectsownedbytheSKDuserarenotaccessibletoanyuser.

    C.TheotheruserscanaccesstheobjectsownedbytheSKDuser，onwhichtheyhaveaccess.

    D.ThepasswordfortheSKDuserexpiresandtheuserisforcedtochangethepasswordatthenextlogin


    参考答案：A, C

  • 第15题：

    Examine this command:SQL > exec DBMS_STATS.SET_TABLE_PREFS (‘SH’, ‘CUSTOMERS’, ‘PUBLISH’, ‘false’);Which three statements are true about the effect of this command?()

    A. Statistics collection is not done for the CUSTOMERS table when schema stats are gathered.

    B. Statistics collection is not done for the CUSTOMERS table when database stats are gathered.

    C. Any existing statistics for the CUSTOMERS table are still available to the optimizer at parse time.

    D. Statistics gathered on the CUSTOMERS table when schema stats are gathered are stored as pending statistics.

    E. Statistics gathered on the CUSTOMERS table when database stats are gathered are stored as pending statistics.


    参考答案：A, C, D

  • 第16题：

    下面程序段的输出结果为（ ）。

    A.a＝true b＝false b＝true C＝true

    B.a＝true b＝false b＝true e＝false

    C.a＝true b＝true b＝true C＝false

    D.a＝false b＝false b＝true C＝false


    正确答案：C
    本题考查关系运算符<和＝＝。题目中a＝(3<5)；比较3和5的大小，因为，3<5，返回true给a；b＝(a＝＝true)；判断a是否为真，因为a确实为真，返回true给b；c＝(b＝＝false)；判断h是否为假，因为b不为假，返回false给c。最后结果a＝true，b＝true，b＝true，C＝false，选项C正确。

  • 第17题：

    下列布尔变量定义中，正确并且规范的是

    A．BOOLEAN canceled=false；

    B．boolean canceled=false；

    C．boolean CANCELED=false；

    D．boolean canceled=FALSE；


    正确答案：B
    解析：本题考查Java的简单数据类型的变量定义及Java的命名约定。Java中的命名规则中包含如下几条：
      (1)变量名、方法名首单词小写，其余单词只有首字母大写；
      (2)常量完全大写；
      (3)变量命名采用完整的英文描述符，第一个字母小写，任何中间单词的首字母大写。
      Java语言区分大小写。简单数据类型布尔型用boolean表示。布尔型数据只有两个值： true(真)和false(假)。
      经过上述分析可知，选项B和选项C都能正确的定义一个布尔型变量，但是选项C的变量名CANCELED不符合Java中的命名规则，而选项B的变量名符合变量名的命名规则。因此，选项B是符合规范的布尔变量定义语句。
      本题的正确答案是选项B。

  • 第18题：

    Examinethecommand:ALTERDATABASEADDSUPPLEMENTALLOGDATA(PRIMARYKEY)COLUMNS;Whatdoesthecommandaccomplish?()

    A.Createsanadditionalcopyofthedatabaseonlineredologfiles.

    B.StorestheprimarykeycolumnvaluesofeachrowinvolvedinaDMLoperationintheonlineredologfiles.

    C.StorestheprimarykeycolumnvaluesofeachrowinvolvedinaDMLoperationinthesupplementallogfiles.

    D.StorestheoldandnewprimarykeycolumnvaluesofeachrowinvolvedinaDMLoperationonlywhentheprimarykeyismodifiedintheonlineredologfiles.


    参考答案：B

  • 第19题：

    创建一个名为‘Customers’的新表，同时要求新表中包含表‘clients’的所有记录，sql语句是（）。

    • A、Select*into customers from clients
    • B、Select into customers from clients
    • C、Insert into customers select*from clients
    • D、Insert customers select*from clients

    正确答案:A

  • 第20题：

    Which utility allows you to pre-compile and publish your Web site to a new location？（）

    • A、Publish Web Site
    • B、Web-based installation
    • C、Web site project mode
    • D、Web services directory

    正确答案:A

  • 第21题：

    单选题
    You executed the following commands：   SQL> ALTER SESSION SET OPTIMIZER_USE_PENDING_STATISTICS = false； SQL> EXECUTE DBMS_STATS.SET_TABLE_PREFS（’SH’， ’CUSTOMERS’， ’PUBLISH’，’false’）； SQL> EXECUTE DBMS_STATS.GATHER_TABLE_STATS（’SH’， ’CUSTOMERS’）；   Which statement is correct regarding the above statistics collection on the SH.CUSTOMERS table in the above session？（）
    A

     The statistics are stored in the pending statistics table in the data dictionary.

    B

     The statistics are treated as the current statistics by the optimizer for all sessions.

    C

     The statistics are treated as the current statistics by the optimizer for the current sessions only.

    D

     The statistics are temporary and used by the optimizer for all sessions until this session terminates.


    正确答案： A
    解析： 暂无解析

  • 第22题：

    单选题
    Examine the command： SQL> DBMS_STATS.SET_TABLE_PREFS（’SH’， ’CUSTOMERS’， ’PUBLISH’， ’false’）；  Which statementdescribes the effect of the above command（）
    A

    Automatic statistics collection is stopped for the CUSTOMERS table.

    B

    Statistics for the CUSTOMERS table are locked and cannot be overwritten.

    C

    Existing statistics for the CUSTOMERS table become unusable for the query optimizer.

    D

    Subsequently， statistics gathered on the CUSTOMERS table are stored as pending statistics


    正确答案： D
    解析： 暂无解析

  • 第23题：

    多选题
    Examine this command: SQL > exec DBMS_STATS.SET_TABLE_PREFS (‘SH’, ‘CUSTOMERS’, ‘PUBLISH’, ‘false’); Which three statements are true about the effect of this command?（）
    A

    Statistics collection is not done for the CUSTOMERS table when schema stats are gathered.

    B

    Statistics collection is not done for the CUSTOMERS table when database stats are gathered.

    C

    Any existing statistics for the CUSTOMERS table are still available to the optimizer at parse time.

    D

    Statistics gathered on the CUSTOMERS table when schema stats are gathered are stored as pending statistics.

    E

    Statistics gathered on the CUSTOMERS table when database stats are gathered are stored as pending statistics.


    正确答案： E,B
    解析： 暂无解析

相关内容