When manually configuring the SGA，which of the following parameter changes requires an instance restart to take effect？（）   "First Test， First Pass" - www.lead2pass.com 97 Oracle 1Z0-053 Exam

A、 DB_CACHE_SIZE

B、 SHARED_POOL_SIZE

C、 LARGE_POOL_SIZE

D、 JAVA_POOL_SIZE

E、 SGA_MAX_SIZE

F、 SORT_AREA_SIZE

相关问题推荐

• Which of the following advisors within the Oracle advisory framework will analyze a single SQL statement and make recommendations for performance improvement?（）

  A、SQL Repair Advisor

  B、SQL Optimizer

  C、SQL Access Advisor

  D、SQL Tuning Advisor

  查看答案

• 关于IEEE802.3的CSMA/CD协议，下面结论中错误的是(62)。

  A．CSMA/CD是一种解决访问冲突的协议

  B．CSMA/CD协议适用于所有802.3以太网

  C．在网络负载较小时，CSMA/CD协议的通信效率很高

  D．这种网络协议适合传输非实时数据

  查看答案

• What recommendations does the SQL Access Advisor provide for optimizing SQL queries? （）(Choose all that apply.)

  A

  selection of SQL plan baselines

  B

  partitioning of tables and indexes

  C

  creation of index-organized tables

  D

  creation of bitmap, function-based, and B-tree indexes

  E

  optimization of materialized views for maximum query usage and fast refresh

  查看答案

• When you create a backup control file， where is the resulting file written to？（）  

  A、 The database user dump destination directory

  B、 The database diagnostic destination directory

  C、 To $ORACLE_HOME/rdbms

  D、 To $ORACLE_HOME/admin

  E、 To the directory and filename you specify in the command

  查看答案

• You executed the following command：   RMAN> RECOVER COPY OF DATAFILE ’/u01/app/oracle/oradata/orcl/users01.dbf’；   Which statement regarding the above command is correct？（）  

  A、 The ’/u01/app/oracle/oradata/orcl/users01.dbf’ data file is recovered from the image copy.

  B、 The ’/u01/app/oracle/oradata/orcl/users01.dbf’ data file is recovered from the last incremental backup.

  C、 Image copies of the ’/u01/app/oracle/oradata/orcl/users01.dbf’ data file are updated with all changes up to incremental backup SCN.

  D、 Image copies of the ’/u01/app/oracle/oradata/orcl/users01.dbf’ data file are recovered using the above command if data file recovery fails.

  查看答案