OnMonday,youdroppedtheDEPTtablefromyourschemaandthenyourecreatedtheDEPTtableinyourschema.OnWednesday,youhavearequirementtorestoretheDEPTtablefromtherecyclebin.Whichstatementiscorrect?()A.YoucanrestoretheDEPTtablebyusingtheOracleFlashbackDropfeature，provid

题目
OnMonday,youdroppedtheDEPTtablefromyourschemaandthenyourecreatedtheDEPTtableinyourschema.OnWednesday,youhavearequirementtorestoretheDEPTtablefromtherecyclebin.Whichstatementiscorrect?()

A.YoucanrestoretheDEPTtablebyusingtheOracleFlashbackDropfeature，providedyouusetheRENAMETOclause.

B.YoucanrestoretheDEPTtablebyusingtheOracleFlashbackDropfeatureandasystemgeneratednamewillbeassignedtotherestoredtable.

C.YoucannotrestoretheDEPTtablebyusingtheOracleFlashbackDropfeaturebecauseatablewiththenameDEPTalreadyexistsinyourschema.

D.YoucannotrestoretheDEPTtablebyusingtheOracleFlashbackDropfeaturebecausethecontentsoftherecyclebinarepurgedevery12hoursbydefault.

相似考题

1.CYBER MONDAY CLICKS IN WITH RECORD SALES Cyber Monday rocked while mobile sales roared. The day widely regarded as the Super Bowl of online sales created a record day for retailers, including Walmart, and marked a shift in shopping preferences as smartphones and tablets drove nearly a third of traffic — and for some retailers, more than half.? W expects to register its biggest Cyber Monday yet, coming off a record Black Friday weekend online. Heading into the afternoon Monday, the website had already sold out of PlayStation 4 and Xbox One consoles, which weren't even discounted. Significant savings on TVs and tablets also encouraged shopping, says Joel Anderson, CEO of W. Retailers from Target to Sears are fast evolving Cyber Monday into something more akin to Cyber Week, as online deals stretch well beyond Monday. As of 6 p.m. ET, sales on Amazon were up 44.3% over last year, while sales at eBay were up 32.1%, according to Channel Advisor, which tracks third-party sellers on eBay and Amazon. The online marketplaces are doing well in part because shoppers are heading to those sites to find popular products that are selling out at regular retailers, says Scot Wingo, CEO of Channel Advisor. Flash-sale site Rue La La started Cyber Monday deals on Sunday with a “Cyberthon” that drew more than 350,000 people to the site. The sale promoted as much as 80% off on more than 150 brands. On Monday, sales of Cole Haan and Pandora Jewelry merchandise were strongest, CEO Steve Davis says.1. Retailers used mobile devices and drove nearly a third of traffic, or even more than half to online shopping. As we know that doesn't belong to the mobile device.()A. tabletsB. smartphonesC. personal computer2. PlayStation 4 and Xbox One consoles were sold out on the afternoon Monday although they weren't even discounted.()A. eBB. WC. A3. According to sales on Amazon were up 44.3% over last year, while sales at eBay were up 32.1%.()A. WalmartB. Rue La LaC. Channel Advisor4. Cyber Monday deals on Sunday with a “Cyberthon” that drew more than people to the site. ()A. 350,000B. 35,000C. 3,500,0005. We can infer from the passage _____ isn't an online retailer. ()A. SearsB. Channel AdvisorC. Walmart

2.OnMonday,youdroppedtheDEPTtablefromyourschemaandthenyoure－createdtheDEPTtableinyourschema.OnWednesday,youhavearequirementtorestoretheDEPTtablefromtherecyclebin.Whichstatementiscorrect?()A.YoucanrestoretheDEPTtablebyusingtheOracleFlashbackDropfeature，providedyouusetheRENAMETOclause.B.YoucanrestoretheDEPTtablebyusingtheOracleFlashbackDropfeatureandasystem-generatednamewillbeassignedtotherestoredtable.C.YoucannotrestoretheDEPTtablebyusingtheOracleFlashbackDropfeaturebecauseatablewiththenameDEPTalreadyexistsinyourschema.D.YoucannotrestoretheDEPTtablebyusingtheOracleFlashbackDropfeaturebecausethecontentsoftherecyclebinarepurgedevery12hoursbydefault.

3.YouaremaintainingyourdatabaseinOracle10g.Youperformafulluser-managedbackupeverySundayat8：00P.M.YourdatabaseisrunninginARCHIVELOGmode.OnMonday，at9：00A.M.，atablespaceisdropped.Youdecidetoperformincompleterecoverytorecoverthedroppedtablespace.WhichtwoclausescanyouusewiththeRECOVERcommand？（）A.UNTILSEQUENCEB.UNTILSCNC.UNTILCHANGED.UNTILCANCEL

4.Meeting NoticeTo: All salesmenSubject: The Year-end Sales Meeting From: Tracy, SecretaryThe last sales meeting for 2018 will be 1) _______ on Monday, December 17th 9:00 a.m. 2) _______ 3:00 p.m. at the Head Office.Lunch will be 3) ________.The 4) _________ will be mailed by the end of November.If you have any items to be included, please forward them to me by November 20th. If you are unable to 5) ________, please call 63419403, not later than November 30th.Thank you.

