Redo log files are multiplexed in your database. The disk in which you have one of the redo log members is highly fragmented. In the process of defragmentation you lose the redo log member， which is not a member of the current group. How would you recover from the loss of the redo log member？（）

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

多项选择题You are creating a locally managed tablespace to meet the following requirements： All the extents should be of the same size.  The data should be spread across two data files.  A bitmap should be used to record the free space within the allocated extents. Which three options would you choose？（）

A.set PCTFREE and PCTUSED to 50
B.specify extent allocation as Uniform
C.specify extent allocation as Automatic
D.create the tablespace as bigfile tablespace
E.create the tablespace as smallfile tablespace
F.set segment space management to Automatic
G.use the RESIZE clause while creating the tablespace