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
第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’;
第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
第4题:
A.CREATESYNONYMordFORorders;ThiscommandisissuedbyOE
B.CREATEPUBLICSYNONYMordFORorders;ThiscommandisissuedbyOE
C.CREATESYNONYMordFORoe.orders;Thiscommandisissuedbythedatabaseadministrator
D.CREATEPUBLICSYNONYMordFORoe.orders;Thiscommandisissuedbythedatabaseadministrator
第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.
第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::