网友您好, 请在下方输入框内输入要搜索的题目:

题目内容 (请给出正确答案)
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.


参考答案

更多 “ Youhavecreatedapasswordfileusingthefollowingcommand:ORAPWDfile=d:\oracle\ora9i\orapwU01password=change_on_installentries=3Whichofthefollowingistrueaboutthispasswordfile?() A.IftheREMOTE_LOGIN_PASSWORDFILEparameterissettoSHAREDintheinitializationparameterfile,thenamaximumofthreeuserscanbegrantedtheSYSDBAorSYSOPERprivileges.B.IftheREMOTE_LOGIN_PASSWORDFILEparameterissettoEXCLUSIVEintheinitializationparameterfile,thenamaximumofthreeuserscanbegrantedtheSYSDBAorSYSOPERprivileges.C.IftheREMOTE_LOGIN_PASSWORDFILEparameterissettoSHAREDintheinitializationparameterfile,thentheSYSDBAandSYSOPERprivilegescanbegrantedtootherusersaslongasspaceinthepasswordfileisD.IftheREMOTE_LOGIN_PASSWORDFILEparameterissettoEXCLUSIVEintheinitializationparameterfile,thentheSYSDBAandSYSOPERprivilegescanbegrantedtootherusersaslongasspaceinthepasswordfileisavailable. ” 相关考题
考题 WhichofthefollowingstatementsistrueregardingtheinitializationparameterDIAGNOSTIC_DEST?()Thedefaultvalueisthevalueoftheenvironmentvariable$ORACLE_HOME;if$ORACLE_HOMEisn’tset A.thenthedefaultissetto$ORACLE_BASE Thedefaultvalueisthevalueoftheenvironmentvariable$ORACLE_BASE;if$ORACLE_BASEisn’tset,B.thenitissetto$ORACLE_HOMEC.DIAGNOSTIC_DESTisalwaysequalto$ORACLE_HOMED.DIAGNOSTIC_DESTisalwaysequalto$ORACLE_BASE

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

考题 YouareaDatabaseAdministratorwithWonderWeb.You&en YouareaDatabaseAdministratorwithWonderWeb.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?()

考题 YouareworkingasaDatabaseAdministrator.Despite&en YouareworkingasaDatabaseAdministrator.Despitehavingapasswordinthedatadictionaryaschange_on_install,youalwayslogontothedatabaseMYNEWDBusingoperatingsystemauthentication.Yourorganizationisplanningtorecruittwojunior-levelDBAs.YoudecidetoenableremoteauthenticationinyourdatabasesothatthenewDBAscanlogontothedatabasefromtheirworkstationstocarryoutadministrativetasks.ToallowthenewDBAstoperformtheadministrativetasks,youcreateapasswordfileonthedatabaseserverusingthefollowingcommand:ORAPWDfile=d:\oracle\ora9i\orapwU01password=adminentries=4Aftercreatingthepasswordfile,youremovetheoperatingsystemauthenticationandchangethevalueoftheREMOTE_LOGIN_PASSWORDFILEparametertoEXCLUSIVE.YoualsocreateanetservicenameasMYNEWDBthatallowsthenewDBAstoconnecttothedatabaseserverfromtheirworkstationsusingthisnetservicename.Whichcommandmustyouusetoconnecttothedatabasetostartit?()

考题 YouarepartoftheDBAteamworkingforaGRANTSYSDBATOjohn;However,youreceivethefollowingerror:ORA-01996:GRANTfailed:passwordfile’c:\oracle\ora9i\dbs\testdb.pwd’isfullWhichactionshouldyoutaketoaddtheuserjohntothepasswordfilewithoutremovinganyoftheexistingusers?()

考题 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.

考题 ouexecutedthecommandtocreateapasswordfileinthedatabaseserver:$orapwdfile=orapworclentries=5ignorecase=NWhichstatementdescribesthepurposeoftheabovepasswordfile() A.ItrecordsusernamesandpasswordsofuserswhengrantedtheDBArole.B.Itcontainsusernamesandpasswordsofusersforwhomauditingisenabled.C.ItisusedbyOracletoauthenticateusersforremotedatabaseadministration.D.ItrecordsusernamesandpasswordsofalluserswhentheyareaddedtoOSDBAorOSOPERoperatingsystemgroups.

考题 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.

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