新时期爱国主义教育的主要内容包括()。

A．Itwouldreturninformationregardingonlythelastcommittedtransaction.

B．Itwouldreturnonlytheactivetransactionsinalltheundosegmentsinthedatabase.

C．Itwouldreturnonlythecommittedtransactionsinalltheundosegmentsinthedatabase.

D．Itwouldreturnbothactiveandcommittedtransactionsinalltheundosegmentsinthedatabase.

E．Itwouldreturninformationregardingthetransactionsthatbeganandwerecommittedinthelast30minutes.

informedthatanimportantrecordofemployeenoE0025ismissingfromtheSCOTT.EMPLOYEEtable.At4：30P.M，thetablecontainedtherecordofemployeenoE0025.WilliamissuesthefollowingcommandtofindtheSQLstatementsthatareusedtoundothedeletion：

SELECToperation，undo_sql，logon_user

FROMFLASHBACK_TRANSACTION_QUERYWHERExid=

HEXTORAW（’0100043E23456’）；

where’0100043E23456’isthetransactionIDofthetransactionthatdeletedtherow.Beforeissuingtheabovestatement，whichtaskdidWilliamperformtoidentifythetransactionIDofthetransactionthatdeletedtherow？（）

Tomakeauditinformationmoreproductive，theDBAexecutesthefollowingcommandbeforestartinganauditoperation：SQL>ALTERSYSTEMSETAUDIT_TRAIL=DB，EXTENDEDSCOPE=SPFILE；WhichstatementistrueregardingtheauditrecordgeneratedwhenauditingstartsafterrestartingThedatabase（）

A.ItcontainsonlytheplanfortheSQLstatementexecutedbytheuser.

B.ItcontainstheSQLtextexecutedbytheuserandthebindvariablesusedwithit.

C.ItcontainstheplanandstatisticsassociatedwiththeSQLstatementexecutedbytheuser.

D.ItcontainstheplanfortheSQLstatementexecutedbytheuserandthebindvariablesusedwithit

A. UNIQUE

B. NOT NULL

C. CHECK

D. PRIMARY KEY

E. FOREIGN KEY

YouworkasadatabaseadministratorforSupportcenter.cn.Whenyoutriedtoconnecttothedatabase，youreceivedthefollowingerror：ERROR：ORA-12541：TNS：no_listenerYoufoundthatthelistenerisnotrunningontheserver，soyouissuedthefollowingcommandintheListenerControlutilitytostartthelistener.lsnrctl>STARTWhatstatementistrue？（）

A.Itwouldattempttostartthedefaultlistener

B.It wouldstartthemostrecentlycreatedlistener.

C.Itwoulddisplayanerrorwithamessageaskingforthelistenernametobespecified.

D.Itwouldshowyoualistoflistenersandpromptsforthelistenernamethatyouwanttostart.

A.Registerdatabasesifgrantedtheregisterdatabaseprivilege

B.Seealldatabasesintherecovery-catalogschema

C.Seealldatabase-relatedmetadataintherecoverycatalogiftheyaregrantedaccesstothatdatabase

D.UnregisterdatabasesfromtheRVPCcatalogthatwerenotgrantedtotheRVPCcatalogownerwiththegrantcommand

E.NotbeconnectedtowiththeRMANcommand-linecatalogparameterforbackuporrecoverypurposes

ablespace called USERS. The database is still running. Which answer properly describes the rder of the steps that you would use to recover from this error?（）1.Shut down the database.2.Take the users_01.dbf datafile offline with the alter database command.3.Restore the users_01.dbf datafile from backup media with the required archived redo logs.4.Restore all users tablespace-related datafiles from backup media.5.Issue the recover tablespace users command.6.Issue the recover datafile users_01.dbf command.7.Start up the database.8.Bring the users_01.dbf datafile online with the alter database command.

A.1，3，6，7

B.2，3，6，8

C.1，2，3，6，7

D.1，2，3，6，，7，8

E.2，3，6，5，7

A. You want to identify the most senior employee in the company.

B. You want to find the manager supervising the largest number of employees.

C. You want to identify the person who makes the highest salary for all employees.

D. You want to rank the top three sales representatives who have sold the maximum number of products.

ringthestorageyoufindthattheblocksizethatyoucanprovideisonly8KB.Whichconfigurationcouldhaveenabledtheblockselectionof16KB（）

A.Choosingtheextentallocationtypetouniform

B.ChoosingtheSegmentSpaceManagementoptiontomanual

C.Settingautoextensiononforthedatafilementionedforthetablespace

D.SettingtheDB_16K_CACHE_SIZEparameterforthedatabaseinstancetoanonzerovalue