推动我国先进生产力发展和社会全面进步的根本力量是（)。A．人民军队B．工人阶级、广大农民和知识分子

A.ItispossibletohavemultipledatabasewritersinanOracleinstance.

B.Itwritesdirtybuffers，ifany，todatafileswheneveracheckpointoccurs.

C.Itwritesdirtybuffers，ifany，todatafileswheneveratransactioncommits.

D.Itwritesdirtybuffers，ifany，todatafilesbeforethelogwriter（LGWR）writes

wing steps:1.Restore the database datafiles.2.Issue the alter database clear unarchived logfile group 1 command.3.Issue the alter database open command.4.Issue the alter database open resetlogs command.5.Recover the database using point-in-time recovery.6.Issue the Startup Mount command to mount the database.7.Back up the database.Which is the correct order of these steps in this case?（）

A. 1,6,5,4,7

B. 6,5,4

C. 6,2,3,7

D. 1,6,3

E. The database cannot be recovered

A. You cannot specify MEMORY_TARGET if you explicitly specify SGA_TARGET or PGA_AGGREGATE_TARGET values that are greater than zero in your parameter file.

B. Oracle can reallocate memory between the SGA and PGA automatically as needed.

C. To use Automatic Memory Management, you must explicitly set both the MEMORY_TARGET and MEMORY_MAX_TARGET parameters in your parameter file.

D. You can set the MEMORY_TARGET parameter to a maximum value of the current SGA size plus the current PGA size.

A.Itwouldreturninformationregardingonlythelastcommittedtransaction.

B.Itwouldreturnonlytheactivetransactionsinalltheundosegmentsinthedatabase.

C.Itwouldreturnonlythecommittedtransactionsinalltheundosegmentsinthedatabase.

D.Itwouldreturnbothactiveandcommittedtransactionsinalltheundosegmentsinthedatabase.

E.Itwouldreturninformationregardingthetransactionsthatbeganandwerecommittedinthelast30minutes.

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