niusouti.com

Youhavecreatedapasswordfileusingthefollowingcommand:ORAPWDfile=d:\oracle\ora9i\orapwU01password=change_on_installentries=3Whichofthefollowingistrueaboutthispasswordfile?()A.IftheREMOTE_LOGIN_PASSWORDFILEparameterissettoSHAREDintheinitializationparameterfi

题目
Youhavecreatedapasswordfileusingthefollowingcommand:ORAPWDfile=d:\oracle\ora9i\orapwU01password=change_on_installentries=3Whichofthefollowingistrueaboutthispasswordfile?()

A.IftheREMOTE_LOGIN_PASSWORDFILEparameterissettoSHAREDintheinitializationparameterfile，thenamaximumofthreeuserscanbegrantedtheSYSDBAorSYSOPERprivileges.

B.IftheREMOTE_LOGIN_PASSWORDFILEparameterissettoEXCLUSIVEintheinitializationparameterfile，thenamaximumofthreeuserscanbegrantedtheSYSDBAorSYSOPERprivileges.

C.IftheREMOTE_LOGIN_PASSWORDFILEparameterissettoSHAREDintheinitializationparameterfile，thentheSYSDBAandSYSOPERprivilegescanbegrantedtootherusersaslongasspaceinthepasswordfileis

D.IftheREMOTE_LOGIN_PASSWORDFILEparameterissettoEXCLUSIVEintheinitializationparameterfile，thentheSYSDBAandSYSOPERprivilegescanbegrantedtootherusersaslongasspaceinthepasswordfileisavailable.

相似考题

1.WhichofthefollowingstatementsistrueregardingtheinitializationparameterDIAGNOSTIC_DEST?()Thedefaultvalueisthevalueoftheenvironmentvariable$ORACLE_HOME;if$ORACLE_HOMEisn’tsetA.thenthedefaultissetto$ORACLE_BASE Thedefaultvalueisthevalueoftheenvironmentvariable$ORACLE_BASE；if$ORACLE_BASEisn’tset，B.thenitissetto$ORACLE_HOMEC.DIAGNOSTIC_DESTisalwaysequalto$ORACLE_HOMED.DIAGNOSTIC_DESTisalwaysequalto$ORACLE_BASE

2.YouareaDatabaseAdministratorwithWonderWeb.You&enYouareaDatabaseAdministratorwithWonderWeb.YouuseapasswordfiletoestablishconnectionstotheSalesdatabaselocatedontheserver.Youcreatedthepasswordfileusingthefollowingcommand：ORAPWDfile=d：\oracle\ora9i\orapwU01password=adminentries=4Youerroneouslydeletedthepasswordfilewhilethedatabasewasrunning.Youre-createthepasswordfileusingthefollowingcommand：ORAPWDfile=d：\oracle\ora9i\orapwU01password=change_on_installentries=4However，whenyoutrytoconnectastheSYSuser，youreceivethefollowingerror：ORA-01031：insufficientprivilegesWhatshouldyoudotoresolvethiserror？（）

3.YouareworkingasaDatabaseAdministrator.Despite&enYouareworkingasaDatabaseAdministrator.Despitehavingapasswordinthedatadictionaryaschange_on_install，youalwayslogontothedatabaseMYNEWDBusingoperatingsystemauthentication.Yourorganizationisplanningtorecruittwojunior-levelDBAs.YoudecidetoenableremoteauthenticationinyourdatabasesothatthenewDBAscanlogontothedatabasefromtheirworkstationstocarryoutadministrativetasks.ToallowthenewDBAstoperformtheadministrativetasks，youcreateapasswordfileonthedatabaseserverusingthefollowingcommand：ORAPWDfile=d：\oracle\ora9i\orapwU01password=adminentries=4Aftercreatingthepasswordfile，youremovetheoperatingsystemauthenticationandchangethevalueoftheREMOTE_LOGIN_PASSWORDFILEparametertoEXCLUSIVE.YoualsocreateanetservicenameasMYNEWDBthatallowsthenewDBAstoconnecttothedatabaseserverfromtheirworkstationsusingthisnetservicename.Whichcommandmustyouusetoconnecttothedatabasetostartit？（）

