niusouti.com
更多“How many orders are included in standard ship orders? Can you list some? ”相关问题
  • 第1题:

    UsersinyourproductiondatabasecomplainthattheyaregettingthefollowingerrormessagewhiletryingtoinsertrowsintotheORDERStable:ERRORatline1:ORA01654:unabletoextendindexUSERS.ORDERS_INDby8intablespaceINDEXESWhileinvestigating,youfindthattheINDEXEStablespacehasrunoutofspaceandthereisnomorefreespaceonthediskwherethedatafilesareavailable.Whichtwoactionscouldyouperformtoovercomethiserrorwithoutaffectingthequeriesthatarecurrentlybeingexecuted?()

    A.dropandrecreatetheindex

    B.coalescetheORDERS_INDindex

    C.coalescetheINDEXEStablespace

    D.dropandrecreatetheORDERStable

    E.rebuildtheindexonlineandmoveittoanothertablespace


    参考答案:B, E

  • 第2题:

    Inwhichsituationwillyourunthescriptcontainingthefollowingstatement?()

    CREATECONTROLFILEREUSEDATABASESALESNORESETLOGSARCHIVELOG

    MAXLOGFILES20

    MAXLOGMEMBERS3

    MAXDATAFILES30

    MAXINSTANCES10

    MAXLOGHISTORY1200

    LOGFILE

    GROUP1(

    ’/disk1/prod/orders/db/log1a.dbf’,

    ’/disk2/prod/orders/db/log1b.dbf’

    )SIZE100K

    GROUP2(

    ’/disk1/prod/orders/db/log2a.dbf’,

    ’/disk2/prod/orders/db/log2b.dbf’

    )SIZE100K,

    DATAFILE

    ’/disk1/prod/orders/db/database1.dbf’,

    ’/disk2/prod/orders/db/file1.dbf’;


    参考答案:B

  • 第3题:

    有如下类定义: class Point{ private: static int how_many; }; ______how_many=0; 要初始化Point类的静态成员how_many,下划线处应填入的内容是

    A.int

    B.static int

    C.int Point: :

    D.static int Point


    正确答案:C
    解析:static int n;是定义静态全局变量,int point是定义类的。

  • 第4题:

    TheORDERStablebelongstotheuserOE.OEhasgrantedtheSELECTprivilegeontheORDERStabletotheuserHR.WhichstatementwouldcreateasynonymORDsothatHRcanexecutethefollowingquerysuccessfully?()

    A.CREATESYNONYMordFORorders;ThiscommandisissuedbyOE

    B.CREATEPUBLICSYNONYMordFORorders;ThiscommandisissuedbyOE

    C.CREATESYNONYMordFORoe.orders;Thiscommandisissuedbythedatabaseadministrator

    D.CREATEPUBLICSYNONYMordFORoe.orders;Thiscommandisissuedbythedatabaseadministrator


    参考答案:D

  • 第5题:

    On your Oracle 12c database, you Issue the following commands to create indexesSQL > CREATE INDEX oe.ord_customer_ix1 ON oe.orders (customers_id, sales_rep_id) INVISIBLE;SQL> CREATE BITMAP INDEX oe.ord_customer_ix2 ON oe.orders (customers_id, sales_rep_id);Which two statement are correct?()

    A. Both the indexes are created; however, only the ORD_COSTOMER index is visible.

    B. The optimizer evaluates index access from both the Indexes before deciding on which index to use for query execution plan.

    C. Only the ORD_CUSTOMER_IX1 index is created.

    D. Only the ORD_CUSTOMER_IX2 index is created.

    E. Both the indexes are updated when a new row is inserted, updated, or deleted In the orders table.


    参考答案:A, E

  • 第6题:

    有如下类定义: class Point{ private: static int how_many; }; ___________how_many=0; 要初始化Point类的静态成员how_many,下画线处应填入的内容是( )。

    A.int

    B.static int

    C.int Point::

    D.static int Point::


    正确答案:C
    本题考查静态数据成员,静态数据成员可以初始化,但只能在类体外进行初始化,其一般形式为:数据类型类名::静态数据成员名=初值。所以本题答案为C。