A.IftheREMOTE_LOGIN_PASSWORDFILEparameterissettoSHAREDintheinitializationparameterfile,thenamaximumofthreeuserscanbegrantedtheSYSDBAorSYSOPERprivileges.
B.IftheREMOTE_LOGIN_PASSWORDFILEparameterissettoEXCLUSIVEintheinitializationparameterfile,thenamaximumofthreeuserscanbegrantedtheSYSDBAorSYSOPERprivileges.
C.IftheREMOTE_LOGIN_PASSWORDFILEparameterissettoSHAREDintheinitializationparameterfile,thentheSYSDBAandSYSOPERprivilegescanbegrantedtootherusersaslongasspaceinthepasswordfileis
D.IftheREMOTE_LOGIN_PASSWORDFILEparameterissettoEXCLUSIVEintheinitializationparameterfile,thentheSYSDBAandSYSOPERprivilegescanbegrantedtootherusersaslongasspaceinthepasswordfileisavailable.
第1题:
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?()
第2题:
A.ItrecordsusernamesandpasswordsofuserswhengrantedtheDBArole.
B.Itcontainsusernamesandpasswordsofusersforwhomauditingisenabled.
C.ItisusedbyOracletoauthenticateusersforremotedatabaseadministration.
D.ItrecordsusernamesandpasswordsofalluserswhentheyareaddedtoOSDBAorOSOPERoperatingsystemgroups.
第3题:
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.
第5题:
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.