You work as a database administrator for Certkiller .com. While setting up the database for your production environment， you want to create a user according to the requirements in the exhibit. 
Which three options of the CREATE USER command would you use to achieve this objective？（）

多项选择题YouworkasadatabaseadministratorforCertkiller.com.YouareworkingonOracleDatabase10g.Toforwardclientconnectionstoaninstance，thelistenermustknowinformationsuchasthenameoftheinstanceandwheretheinstance’sORACLE_HOMEislocated.Howdoesthelistenergetthisinformation？（）

A.It gets it from the parameter file.
B.The listener prompts for details on startup.
C.The listener gathers information from the control file.
D.The instance automatically registers with the default listener.
E.The listener gets this information through thelistener.orafile.

单项选择题YouworkasadatabaseadministratorforCertkiller.com.Whilegrantingarole，SELECT_CATALOG_ROLE，toauser，Certkiller，usingOracleEnterpriseManager10gDatabaseControl，youhaveclearedtheDEFAULTcheckbox.Whatwillbetheresult？（）

A.The user cannot use the role at all.
B.The role would not be granted to the user.
C.The user needs to enable the role explicitly.
D.The user can start using the role immediately.
E.The user would have the admin option for the role.

单项选择题You work as a database administrator for Certkiller .com. After being hired， you find that there is only one database that is functional and that is being access by the applications. You want to create a replicate of the database， to be used for testing purposes.  What is the best method to create a replica？（）

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

单项选择题You work as a database administrator for Certkiller .com. Your database is functional. One of the disks containing a mirrored redo log member has bad sectors in it. You are unable to fix the damaged file.  How does the loss of a redo log member affect the instance of the database that is currently running？（）

A.The instance would normally abort.
B.The instance would not be affected.
C.The instance would be invalid， so would have to be aborted.
D.The instance would remain open， but the LGWR process would fail.
E.The instance would remain open and would automatically create the missing file

单项选择题You work as a database administrator for Certkiller .com. In your organization， you have four databases， Certkiller DB01， Certkiller DB02， Certkiller DB03， and Certkiller DB04， which are located in Berlin， Frankfurt，Rammstein， and Munich respectively， and which were created using Database Configuration Assistant （DBCA）.  You want to perform administrative tasks on these databases that include startup and shutdown， taking regular backups， and so on， fromFrankfurtusing Oracle tools. Which Oracle file would you enable to perform this task？（）

A.Control file
B.Password file
C.Parameter file
D.Online redo log file
E.Listener controller file
F.Server parameter file