参考答案和解析
参考答案：A
更多“OnMonday,youdroppedtheDEPTtablefromyourschemaandthenyourecreatedtheDEPTtableinyourschema.OnWednesday,youhavearequirementtorestoretheDEPTtablefromtherecyclebin.Whichstatementiscorrect?() ”相关问题

  • 第1题：

    YouaremaintainingthePRODdatabaseforNetFxCorporation.Youhaveconfiguredcontrolfileautobackupinyourdatabase.At6：00P.M.onMonday，youissuethefollowingcommand：RMAN>BACKUPDATABASE；At8：00A.M.onTuesday，youareunabletostartthedatabasebecauseallthecontrolfilesaremissing.YoudecidetorestorethecontrolfilesfromthebackupbyusingtheRMAN>RESTORECONTROLFILEFROMAUTOBACKUP；command.WhichoperationshouldyouperformbeforeusingtheRMAN>RESTORECONTROLFILEFROMAUTOBACKUP；command？（）


    参考答案：C

  • 第2题：

    YourdatabaseisrunninginNOARCHIVELOGmodewith&ensp

    YourdatabaseisrunninginNOARCHIVELOGmodewithtwoonlineredologfiles.TheSALEStablecontainssalesinformationfortheorganization.TheSALEStablebelongstotheSALESTBtablespace.OnMonday，youinsert10rowsintotheSALEStable.Thecurrentlogsequencenumberis14.YouchangethetablespacestatusfromREADWRITEtoREADONLYfortheSALESTBtablespace.YoushutdownthedatabaseandtakeabackupoftheSALESTBtablespace.

    OnTuesday，youstartthedatabase.YouchangethestatusfortheSALESTBtablespacefromREADONLYtoREADWRITE.Youinsert10morerowsintotheSALEStableandshutdownthedatabase.Thecurrentlogsequencenumberis15.

    WhenyoutrytoopenthedatabaseonWednesdaymorning，youdiscoverthattheSALESTBtablespacewaslostbecauseofamediafailure.WhichofthefollowingoptionsistrueaboutrecoveringtheSALEStable？（）


    参考答案：C

  • 第3题：

    Beth: Did you hear that Ron was in the hospital?

    Mimi: Oh, really?( 56 ) with him?

    Beth: He's got a very high temperature. I guess it may be cholera (霍乱).

    Mimi: Cholera! How in the world did( 57 ) ?

    Beth: Who knows?!

    Mimi: ( 58 ) for a long time?

    Beth: For a couple of weeks, apparently. But he only( 59 ) on Monday.

    Mimi: Why did he wait so long? He should have seen a doctor earlier.

    Beth: Yes, I know. But luckily the doctor says if he stays in the hospital for a few weeks, be should be able to improve.

    Mimi: Gee,( 60 ) .

    A. it come

    B. I hope so

    C. he get that

    D. was sick

    E. What’ s the matter

    F. What happened

    G. Has he been sick

    H. went to see the doctor


    正确答案：E,C,G,H,B

  • 第4题：

    YouareworkingasaDBAinacompany.Thedatafilesinthedatabaseareasfollows：OnMonday，youtriedtostartupthedatabasebutfailedbecauseallthecontrolfilesweremissing.YourecreatedthecontrolfileusingthescriptyouhavecreatedbyissuingtheALTERDATABASEBACKUPCONTROLFILETOTRACEcommand.Whatistheprerequisiteforrecreatingthecontrolfile？（）

    A.AllthedatafilesshouldbelistedintheCREATECONTROLFILEstatement.

    B.TheDATA2.dbfandDATA3.dbfdatafilesshouldbelistedintheCREATECONTROLFILEstatement.

    C.TheSYSTEM01.dbfdatafileshouldbelistedintheCREATECONTROLFILEstatement.

    D.TheSYSAUX01.dbfdatafileshouldbelistedintheCREATECONTROLFILEstatement.


    参考答案：B

  • 第5题：

    YourdatabaseisinARCHIVELOGmode.OnFridayevening，youperformanonlinedatabasebackupbyusingtheBACKUPDATABASEcommandattheRecoveryManager（RMAN）promptandclosethe

    database.OnMonday，theSystemAdministratorinformsyouaboutthefailureoftwoharddisks.Oneofthelostdiskscontainstwodatafiles，HR1.DBFandHR2.DBF，bothofwhichbelongtoaread/writetablespacenamedHR.Thediskalsocontainsadatafile，USERS.DBF，whichbelongstoaread/writetablespacenamedUSERS.YouneedtorestoreandrecoverthedatabasebackupthatwasperformedonFridayevening.Aftermountingthedatabase，youissuethefollowingRMANcommands：

    RMAN>RESTOREDATABASE；

    RMAN>RECOVERDATABASE；

    AftersuccessfullyexecutingtheseRMANcommands，youissuethefollowingstatementusingSQL*Plus：

    SQL>ALTERDATABASEOPEN；

    Youreceivethefollowingerrorswhenattemptingtoopenthedatabase：

    ORA-01157：cannotidentify/lockdatafile10seeDBWRtracefile

    ORA-01110：datafile10：’D：\USERS.DBF’

    Whatisthecauseoftheseerrors？（）


    参考答案：C

相关内容