多项选择题
A.The MEMORY_MAX_TARGET parameter is automatically set to 500 mb.
B.The pga_AGGREGATE_TARGET and sga_TARGET parameters are automatically set to zero.
C.The value of the MEMORY_MAX_TARGET parameter remains zero until it is changed manually.
D.The lower bounds of pga_AGGREGATE_TARGET and sga_TARGET parameters are set to 90 nb and270 mb, respectively
多项选择题 You execute the following command to change the status of the SALES tablespace:SQL> ALTER TABLESPACE sales OFFLINE; Which statements describe the effect of the command()
多项选择题 Examine the following statement that is used to modify the primary key constraint on the SALES table: SQL> ALTER TABLE SALES MODIFY CONSTRAINT pk DISABLE VALIDATE; Which three statements aretrue regarding the above command()
多项选择题 Your database instance is running with full workload after database creation. You have decided to use a fixed-size undo tablespace. You want to use the Undo Advisor to estimate the capacity of the undo tablespace. Which two factors must you consider before using the Undo Advisor to estimate the capacity of the undotablespace()