多选题

You are working in a dedicated server environment. Your database is running in the automatic Program Global Area (PGA) memory management mode.   Which two statements are correct in this scenario?()

AThe WORK_AREASIZE_POLICY initialization parameter cannot be set to AUTO.

BThe Oracle database automatically controls the amount of PGA memory allotted to SQL work areas.

CSetting the value of the SGA_TARGET initialization parameter to 0 will disable the automatic PGA  memory management.

DThe SORT_AREA_SIZE parameter is ignored by all the sessions running in the automatic PGA  memory management mode.

正确答案

来源:www.examk.com

答案解析

相似试题
  • You are managing an Oracle Database 11g database. You configured the database to run inARCHIVELOG mode.  Which two statements are true in this scenario()

    多选题查看答案

  • You are managing an Oracle Database 11g database. You configured the database to run in ARCHIVELOGmode.  Which two statements are true in this scenario()

    多选题查看答案

  • You are managing an Oracle Database 11g database. The database is open, and you plan to  performRecovery Manager (RMAN) backups.  Which three statements are true about these backups()

    多选题查看答案

  • You are managing an Oracle Database 11g database. The database is open, and you plan to perform Recovery Manager (RMAN) backups.  Which three statements are true about these backups()

    多选题查看答案

  • You are the Database Administrator (DBA) of your company. You execute the following statement on an Oracle 10g instance:   SQL> ALTER SYSTEM SWITCH LOGFILE;   Which two tasks are performed when the statement is executed? ()

    多选题查看答案

  • You are implementing a very simple TCP/IP network. It rarely changes and you would like to use Oracle Connection Manager to filter client requests.  Which naming method can you use?()

    单选题查看答案

  • You are managing an Oracle Database 11g database. You want to ensure the recovery of thedatabase to the point of failure.  Which configuration will you do to accomplish the task()

    单选题查看答案

  • You are working on the Certkiller database.  What is the default name of the alert log file in this database?()

    单选题查看答案

  • You are working on an Oracle Database 10g database. Because of data loss, you decided to perform a Flashback Database operation using the following command:  SQL> FLASHBACK DATABASE TO TIMESTAMP(SYSDATE ?5/24); Which two statements are true? ()

    多选题查看答案

  • You are performing backup and recovery operations by using RMAN. You are using a recovery catalog for the RMAN repository. You are planning to migrate to ASM disk storage to enable new disks to be added to the database without shutting down the database.   Which information is NOT required during the migration process?()

    单选题查看答案