多项选择题

A.It gets it from the parameter file.B.The listener pro……

You work as a database administrator for Supportcenter.cn. You are working on Oracle Database 10g. To forward client connections to an instance， the listener must know information such as the name of the instance and where the instance’s ORACLE_HOME is located. How does the listener get this information？（）

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

多项选择题YouworkasadatabaseadministratorforSupportcenter.cn.Youwanttocreateyourdatabasewiththeautomaticundomanagementfeatureenable.Whichtwotasksmustyouperformtoachievethis？（）

A.Set the UNDO_RETENTION parameter to AUTO.
B.Create an initial undo segment in undotablespace.
C.Set the UNDO_RETENTION parameter to 900 or more
D.Set the initialization parameter UNDO_MANAGEMENT to AUTO
E.Set the UNDO_MANAGEMENT parameter to the name of an undotablespace