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

题目内容 (请给出正确答案)
Which setting enables the baselines by default in Oracle Database 11g?()

A. setting the STATISTICS_LEVEL parameter to TYPICAL

B. adding filters to the Automatic Database Diagnostic Monitor (ADDM)

C. enabling Automated Maintenance Task using Oracle Enterprise Manager

D. setting the OPTIMIZER_USE_PENDING_STATISTICS parameter to TRUE


参考答案

更多 “ Which setting enables the baselines by default in Oracle Database 11g?() A. setting the STATISTICS_LEVEL parameter to TYPICALB. adding filters to the Automatic Database Diagnostic Monitor (ADDM)C. enabling Automated Maintenance Task using Oracle Enterprise ManagerD. setting the OPTIMIZER_USE_PENDING_STATISTICS parameter to TRUE ” 相关考题
考题 You are a database administrator in the Los Angeles branch office of a specialty foods supplier. A mainframe. database at the headquarters contains all company data. Each branch office contains a SQL Server 2000 computer that imports regional data from the mainframe. database.The server in Los Angeles contains a Data Transformation Services (DTS) package that uses OLE DB to connect to the company's mainframe. database. The DTS package extracts and transforms data about buyers and products for that region. The DTS package then writes the data to the SQL Server database in Los Angeles.You need to configure a SQL Server computer for the new branch office in Sydney. You want to copy the Los Angeles package and modify it so that it writes data to the SQL Server database in Sydney.You use the DTS Designer to modify the DTS package so that it imports regional data from the mainframe. database to the server in Sydney. The modified DTS package runs successfully on the server in Los Angeles. You save this DTS package to the server in Sydney, but the server in Sydney cannot connect to the mainframe. database.You want to enable the server in Sydney to connect to the mainframe. database. What should you do?A.Change the connection properties in the DTS package so that the package uses new login credentials to connect to the mainframe. database.B.Modify the workflow in the DTS package so that the server in Sydney is included.C.On the server in Sydney, install an OLE DB provider for the mainframe. database.D.On the server in Sydney, delete and then re-create the DTS package.

考题 Youhavecreatedascriptintherecoverycatalogcalledbackup_database.Whichofthefollowingcommandswouldsuccessfullyexecutethatscript?() A.run{openscriptbackup_database;runscriptbackup_database}B.run{engagescriptbackup_database;}C.run{runscriptbackup_database;}D.Run{executescriptbackup_database;}E.Thenamebackup_databaseisaninvalidnameforanRMANscript.TryingtorunitfromRMAN wouldresultinanerror.

考题 Youhavecontrol-fileautobackupsenabled.WhenstartingyourdatabasefromSQL*Plus,youreceivethefollowingerrormessage:SQLstartupORA-01078:failureinprocessingsystemparametersLRM-00109:couldnotopenparameterfile,C:\ORACLE\PRODUCT\11.1.0\DB_1\DATABASE\INITORCL.ORAUsingRMAN,howwouldyourespondtothiserror?()A.Issuethestartupnomountcommandandthenissuetherestoreparameterfilecommandfromthe RMANprompt.B.IssuethestartupnomountcommandandthenissuetherestorespfilecommandfromtheRMANprompt.C.Issuethestartupnomountcommandandthenissuetherestorespfilefromautobackupcommand fromtheRMANprompt.D.Issuethestartupnomountcommandandthenissuetherestorespfilefrombackupcommand from theRMANprompt.E.IssuetherestorespfilefromautobackupcommandfromtheRMANprompt.

考题 Which of the following should be updated when new computers are purchased?() A. Asset managementB. Change managementC. Cable managementD. Baselines

考题 YouhavejustrunthissyntaxtostartthelistenerfromtheListenerControlutility:LSNRCTLSTARTStarting/mstgelai/oracle/bin/tnslsnr:pleasewait…Systemparameterfileis/u01/oracle/network/admin/listener.oraLogmessageswrittento/u01/oracle/network/log/listener.logListeningon:(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=stc-sun01-server)(PORT=1521)))Connectingto…ThecommandcompletedsuccessfullyWhatisthenameoftheListeneryoustarted?()A.TNSLSNRB.LISTENERC.LOCAL_LISTENERD.DEFAULT_LSRN

考题 ORACLE初始化参数文件的默认路径是:() A.对于UNIX,在$ORACLE_HOME/dbsB.对于UNIX,在$ORACLE_HOME/dbs/adminC.对于Linux,在%ORACLE_HOME%\databaseD.对于Windows,在%ORACLE_HOME%\dbsE.对于Windows,在%ORACLE_HOME%\database\admin

考题 在Oracle中,用户()拥有所有内置的程序包。 A.SYSB.SYSTEMC.PUBLICD.DEFAULT

考题 当启动一个Oracle实例时,初始化参数()指出为数据文件信息保留的SGA空间的数量。 A.DB_FILESB.DB_DATAFILESC.DATABASE_FILESD.LOG_FILES

考题 建立登录用户时若不指定DEFAULT_DATABASE选项,默认数据库为master数据库。()

考题 4、在Oracle中创建用户时,若未提及default tablespace关键字,则系统将哪个表空间分配给用户作为默认表空间?A.usersB.systemC.sysD.default