首页计算机考试Oracle认证
(多选题)

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? ()

A The WORK_AREASIZE_POLICY initialization parameter cannot be set to AUTO.

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

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

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

正确答案

来源:www.examk.com

答案解析

相似试题

  • (单选题)

    You are configuring for Oracle Shared Server. Which service is required? ()

    答案解析

  • (多选题)

    You are working on an Oracle Database 10g database. You enabled the Flashback Database feature. Which two statements regarding flashback logs are true? ()

    答案解析

  • (单选题)

    How are messages displayed when you use the SRW.MESSAGE packaged procedure? ()

    答案解析

  • (单选题)

    In which situation are you NOT required to perform an incomplete recovery?()

    答案解析

  • (单选题)

    You are using RMAN to backup your ARCHIVELOG mode database. You have enabled control-file autobackups. Which files are not backed up during the RMAN backup?()

    答案解析

  • (单选题)

    You are using RMAN to backup your ARCHIVELOG mode database. You have enabled control-file autobackups. Which files are not backed up during the RMAN backup?()  

    答案解析

  • (单选题)

    You are performing a database recovery because a user’s schema is dropped. While performing the recovery, you use the UNTIL SEQUENCE clause. Which type of database recovery are you performing?()

    答案解析

  • (多选题)

    You want to make use of the object features available in the database for the form module you are developing. Which three statements about object types are true? ()

    答案解析

  • (单选题)

    Which command would you use to determine what database backups are currently available for restore?()

    答案解析

  • (单选题)

    Which command would you use to determine what database backups are currently available for restore?()  

    答案解析

快考试在线搜题