You want to create a copy of the DEPARTMENTS table. When that is complete， you want to truncate the new DEPARTMENTS table， then restore the data with a direct-load insert from the old DEPARTMENTS table. 
Which CREATE statement should you use？（）

单项选择题WhicharerequiredinitializationparametersinanOracleSharedServerenvironment？（）

A.DISPATCHERS and SHARED_SERVERS
B.DISPATCHERS and MAX_DISPATCHERS
C.MAX_DISPATCHERS and MAX_SHARED_SERVERS
D.SHARED_SERVER_SESSIONS and DISPATCHERS

多项选择题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.