考题
Oracle数据库的JDBC驱动程序类名及完整包路径为()
A.jdbc.driver.oracle.OracleDriverB.jdbc.oracle.driver.OracleDriverC.driver.oracle.jdbc.OracleDriverD.oracle.jdbc.driver.OracleDriver
考题
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
考题
Youwanttocheckthedetailsoffewerrorsthatusershavereported.Yousearchforthealertlogfileandexecutefewcommandstofindthelocationofthealertlogfile.ViewtheExhibitandcheckthecommandsexecuted.Whatisthelocationofthealert_orcl.logfile()A.ORACLE_HOME/dbsB.ORACLE_HOME/rdbmsC./u01/app/oracle/admin/orcl/adumpD./u01/app/oracle/flash_recovery_areaE.ORACLE_BASE/diag/rdbms/orcl/orcl/alertF.ORACLE_BASE/diag/rdbms/orcl/orcl/trace
考题
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?()
考题
Oracle服务器由包括Oracle【 】和Oracle实例两部分。
考题
Oracle9i是指Oracle9i数据库、Oracle9i【 】和Oracle9i Developer Suite的完整集成。
考题
Oracle服务器由Oracle 【】 和Oracle实例组成
考题
一下对于Oracle文件系统描述错误的是()?A、*nix下Oracle的可执行文件在$Oracle_HOME/bin/Oracle,$Oracle_HOME/bin也应该包含在路径环境变量内B、Windows下Oracle的可执行文件在%Oracle_HOME%\bin\OraclE.exe,其他C、硬件加密D、固件加密
考题
ORACLE数据库自带的opath工具在下面哪个目录下?()
A.$ORACLE_HOME/network/adminB.$ORACLE_HOME/binC.$ORACLE_HOME/OPAtchD.$ORACLE_BASE