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

题目内容 (请给出正确答案)

The BOOKINGS table contains online booking information. When a booking is confirmed, the details are transferred to an archival table BOOKINGS_HIST and deleted from the BOOKINGS table. There is no fixed time interval between each online booking and its confirmation. Because sufficient space is not always available from the delete operations the high-water mark (HWM) is moved up and many rows are inserted below the HWM of the table. The BOOKINGS table has Automatic Segment Space Management (ASSM) and row movement enabled. The table is accessible in 24x7 mode.What is the most efficient method to reclaim the space released by the delete operations in the BOOKINGS table?()

A. Perform EXPORT, DROP, and IMPORT operations on the BOOKINGS table sequentially

B. Shrink the BOOKINGS table by using the ALTER TABLE SHRINK SPACE command

C. Move the BOOKINGS table to a different location by using the ALTER TABLE MOVE command

D. Deallocate the space in the BOOKINGS table by using the ALTER TABLE DEALLOCATE UNUSED command


参考答案

更多 “ The BOOKINGS table contains online booking information. When a booking is confirmed, the details are transferred to an archival table BOOKINGS_HIST and deleted from the BOOKINGS table. There is no fixed time interval between each online booking and its confirmation. Because sufficient space is not always available from the delete operations the high-water mark (HWM) is moved up and many rows are inserted below the HWM of the table. The BOOKINGS table has Automatic Segment Space Management (ASSM) and row movement enabled. The table is accessible in 24x7 mode.What is the most efficient method to reclaim the space released by the delete operations in the BOOKINGS table?()A. Perform EXPORT, DROP, and IMPORT operations on the BOOKINGS table sequentiallyB. Shrink the BOOKINGS table by using the ALTER TABLE SHRINK SPACE commandC. Move the BOOKINGS table to a different location by using the ALTER TABLE MOVE commandD. Deallocate the space in the BOOKINGS table by using the ALTER TABLE DEALLOCATE UNUSED command ” 相关考题
考题 The sudden snowstorm during the night _________ my decision not to leave. A.discoveredB. inquiredC. chargedD. confirmed

考题 Frown _______ his brow when he was deep in thought. A. contactedB. conductedC. contractedD. confirmed

考题 47_____A. regrettedB. rememberedC. concludedD. confirmed

考题 合法E-mail地址是()。> A.cne@online.sh.cnB.cne.online.sh.cnC.online.sh.cn@cneD.cn.sh.online.shj

考题 Which of the following credit is not mentioned in the passage?A.irrevocableB.revocableC.standbyD.confirmed

考题 合法E-mail地址是()。 A.shi@online.sh.cnB.shj.online.sh.cnC.cn.sh.online.shjD.Online.sh.cn@shj

考题 YouworkwithadatabasenamedDB1,whichislocatedonaSQLServer2005computer.YoudiscoverthatatablescanonTable1inDB1causesaslowquery.Table1isaverylargetablethatisusedfrequently.Youascertainthatthequerycontainsthefollowingstatement.SELECTcol1,col2FROMtable1WHEREcol3=Youneedtoprovidemaximumqueryperformance.Table1mustremainavailabletousers.Whatshouldyoudo?()A.UpdateallstatisticsonTable1inDB1.B.UsetheCREATESTATISTICSstatementinDB1tocreatemissingstatisticsoncol3ofTable1.C.Setthepriorityboostserveroptionto1.D.Executethefollowingstatement.USEDB1GOCREATEINDEXindex1ONtable1(col3)INCLUDE(col1,col2)WITH(ONLINE=ON)GO

考题 3、请完整戏票类的实现代码。并使用测试代码测试该类,测试代码的运行结果应和输出示例完全相同 注意, 1. booking函数的购票失败提示示例如下,编写代码时请复制其中的标点符号,以免由于中英文编码问题导致判分失效 余票(11)不足,购买失败 2. 输出的“:”都是中文“:”

考题 请完整戏票类的实现代码。并使用测试代码测试该类,测试代码的运行结果应和输出示例完全相同 注意, 1. booking函数的购票失败提示示例如下,编写代码时请复制其中的标点符号,以免由于中英文编码问题导致判分失效 余票(11)不足,购买失败 2. 输出的“:”都是中文“:”

考题 若想得到检索结果booking,可使用以下哪种截词检索?A.book?B.book??C.book*D.bookin*