多項選擇題

You set the following parameters in the parameter file and restarted the database：MEMORY_MAX_TARGET=0MEMORY_TARGET=500M
PGA_AGGREGATE_TARGET=90MSGA_TARGET=270M
Which two statements are true about these parameters after the database instance is restarted（）

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（）

A.The tablespace would require recovery to go back online.
B.A checkpoint is taken on all data files that are associated with the SALES tablespace.
C.The sessions that subsequently try to access the objects in the SALES tablespace receive an error
D.The new status of the SALES tablespace is recorded in the control file when the database instance isclosed

多項選擇題

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（）

A.The constraint remains valid.
B.The index on the constraint is dropped.
C.It allows the loading of data into the table using SQL *Loader.
D.New data conforms to the constraint， but existing data is not checked.
E.It allows the data manipulation on the table using INSERT/UPDATE/DELETE SQL statements.

97免费在线观看视频,亚洲综合自拍网,黄色毛片免费观看,热久久综合网,免费看日产一区二区三区 狠狠操av,久久久涩涩涩,在线精品免费视频,人人插天天干,久久91精品国产91久久

You set the following parameters in the parameter file and restarted the database：MEMORY_MAX_TARGET=0MEMORY_TARGET=500M PGA_AGGREGATE_TARGET=90MSGA_TARGET=270M Which two statements are true about these parameters after the database instance is restarted（）

你可能感興趣的試題

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（）

97免费在线观看视频,亚洲综合自拍网,黄色毛片免费观看,热久久综合网,免费看日产一区二区三区狠狠操av,久久久涩涩涩,在线精品免费视频,人人插天天干,久久91精品国产91久久

You set the following parameters in the parameter file and restarted the database：MEMORY_MAX_TARGET=0MEMORY_TARGET=500M
PGA_AGGREGATE_TARGET=90MSGA_TARGET=270M
Which two statements are true about these parameters after the database instance is restarted（）

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（）