网友您好， 请在下方输入框内输入要搜索的题目：

题目内容 （请给出正确答案）

An index called ORD_CUSTNAME_IX has been created on the CUSTNAME column in the ORDERS table using the following command:SQL>CREATE INDEX ord_custname_ix ON orders(custname);The ORDERS table is frequently queried using the CUSTNAME column in the WHERE clause.You want to check the impact on the performance of the queries if the index is not available. You do not want the index to be dropped or rebuilt to perform this test.Which is the most efficient method of performing this task?（）

A. disabling the index

B. making the index invisible

C. making the index unusable

D. using the MONITORING USAGE clause for the index

参考答案

更多 “ An index called ORD_CUSTNAME_IX has been created on the CUSTNAME column in the ORDERS table using the following command:SQLCREATE INDEX ord_custname_ix ON orders(custname);The ORDERS table is frequently queried using the CUSTNAME column in the WHERE clause.You want to check the impact on the performance of the queries if the index is not available. You do not want the index to be dropped or rebuilt to perform this test.Which is the most efficient method of performing this task?（）A. disabling the indexB. making the index invisibleC. making the index unusableD. using the MONITORING USAGE clause for the index ” 相关考题
考题 How long() you() a member of the club? A.have,,joinedB.have,,beenC.has,,joinedD.has,,been
查看答案
考题 Why()the old block of flats()demolished next month? A、are…beingB、is…beingC、has…beenD、have…been
查看答案
考题 At last we got the letter we had long () expecting.A. areB. wereC. beD. been
查看答案
考题 Whichfouraretrue?() A.Has-arelationshipsshouldneverbeencapsulated.B.Has-arelationshipsshouldbeimplementedusinginheritance.C.Has-arelationshipscanbeimplementedusinginstancevariables.D.Is-arelationshipscanbeimplementedusingtheextendskeyword.E.Is-arelationshipscanbeimplementedusingtheimplementskeyword.F.Anarrayoracollectioncanbeusedtoimplementaone-to-manyhas-arelationship.G.TherelationshipbetweenMovieandActressisanexampleofanis-arelationship.
查看答案
考题 He is talking so much about America as if he ____ there.A、had beenB、has beenC、wasD、been
查看答案
考题 Examinethefollowingoutput：SQLSELECTindex_name，statusFROMdba_indexesWHEREstatus=’UNUSABLE’；INDEX_NAMESTATUS-----------------------------------------EINDUNUSABLEWhichtwostatementsabouttheaboveindexaretrue（）A.Itisignoredbythequeryoptimizer.B.Itisnotusedwhiletheindexisbeingrebuilt.C.Theindexcannotberebuilt，andhastobere-created.D.Theindexisautomaticallyrebuiltwhenusedthenexttime
查看答案
考题 TheORDERStablebelongstotheuserOE.OEhasgrantedtheSELECTprivilegeontheORDERStabletotheuserHR.WhichstatementwouldcreateasynonymORDsothatHRcanexecutethefollowingquerysuccessfully?() A.CREATESYNONYMordFORorders;ThiscommandisissuedbyOEB.CREATEPUBLICSYNONYMordFORorders;ThiscommandisissuedbyOEC.CREATESYNONYMordFORoe.orders;ThiscommandisissuedbythedatabaseadministratorD.CREATEPUBLICSYNONYMordFORoe.orders;Thiscommandisissuedbythedatabaseadministrator
查看答案
考题 Inwhichsituationwillyourunthescriptcontainingthefollowingstatement？（）CREATECONTROLFILEREUSEDATABASESALESNORESETLOGSARCHIVELOGMAXLOGFILES20MAXLOGMEMBERS3MAXDATAFILES30MAXINSTANCES10MAXLOGHISTORY1200LOGFILEGROUP1（’/disk1/prod/orders/db/log1a.dbf’，’/disk2/prod/orders/db/log1b.dbf’）SIZE100KGROUP2（’/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’；
查看答案
考题 设置多列布局的属性值为（）。A．columns-widthB．column-countC．column-gapD．column-rule
查看答案
热门标签
最新试卷