单选题In your database server， the parameter PLSQL_OPTIMIZE_LEVEL has been set to 2. What would this setting achieve？（）A It degrades the run time and compiler performance.B It provides better run time and compiler performance.C It provides better optimizatio

题目
单选题
In your database server， the parameter PLSQL_OPTIMIZE_LEVEL has been set to 2. What would this setting achieve？（）
A

It degrades the run time and compiler performance.

B

It provides better run time and compiler performance.

C

It provides better optimization of the statement during parse time.

D

It forces the rule based optimizer to be used for statement optimization.

E

It provides better run time performance but slightly degraded compiler performance.

F

It provides better run time performance but slightly degraded run time performance.

相似考题

1. In your production database there is a job， CALC_STAT， which has been scheduled to run every Friday at 5：00 p.m. CALC_STAT updates the optimizer statistics for the objects owned by the APPS schema. You want the task to be generic， thereby allowing users to modify the attributes of the task at run time without affecting the original task. Which component of Oracle Scheduler must you define to achieve this？（）A、WindowB、ProgramC、Job classD、Window group

2.You are working on the 24X7 database with high transaction volume， to ensure faster instance recovery on your database you set the FAST_START_MTTR_TARGET initialization parameter to a very low value. What effect it will have on the database？（）A、The database performance would be enhanced.B、The redo log files would be get filled more frequently.C、The overall database performance would be degraded.D、The mean time to recover （MTTR） would be increased.

3.Select three true statements regarding Coherence（）A、 Coherence provides stronger data management than an Application ServerB、 Coherence provides better scale-out performance than a Application ServerC、 Coherence provides better scale-out performance than a Database ServerD、 Coherence provides better througput than a JMS messaging server Coherence provides stronger configuration management than Grid Control

4.The production database has been functional for the last seven days. Because of application requirements， some of the initialization parameters were changed during run time without any comments. You have asked to find out the value of the parameters when the instance was started.Which source would you use to locate this information？（）A、 Fixed viewsB、 The alert log fileC、 The parameter fileD、 The server parameter fileE、 Dynamic performance views

