You work as a database administrator for Supportcenter.cn. 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？（）

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

单项选择题YouworkasadatabaseadministratorforSupportcenter.cn.Whilegrantingarole，SELECT_CATALOG_ROLE，toauser，SupportCenter，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.

单项选择题Exhibit， error You work as a database administrator for Supportcenter.cn. When you try to connect to the database， you get an error （See exhibit）. What could be the possible reason for getting such an error？（）

A.Database is not open
B.Listener is not running
C.Service name is not correct
D.Wrong port number used in URL
E.Usersysdoes have themediaprivilege

单项选择题YouworkasadatabaseadministratorforSupportcenter.cn.Yourdatabaseisfunctional.Oneofthediskscontainingamirroredredologmemberhasbadsectorsinit.Youareunabletofixthedamagedfile.Howdoesthelossofaredologmemberaffecttheinstanceofthedatabasethatiscurrentlyrunning？（）

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

单项选择题YouworkasadatabaseadministratorforSupportcenter.cn.Inyourorganization，youhavefourdatabases，SupportCenterDB01，SupportCenterDB02，SupportCenterDB03，andSupportCenterDB04，whicharelocatedinBerlin，Frankfurt，Rammstein，andMunichrespectively，andwhichwerecreatedusingDatabaseConfigurationAssistant（DBCA）.Youwanttoperformadministrativetasksonthesedatabasesthatincludestartupandshutdown，takingregularbackups，andsoon，fromFrankfurtusingOracletools.WhichOraclefilewouldyouenabletoperformthistask？（）

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