Your system has been upgraded from Oracle Database 10g to Oracle Database 11g. You imported SQL Tuning Sets (STS) from the previous version. After changing the OPTIMIZER_FEATURE_ENABLE parameter to 10.2.0.4 and running the SQL Performance Analyzer, you ob

题目

Your system has been upgraded from Oracle Database 10g to Oracle Database 11g. You imported SQL Tuning Sets (STS) from the previous version. After changing the OPTIMIZER_FEATURE_ENABLE parameter to 10.2.0.4 and running the SQL Performance Analyzer, you observed performance regression for a few SQL statements.What would you do with these SQL statements?（）

A. Set OPTIMIZER_USE_PLAN_BASELINES to FALSE to prevent the use of regressed plans.

B. Capture the plans from the previous version using STS and then load them into the stored outline.

C. Capture the plans from the previous version using STS and then load them into SQL Management Base (SMB).

D. Set OPTIMIZER_CAPTURE_SQL_PLAN_BASELINES to FALSE to prevent the plans from being loaded to the SQL plan baseline.

相似考题

1.How long() you() a member of the club?A.have,,joinedB.have,,beenC.has,,joinedD.has,,been

2.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.

3.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.

4.以数据库超级管理员的身份连接到一个用户名system、密码oracle、名称为lteomc的数据库的命令为________。A.sqlplus system/oracle@lteomc as sysdbaB.sqlplus sys/oracle@lteomc as dbaC.sqlplus system：oracle@lteomc as sysdbaD.sqlplus sys：oracle@lteomc as dba

更多“Your system has been upgraded from Oracle Database 10g to Oracle Database 11g. You importe ”相关问题

  • 第1题：

    Youhavecontrol-fileautobackupsenabled.WhenstartingyourdatabasefromSQL*Plus，youreceivethefollowingerrormessage：SQL>startupORA-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.


    参考答案：C

  • 第2题：

    You wish to enable an audit policy for all database users, except SYS, SYSTEM, and SCOTT.You issue the following statements:SQL> AUDIT POLICY ORA_DATABASE_PARAMETER EXCEPT SYS;SQL> AUDIT POLICY ORA_DATABASE_PARAMETER EXCEPT SYSTEM;SQL> AUDIT POLICY ORA_DATABASE_PARAMETER EXCEPT SCOTT;For which database users is the audit policy now active?（）

    A. All users except SYS

    B. All users except SCOTT

    C. All users except sys and SCOTT

    D. All users except sys, system, and SCOTT


    参考答案：B

  • 第3题：

    下面不属于Oracle 10g产品系列的是()。

    A.Oracle数据库10g标准版

    B.Oracle数据库10g企业版

    C.Oracle数据库10g网络版


    参考答案：C

  • 第4题：

    You enabled an audit policy by issuing the following statements:SQL> AUDIT POLICY ORA_DATABASE_PARAMETER BY SCOTT;SQL> AUDIT POLICY ORA_DATABASE_PARAMETER BY SYS, SYSTEM;For which database users and for which executions is the audit policy now active? （）

    A. SYS, SYSTEM

    B. SCOTT

    C. Only for successful executions

    D. Only for failed executions

    E. Both successful and failed executions


    参考答案：A, E

  • 第5题：

    ORACLE初始化参数文件的默认路径是:()

    A.对于UNIX，在$ORACLE_HOME/dbs

    B.对于UNIX，在$ORACLE_HOME/dbs/admin

    C.对于Linux，在%ORACLE_HOME%\database

    D.对于Windows，在%ORACLE_HOME%\dbs

    E.对于Windows，在%ORACLE_HOME%\database\admin


    参考答案：A

  • 第6题：

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

    A.DB_FILES

    B.DB_DATAFILES

    C.DATABASE_FILES

    D.LOG_FILES


    参考答案：A

相关内容