You are working on a very large database. You had performed a binary backup of the control file a month ago. After this you added a few tablespaces， and dropped a couple of tablespaces. This morning， due to hardware failure， you lost all your control files. 
How would you recover the database from this situation？（）

单项选择题IntheinstanceofthePRODdatabase，thecheckpoint（CKPT）processrunsaftereveryminute.AdatabaseuserupdatestherowsoftheORDERStable.Becauseoftheconfiguration，theCKPTprocessgetsinitiatedbeforetheusercommitsthetransaction.WhatwouldhappentothemodifiedblockswhentheCKPTprocessisstarted？（）

A.The modified blocks would be written to the data files.
B.The modified blocks would be written to the temp files.
C.The modified blocks would be written to the control file.
D.The modified blocks would be written to the redo log files.
E.The modified blocks would be written to the archived redo log files.
F.The modified blocks would be retained in the database buffer cache.

单项选择题UsersinyourPRODdatabasecomplainabouttheslowresponseofthetransactions.Whileinvestigatingthereason，youfindthatthetransactionsarewaitingfortheundosegmentstobeavailable，andundoretentionhasbeensettozero.Whatwouldyoudotoovercomethisproblem？（）

A.increase the undo retention
B.create more undo segments
C.create another undo tablespace
D.increase the size of the undo tablespace

单项选择题Thecustomerandordertablesareoftenusedinjoins，therebyresultingincomplexqueries.Youcreatedviewstosimplifythewritingofqueries.Theseviewsarestoredin（）.

A.user tables
B.view segment
C.table segment
D.data dictionary
E.object segment
F.performance tables

单项选择题You manually create an additional listener process，L1，for databases PROD，  PAYDB and FINDB. While starting up the listener process，you get the following error message： LSNRCTL> start l1  Starting  u01 app oracle product 10.1.0 db_1 bin tnslsnr： please wait...  TNSLSNR for Linux： Version 10.1.0.2.0 - Production  System parameter file is  u01 app oracle product 10.1.0 db_1 network admin listener.ora Log messages written to  u01 app oracle product 10.1.0 db_1 network log l1.log Error listening on： （ADDRESS=（PROTOCOL=TCP）（HOST=144.23.230.185）（port=8899））  TNS-12542： TNS：address already in use TNS-12560：  TNS：protocol adapter error TNS-00512： Address already in use  Linux Error： 98： Address already in use  Listener failed to start. See the error message（s） above...  What action would you take to overcome this error without disrupting any existing database communications？（）

A.stop and restart the listener process
B.set the TNS_ADMIN environmental variable
C.stop all running listener processes and restart the listener process
D.change the port number to an unused port number and restart the listener process
E.change the IP address to host machine name in the LISTENER.ORA file and restart the listener process

单项选择题Inyourdatabase，youmaybeforcedtoperformarecoveryusingtheRESETLOGSoptionduringwhichtheredologswouldberesettosequencenumber1.Youwanttoavoidtheoverwritingofoldlogfiles.Whicharchivedlogfilenameformatensuresthis？（）

A.%t_%s.dbf
B.arch_%t.arc
C.arch_%d.arc
D.arch_%t_%d.arc
E.arch_%d_%s_.dbf
F.arch_%t_%s_%r.arc