A.DISPATCHERS and SHARED_SERVERSB.DISPATCHERS and MAX_D……

多项选择题Whichthreetypesofinformationdoesthecontrolfilecontain？（）

A.Current log sequence.
B.Recover tuning parameters.
C.Redo log names and locations.
D.Data file names and locations.
E.Undo segment names and locations.

单项选择题YouareoperatingyourdatabaseinNOARCHIVELOGmode.Yourmostrecentbackupincludesacopyofallofthedatafilesandthecontrolfilestakenwhenthecurrentlogsequencenumberwas45.YouexperiencediskfailureonthedriveonwhichyourSYSTEMtablespacedatafilesarestored.Atthetimeofthefailure，thecurrentlogsequencenumberis98.WhichfilesshouldyourestoretorecoverfromthelossoftheSYSTEMtablespacedatafiles？（）

A.Only the data files.
B.All of the data files and the control files.
C.Only the data files belonging to the SYSTEM tablespace.
D.Only the data files belonging to the SYSTEM tablespace and the control files.

单项选择题The SET CONTROLFILE AUTOBACKUP FORMAT command， which you can specify either within a RUN block or at the RMAN prompt， overrides the configured autobackup in the session only.  What is the order of precedence？（） 1. SET within RUN  2. SET at RMAN prompt  3. CONFIGURE

A.1,2,3 
B.2,3,1 
C.3,2,1 
D.There is no precedence between RUN and the RMAN prompt. Each will override CONFIGURE in the session. 

多项选择题Inasharedserverconfiguration，whichtwodescribetheactionsthatthelistenercantaketoserviceaclientrequest？（）

A.The listener hands the connection request directly to a dispatcher. 
B.A dedicated server inherits the connection request from the listener. 
C.The client connects to a dedicated server directly using a protocol address provided by the listener. 
D.The application initiating the session spawns a dedicated server process for the connection request. 
E.The listener issues a redirect message to the client, containing the protocol address of a dispatcher. The client then terminates the network session to the listener and establishes a network session to the dispatcher, using the network address provided in the redirect message. 

单项选择题Twodatafileshavebeendeletedattheoperatingsystemlevelbyaccident.YourdatabaseisrunninginARCHIVELOGmodeandonlinebackupsaretakennightly.OneofthedatafilesthathasbeendeletedbelongstotheUSERStablespaceontheotherbelongstotheSYSTEMtablespace.Howcanyourecoverfromthissituation？（）

A.Shut down the database, restore the two data files and then start up the database. 
B.Take the system and users tablespace offline, restore the two data files, recover the two datafiles, and then bring the SYSTEM and USERS tablespaces online. 
C.Shut down the database, restore the two data files, start up the database in MOUNT mode, recover the two data files, and then alter the database open. 
D.Take the SYSTEM and USERS tablespaces offline, recover the two datafiles and then bring the SYSTEM and USERS tablespaces online.