定额管理基础较好，各项消耗定额或费用定额比较准确、稳定，但各月末在产品数量变化较大的产品，其在

DAY_SHIFTplan.Thedatabaseusers，SCOTTandBLAKE，belongtotheDSS_USERSresourcegroup.Theuser，SCOTT，initiatesadatabasesessionandexecutesabatchoperationthatinsertsmillionsofrowsintotheHISTORYtable.WhichtwooptionsaretrueifthetotalundospaceallocatedtotheDSS_USERSgroupexceedsthevaluespecifiedintheundopoolresourceplandirective？（）

A.Thebatchoperationstartedbytheuser，SCOTT，terminateswithanerror.

B.Thebatchoperationstartedbytheuser，SCOTT，hangsandyouarerequiredtoincreasetheundopoolresourceplandirective.

C.Thebatchoperationstartedbytheuser，SCOTT，runsuninterruptedbecausethedatabaseusestheSYSTEMtablespacefortheundooperation.

D.Theuser，BLAKE，cannotstartatransactionthatusesanyDMLoperationsuntilyouincreasethevalueoftheundopoolresourceplandirective.

E.TheuserBLAKEcanstartatransactionthatusesanyDMLoperationsafterthebatchoperationstartedbytheuser，SCOTT，terminateswithanerror.

A．Mr. Scott.

B．Mr. Scott's son.

C．Mr. Scott's grandpa.

D．Mr. Scott's father.

A、update user scott account unlock;

B、alter user scott account unlock;

C、alter user scott unlock;

D、user scott unlock;

A.Theswitchprivilegewillbegrantedtotheuser，Scott，forchangingtheconsumergrouptoGRP1.

B.Theswitchprivilegewillbegrantedtotheuser，Scott，forchangingtheconsumergroupfromGRP1toanyothergroup.

C.ThecodewillnotexecutesuccessfullybecausethereisnoGRANT_SWITCH_CONSUMER_GROUPprocedureintheDBMS_RESOURCE_MANAGER_PRIVSpackage.

D.Thecodewillexecutesuccessfullybutnoprivilegewillbegrantedtotheuser，Scott.

A．Theuser，Scott，isdropped，alltheobjectsinScott’sschemaareplacedintheRecycleBin，andtheobjectsthatarealreadyintheRecycleBinaredropped.

B．Theuser，Scott，isdropped，alltheobjectsinScott’sschemaareplacedintheRecycleBin，andalltheobjectsintheRecycleBin，belongingtotheuserScott，arenotdropped.

C．Theuser，Scott，isdropped，alltheobjectsintheScott’sschemaarenotplacedintheRecycleBin，andtheobjectsintheRecycleBin，belongingtotheuser，Scott，arenotdropped.

D．Theuser，Scott，isdropped，alltheobjectsinScott’sschemaarenotplacedintheRecycleBin，andtheobjectsintheRecycleBinaredropped.

在Oracle中，将scott的缺省表空间改为data2_ts，下列哪个是正确的？()

A、ALTER USER scott DEFAULT TABLESPACE data2_ts

B、ALTER DEFAULT TABLESPACE data2_ts USER scott

C、ALTER USER scott TABLESPACE DEFAULT data2_ts

D、ALTER scott USER DEFAULT TABLESPACE data2_ts

What will Mr. Grant do to Mr. Scott's idea？

A．He will think about Mr. Scott's idea.

B．He will copy Mr. Scott's idea.

C．He will object to Mr. Scott's idea.

在Oracle中，用ALTER将scott的口令改为hello，下列哪个是正确的？（）

A.ALTER USER scott IDENTIFIED BY hello

B.ALTER scott USER IDENTIFIED BY hello

C.ALTER USER scott IDENTIFIED AS hello

D.ALTER USER hello IDENTIFIED BY scott

______ we first heard of the man referred to as a journalist.

A．That was from Scott

B．It was from Scott that

C．It was Scott whom

D．It was Scott that