Your application demands frequent connection and disconnection from the database. You have three listener processes that are listening for the database PROD. While setting up the connect string using Oracle Enterprise Manager 10g Database Control， which two options would you select to balance the connection load across all the listener processes？（）

单项选择题Redologfilesaremultiplexedinyourdatabase.Thediskinwhichyouhaveoneoftheredologmembersishighlyfragmented.Intheprocessofdefragmentationyoulosetheredologmember，whichisnotamemberofthecurrentgroup.Howwouldyourecoverfromthelossoftheredologmember？（）

A.SMON would automatically restore the lost file.
B.You would need to restore the whole database from the last backup.
C.You would need to restore the file from the last full database backup.
D.You would need to use flashback technology to restore the lost redo log member.
E.You would need to use Recovery Manager （RMAN） to restore the lost redo log member.
F.You would need to restore the missing log file by copying one of the remaining files from the same group.

多项选择题You decided to increase the value for the SHARED_SERVERS parameter by using the following command：  SQL> ALTER SYSTEM SET SHARED_|SERVERS=3 SCOPE=？；  Which three values can be specified for the SCOPE clause？（）

A.ALL
B.PFILE
C.BOTH
D.NONE
E.SPFILE
F.MEMORY
G.INSTANCE
H.DATABASE

单项选择题Youhavethreedatabases，FINDB，PAYDBandADMINDB，locatedinSydney，TokyoandSingaporerespectively.Youwanttoperformadministrativetaskswhichincludestartingupandshuttingdownthedatabases，creatingandmanagingtablespacesanddatabaseusers，andtakingregularbackups，forallofthethreedatabasesfromLondon.Whichcomponentmustbeenabledandrunningoneachhostmachinetoachieveyourobjective？（）

A.Oracle Management Agent
B.Enterprise Manager with Grid Control
C.Enterprise Manager with Database Control
D.Operating System Socket for incoming requests
E.Real Application Cluster （RAC） with three instances
F.Enterprise Manager with Generic Database Management

单项选择题YouareusingthebackupschedulerinEnterpriseManager（EM）toscheduleabackupofyourdatabase.Whichtypeofscriptdoesthebackupschedulergenerate？（）

A.SQL script
B.PL/SQL script
C.Operating System （OS） script
D.Enterprise Manager （EM） script
E.Recovery Manager （RMAN） script

多项选择题Exhibit： View the Exhibit to see the data in the emp table.  You created a PRIMARY KEY constraint on the empno column of the emp table， and the constraint is not deferred. Which two statements are true in this scenario？ （）

A.No index would be created or used in this case.
B.A unique index on the empno column would be created.
C.A CHECK constraint would be enforced on the empno column.
D.A NOT NULL constraint would be enforced on the empno column.
E.A bitmap unique index would be created on the empno column.