4.Youexecutedthecommandtocreateapasswordfileinthedatabaseserver:$orapwdfile=orapworclentries=5ignorecase=NWhichstatementdescribesthepurposeoftheabovepasswordfile()A.ItrecordsusernamesandpasswordsofuserswhengrantedtheDBArole.B.Itcontainsusernamesandpasswordsofusersforwhomauditingisenabled.C.ItisusedbyOracletoauthenticateusersforremotedatabaseadministration.D.ItrecordsusernamesandpasswordsofalluserswhentheyareaddedtoOSDBAorOSOPERoperatingsystemgroups

更多“Youhavecreatedapasswordfileusingthefollowingcommand:ORAPWDfile=d:\oracle\ora9i\orapwU01password=change_on_installentries=3Whichofthefollowingistrueaboutthispasswordfile?() ”相关问题

  • 第1题：

    YouarepartoftheDBAteamworkingfora&en

    YouarepartoftheDBAteamworkingforamultinationalbank.Theteamisresponsibleforperformingadministrativetasksonthedatabaseserverlocatedatthehomeoffice.ThedatabaseserveratthehomeofficehasaproductiondatabaseandatestdatabasenamedTESTDB.Thetestdatabaseisprimarilyusedfortestingdatabasecommandsandconfigurationsettingsbeforimplementingthesesettingsontheproductiondatabase.Thetestdatabaseisalsousedforthedevelopmentofdatabaseapplications.YouhavebeenaskedbytheseniorDBAtogranttheSYSDBAprivilegetoanewteammember，John，sothathecanperformsomeadministrativetasks，suchasshutdownandstartupoperations，onTESTDB.YouusethepasswordfiletoconfigureremoteauthenticationontheTESTDBdatabase.Youexecutethefollowingstatementtograntthe SYSDBAprivilegetoJohn：

    SQL>GRANTSYSDBATOjohn；

    However，youreceivethefollowingerror：

    ORA-01996：GRANTfailed：passwordfile

    ’c：\oracle\ora9i\dbs\testdb.pwd’isfull

    Whichactionshouldyoutaketoaddtheuserjohntothepasswordfilewithoutremovinganyoftheexistingusers？（）


    参考答案：B

  • 第2题：

    ouexecutedthecommandtocreateapasswordfileinthedatabaseserver:$orapwdfile=orapworclentries=5ignorecase=NWhichstatementdescribesthepurposeoftheabovepasswordfile()

    A.ItrecordsusernamesandpasswordsofuserswhengrantedtheDBArole.

    B.Itcontainsusernamesandpasswordsofusersforwhomauditingisenabled.

    C.ItisusedbyOracletoauthenticateusersforremotedatabaseadministration.

    D.ItrecordsusernamesandpasswordsofalluserswhentheyareaddedtoOSDBAorOSOPERoperatingsystemgroups.


    参考答案：C

  • 第3题：

    Oracle服务器由Oracle 【】 和Oracle实例组成


    正确答案：数据库
    一个Oracle服务器由Oracle数据库和Oracle实例组成，Oracle数据库是存储数据的集合，它包括日志文件和控制文件，Oracle实例是一些进程

  • 第4题：

    You Execute the Following command to create a password file in the database server:$ orapwd file = ‘+DATA/PROD/orapwprod entries = 5 ignorecase = N format = 12’Which two statements are true about the password file?（）

    A. It records the usernames and passwords of users when granted the DBA role.

    B. It contains the usernames and passwords of users for whom auditing is enabled.

    C. Is used by Oracle to authenticate users for remote database administration.

    D. It records the usernames and passwords of all users when they are added to the OSDBA or OSOPER operating system groups.

    E. It supports the SYSBACKUP, SYSDG, and SYSKM system privileges.


    参考答案：C, E

  • 第5题：

    You executed this command to create a password file:$ orapwd file = orapworcl entries = 10 ignorecase = NWhich two statements are true about the password file?()

    A. It will permit the use of uppercase passwords for database users who have been granted the SYSOPER role.

    B. It contains username and passwords of database users who are members of the OSOPER operating system group.

    C. It contains usernames and passwords of database users who are members of the OSDBA operating system group.

    D. It will permit the use of lowercase passwords for database users who have granted the SYSDBA role.

    E. It will not permit the use of mixed case passwords for the database users who have been granted the SYSDBA role.


    参考答案：A, D

相关内容