更多“单选题In your database server， the parameter PLSQL_OPTIMIZE_LEVEL has been set to 2. What would this setting achieve？（）A It degrades the run time and compiler performance.B It provides better run time and compiler performance.C It provides better optimizatio”相关问题

  • 第1题：

    You work as a database administrator for Certkiller .com. In your database server， the parameter PLSQL_OPTIMIZE_LEVEL has been set to 2. What would this setting achieve？（）

    • A、It degrades the run time and compiler performance.
    • B、It provides better run time and compiler performance.
    • C、It provides better optimization of the statement during parse time.
    • D、It forces the rule based optimizer to be used for statement optimization.
    • E、It provides better run time performance but slightly degraded compiler performance. 
    • F、It provides better run time performance but slightly degraded run time performance.

    正确答案:E

  • 第2题：

    You have been recently hired as a database administrator. Your senior manager asks you to study the production database server and submit a report on the settings done by the previous DBA.  While observing the server settings， you find that the following parameter has been set in the parameter file of the database：  REMOTE_OS_AUTHENT = TRUE  What could have been the reason to set this parameter as TRUE？（）

    • A、to enable operating system authentication for a remote client
    • B、to restrict the scope of administration to identical operating systems
    • C、to allow the start up and shut down of the database from a remote client
    • D、to enable the administration of the operating system from a remote client
    • E、to disable the administration of the operating system from a remote client

    正确答案:A

  • 第3题：

    In the parameter file of your production database， the CONTROL_FILE_RECORD_KEEP_TIME parameter is set to 31. What would be the impact of this setting on the backup that is being performed by using Recovery Manager （RMAN）？（）

    • A、 The backup would be retained on the media for 31 days.
    • B、 The backup would be maintained in the recovery catalog for 31 days.
    • C、 The backup metadata would be retained in the control file for 31 days.
    • D、 The backup metadata would be maintained in the recovery catalog for 31 days.
    • E、 Automatic backups of the control file will be retained in the flash recovery area for 31 days.

    正确答案:C

  • 第4题：

    You received complaints about the degradation of SQL query performance. You identified top SQL queries that consume time. What would be your next step to find out recommendations about statistics collection and restructuring of the SQL statement to improve query performance？（）

    • A、run Segment Advisor
    • B、run SQL Tuning Advisor on top SQL statements
    • C、run the Automatic Workload Repository （AWR） report
    • D、run the Automatic Database Diagnostic Monitor （ADDM）on top SQL statements

    正确答案:B

  • 第5题：

    Your database is started by using the server parameter file （SPFILE）. You issued this command to change the value of the LOG_BUFFER initialization parameter：  ALTER SYSTEM SET LOG_BUFFER=24M SCOPE=BOTH；  What would be the outcome of this command？ （）

    • A、The command would return an error because LOG_BUFFER is a static parameter.
    • B、The parameter value would be changed and it would come into effect immediately.
    • C、You need to restart the database so that parameter changes can come into effect.
    • D、The command would succeed only if initialization parameter LOG_ARCHIVE_MAX_PROCESS is set to value 2.

    正确答案:A

  • 第6题：

    单选题
    In your production database there is a job， CALC_STAT， which has been scheduled to run every Friday at 5：00 p.m. CALC_STAT updates the optimizer statistics for the objects owned by the APPS schema. You want the task to be generic， thereby allowing users to modify the attributes of the task at run time without affecting the original task. Which component of Oracle Scheduler must you define to achieve this？（）
    A

    Window

    B

    Program

    C

    Job class

    D

    Window group


    正确答案： D
    解析： 暂无解析

  • 第7题：

    单选题
    You have been recently hired as a database administrator. Your senior manager asks you to study the production database server and submit a report on the settings done by the previous DBA.  While observing the server settings， you find that the following parameter has been set in the parameter file of the database：  REMOTE_OS_AUTHENT = TRUE  What could have been the reason to set this parameter as TRUE？（）
    A

    to enable operating system authentication for a remote client

    B

    to restrict the scope of administration to identical operating systems

    C

    to allow the start up and shut down of the database from a remote client

    D

    to enable the administration of the operating system from a remote client

    E

    to disable the administration of the operating system from a remote client


    正确答案： A
    解析： 暂无解析

  • 第8题：

    单选题
    In the parameter file of your production database， the CONTROL_FILE_RECORD_KEEP_TIME parameter is set to 31. What would be the impact of this setting on the backup that is being performed by using Recovery Manager （RMAN）？（）
    A

     The backup would be retained on the media for 31 days.

    B

     The backup would be maintained in the recovery catalog for 31 days.

    C

     The backup metadata would be retained in the control file for 31 days.

    D

     The backup metadata would be maintained in the recovery catalog for 31 days.

    E

     Automatic backups of the control file will be retained in the flash recovery area for 31 days.


    正确答案： B
    解析： 暂无解析

  • 第9题：

    单选题
    In your database server， the parameter PLSQL_OPTIMIZE_LEVEL has been set to 2. What would this setting achieve？（）
    A

    It degrades the run time and compiler performance.

    B

    It provides better run time and compiler performance.

    C

    It provides better optimization of the statement during parse time.

    D

    It forces the rule based optimizer to be used for statement optimization.

    E

    It provides better run time performance but slightly degraded compiler performance.

    F

    It provides better run time performance but slightly degraded run time performance.


    正确答案： E
    解析： 暂无解析

  • 第10题：

    单选题
    You work as a database administrator at Certkiller .com. In your production database there is a job， CALC_STAT， which has been scheduled to run every Friday at 5.00 p.m. CALC_STATupdates the optimizer statistics for the objects owned by the APPSschema. You want the task to be generic， thereby allowing users to modify the attributes of the task at run time without affecting the original task.Which component of Oracle Scheduler must you define to achieve this？（）
    A

     Window

    B

     Program

    C

     Job class

    D

     Window group


    正确答案： D
    解析： 暂无解析

  • 第11题：

    单选题
    From the V$SESSION_LONGOPS view， you find that some of the database users have long-running queries that consume a lot of CPU time. This causes performance problems for other users in the database， who have much shorter queries. You would like to make sure that the users with large queries do not use all the CPU time， but you still do not want to terminate them with an error message. Which method would you follow to achieve this？（）
    A

     set the CPU time per call in the users profile

    B

     set the CPU time per session in the users profiles

    C

     set the TIMED_STATISTICS parameter to TRUE in the parameter file

    D

     set the CPU levels for the users’ group using Resource Manager


    正确答案： D
    解析： 暂无解析

  • 第12题：

    单选题
    You are working on the 24X7 database with high transaction volume， to ensure faster instance recovery on your database you set the FAST_START_MTTR_TARGET initialization parameter to a very low value. What effect it will have on the database？（）
    A

    The database performance would be enhanced.

    B

    The redo log files would be get filled more frequently.

    C

    The overall database performance would be degraded.

    D

    The mean time to recover （MTTR） would be increased.


    正确答案： A
    解析： 暂无解析

  • 第13题：

    You work as a database administrator for Certkiller .com. Users complain that their query is taking a long time to complete. You suspect the database buffer cache size to be the reason， and you define an alert to be generated when the buffer cache hit metric goes below 85%. When you observe the dynamic performance views， you find that the buffer cache hit ratio is 81% but no alerts are being generated.  What could be the reason for this problem？（）

    • A、The advisory memory has been turned off.
    • B、The DB_CACHE_ADVICE parameter has been set to OFF in the parameter file.
    • C、The STATISTICS_LEVEL parameter has been set to BASIC in the parameter file.
    • D、The TIMED_STATISTICS parameter has been set to FALSE in the parameter file.
    • E、The STATISTICS_LEVEL parameter has been set to TYPICAL in the parameter file.

    正确答案:C

  • 第14题：

    The production database has been functional for the last seven days. Because of application requirements， some of the initialization parameters were changed during run time without any comments. You have been asked to find out the value of the parameters when the instance was started. Which source would you use to locate this information？（）

    • A、fixed views
    • B、the alert log file
    • C、the parameter file
    • D、the server parameter file
    • E、dynamic performance views

    正确答案:B

  • 第15题：

    In your database server， the parameter PLSQL_OPTIMIZE_LEVEL has been set to 2. What would this setting achieve？（）

    • A、It degrades the run time and compiler performance.
    • B、It provides better run time and compiler performance.
    • C、It provides better optimization of the statement during parse time.
    • D、It forces the rule based optimizer to be used for statement optimization.
    • E、It provides better run time performance but slightly degraded compiler performance.
    • F、It provides better run time performance but slightly degraded run time performance.

    正确答案:E

  • 第16题：

    From the V$SESSION_LONGOPS view， you find that some of the database users have long-running queries that consume a lot of CPU time. This causes performance problems for other users in the database， who have much shorter queries.  You would like to make sure that the users with large queries do not use all the CPU time， but you still do not want to terminate them with an error message.  Which method would you follow to achieve this？（）

    • A、set the CPU time per call in the users profile
    • B、set the CPU time per session in the users profiles
    • C、set the CPU levels for the users’ group using Resource Manager
    • D、set the TIMED_STATISTICS parameter to TRUE in the parameter file

    正确答案:C

  • 第17题：

    You work as a database administrator at Certkiller .com. In your production database there is a job， CALC_STAT， which has been scheduled to run every Friday at 5.00 p.m. CALC_STATupdates the optimizer statistics for the objects owned by the APPSschema. You want the task to be generic， thereby allowing users to modify the attributes of the task at run time without affecting the original task.Which component of Oracle Scheduler must you define to achieve this？（）

    • A、 Window
    • B、 Program
    • C、 Job class
    • D、 Window group

    正确答案:B

  • 第18题：

    单选题
    You want to perform in incomplete recovery of your database.  You plan to use these commands to recover your database：  SET UNTIL TIME = ’2000-12-09：11：44：00’；  RESTORE DATABASE； RECOVER DATABASE；  How should the commands be executed？ （）
    A

    Only the SET command must be within a RUN block.

    B

    All commands should be executed at the RMAN prompt.

    C

    All three commands must be within a single RUN block.

    D

    Only the RESTORE and RECOVER commands must be within a single RUN block.


    正确答案： B
    解析： 暂无解析

  • 第19题：

    单选题
    The production database has been functional for the last seven days. Because of application requirements， some of the initialization parameters were changed during run time without any comments. You have asked to find out the value of the parameters when the instance was started.Which source would you use to locate this information？（）
    A

     Fixed views

    B

     The alert log file

    C

     The parameter file

    D

     The server parameter file

    E

     Dynamic performance views


    正确答案： B
    解析： 暂无解析

  • 第20题：

    单选题
    Your database is started by using the server parameter file （SPFILE）. You issued this command to change the value of the LOG_BUFFER initialization parameter：  ALTER SYSTEM SET LOG_BUFFER=24M SCOPE=BOTH;  What would be the outcome of this command？（）
    A

    The command would return an error because LOG_BUFFER is a static parameter.

    B

    The parameter value would be changed and it would come into effect immediately.

    C

    You need to restart the database so that parameter changes can come into effect.

    D

    The command would succeed only if initialization parameter LOG_ARCHIVE_MAX_PROCESS is set to value 2.


    正确答案： A
    解析： 暂无解析

  • 第21题：

    单选题
    You work as a database administrator for Supportcenter.cn. Users complain that their query is taking a long time to complete. You suspect the database buffer cache size to be the reason， and you define an alert to be generated when the buffer cache hit metric goes below 85%. When you observe the dynamic performance views， you find that the buffer cache hit ratio is 81% but no alerts are being generated.  What could be the reason for this problem？（）
    A

    The advisory memory has been turned off.

    B

    The DB_CACHE_ADVICE parameter has been set to OFF in the parameter file.

    C

    The STATISTICS_LEVEL parameter has been set to BASIC in the parameter file.

    D

    The TIMED_STATISTICS parameter has been set to FALSE in the parameter file.

    E

    The STATISTICS_LEVEL parameter has been set to TYPICAL in the parameter file.


    正确答案： E
    解析： 暂无解析

  • 第22题：

    单选题
    For the V$SESSION_LONGOPS view， you find that some of the database users have long-running queries that consume a lot of CPU time. This causes performance problems for other users in the database， who have much shorter queries. You would like to make sure that the users with large queries do not use all the CPU time， but you still do not want to terminate them with an error message. Which method would you follow to achieve this？（）
    A

     Set the CPU time per call in the users profile.

    B

     Set the CPU time per session in the users profile.

    C

     Set the CPU levels for the user’s group using Resource Manager.

    D

     Set the TIMED_STATISTICS parameter to TRUE in the parameter file.


    正确答案： C
    解析： 暂无解析

  • 第23题：

    单选题
    You work as a database administrator for Certkiller .com. In your database server， the parameter PLSQL_OPTIMIZE_LEVEL has been set to 2. What would this setting achieve？（）
    A

    It degrades the run time and compiler performance.

    B

    It provides better run time and compiler performance.

    C

    It provides better optimization of the statement during parse time.

    D

    It forces the rule based optimizer to be used for statement optimization.

    E

    It provides better run time performance but slightly degraded compiler performance. 

    F

    It provides better run time performance but slightly degraded run time performance.


    正确答案： A
    解析： 暂无解析

  • 第24题：

    单选题
    The production database has been functional for the last seven days. Because of application requirements， some of the initialization parameters were changed during run time without any comments. You have been asked to find out the value of the parameters when the instance was started. Which source would you use to locate this information？（）
    A

    fixed views

    B

    the alert log file

    C

    the parameter file

    D

    the server parameter file

    E

    dynamic performance views


    正确答案： B
    解析： 暂无解析

相关内容