To allocate another role to a user, which command is most appropriate?（）

A table was just created on your Oracle database with six extents allocated to it. Which of the following factors most likely caused the table to have so many extents allocated?（）

单选题查看答案

Every resource plan must contain an allocation to which consumer group？（）

单选题查看答案

You want to disable resumable space allocation for all sessions.Which value should be assigned to the RESUMABLE_TIMEOUT parameter to disable resumable space allocation for all sessions？（）

单选题查看答案

You want to enable resumable space allocation at the instance level. Which two actions would enable resumable space allocation at the instance level？（） 

多选题查看答案

Which Oracle background process frees SGA resources that were allocated to a user process that failed？（）

单选题查看答案

You want to be notified when the space usage of an existing critical tablespace has reached 75% of the allocated space. Which option would you use to achieve this？（）

单选题查看答案

To enable resumable space allocation for the instance， which of the following initialization parameters should you set to a nonzero value？（）

单选题查看答案

To determine the space allocated for temporary segments, the DBA can access which of the following views? （）

单选题查看答案

You noticed that large memory allocations for the Oracle backup and restore operations are causing a performance overhead on the shared pool. Which memory structure would you configure to avoid this performance overhead？（）

单选题查看答案