A.SPFILEB.archive logC.control fileD.system tablespaceY……

单项选择题You are using RMAN to perform a closed database backup of your database. You issue these RMAN commands： STARTUP MOUNT； BACKUP  FORMAT ’ BACKUP df_%d_%s_%p.bus’  DATABASE filesperset = 2；  Which components are included in the backup？（）

A.Only the data files.
B.Only the data files and the online logs.
C.The data files， control files， and the online logs.
D.The data files and control files， but not the online logs.

单项选择题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？（）

A.A
B.B
C.C
D.D

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