User SCOTT wants to back out the transactions on the REGIONS table in his schema. As a DBA, which commands must you execute to enable SCOTT to flash back the transactions?() A. ALTER DATABASE FLASHBACK ON;B. GRANT SELECT any transaction TO scott;C. GRANT EXECUTE ON dbms_flashback TO scott;D. ALTER DATABASE ADD SUPPLEMENTAL LOG DATA;E. ALTER TABLESPACE undots1 RETENTION GUARANTEE;F. ALTER DATABASE ADD SUPPLEMENTAL LOG DATA (PRIMARY KEY) COLUMNS;
User SCOTT wants to back out the transactions on the REGIONS table in his schema. As a DBA, which commands must you execute to enable SCOTT to flash back the transactions?()
A. ALTER DATABASE FLASHBACK ON;
B. GRANT SELECT any transaction TO scott;
C. GRANT EXECUTE ON dbms_flashback TO scott;
D. ALTER DATABASE ADD SUPPLEMENTAL LOG DATA;
E. ALTER TABLESPACE undots1 RETENTION GUARANTEE;
F. ALTER DATABASE ADD SUPPLEMENTAL LOG DATA (PRIMARY KEY) COLUMNS;
相关考题:
Susan was determined to become a doctor and her persistence paid _______. (A) back(B) for(C) off(D) out
In the ORACLE system, sets of SQL statements and control flow statements that have been named, compiled ,and stored in database are referred to as storedA.batchesB.proceduresC.triggersD.transactions
You'd better tell him what to do next as soon as he _______ back.A:comeB:cameC:is comingD:comes
YousettheundopoolresourceplandirectivefortheconsumergroupnamedDSS_USERSthatisassignedtotheDAY_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.
Youwanttoenabletheuser,Scott,tochangetotheGRP1consumergroupbyissuingthefollowingcode:SQLEXECDBMS_SESSION.SWITCH_CURRENT_CONSUMER_GROUP(’SCOTT’,’GRP1’,FALSE);Howwillyougranttheswitchprivilegetotheuser,Scott?()A.byusingtheDBMS_SESSIONpackageB.bygrantingtheDBAroleC.byusingtheDBMS_RESOURCE_MANAGERpackageD.byusingtheDBMS_RESOURCE_MANAGER_PRIVSpackage
Youissuethefollowingcode:EXECDBMS_RESOURCE_MANAGER_PRIVS.GRANT_SWITCH_CONSUMER_GROUP(’SCOTT’’GRP1’,TRUE);Whatwillbetheresultofexecutingtheabovecode?() A.Theswitchprivilegewillbegrantedtotheuser,Scott,forchangingtheconsumergrouptoGRP1.B.Theswitchprivilegewillbegrantedtotheuser,Scott,forchangingtheconsumergroupfromGRP1toanyothergroup.C.ThecodewillnotexecutesuccessfullybecausethereisnoGRANT_SWITCH_CONSUMER_GROUPprocedureintheDBMS_RESOURCE_MANAGER_PRIVSpackage.D.Thecodewillexecutesuccessfullybutnoprivilegewillbegrantedtotheuser,Scott.
WhatwillbetheresultofusingtheSQL>DROPUSERSCOTTCASCADE;command?() 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.
Make( )copies of important files, and store them on separate locations to protect your information.A.back B.back-up C.back-out D.background
4.检索和名叫SCOTT的员工相同工资的员工信息,但不显示SCOTT。显示字段:员工号、员工名、工资。