多项选择题
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.
相关考题
-
单项选择题
Inoneofyouronlinetransactionprocessing（OLTP）applications，usersaremanipulatingandqueryingadatabasetablesimultaneously.FromtheSegmentAdvisor，youfindthatoneofthetablesishighlyfragmentedandyouwanttoshrinkthetableimmediatelywithoutaffectingthecurrentlyactivequeries.WhichoptionwouldyouusewiththeALTERTABLEcommandtoachievethisobjective？（）
A. REBUILD
B. CASCADE
C. TRUNCATE
D. ROW MOVEMENT
E. SHRINK SPACE COMPACT
F. SHRINK SPACE CASCADE -
多项选择题
You used the following command in Recovery Manager （RMAN） as part of the recovery process： RESTORE CONTROLFILE FROM AUTOBACKUP； How does RMAN find the control file autobackup？（）
A. By using the trace file.
B. By using the alert log file.
C. By using the database ID
D. By using the server parameter file.
E. By using the V$CONTROLFILE view.
F. By using the autobackup format configuration setting. -
单项选择题
By mistake， you ran the batch job （for updating the BILL_DETAILS table） twice. You are not sure which rows in the BILL_DETAILS table were affected. You need to identify： a） A list of changes made along with the transaction identifier of each change. b） The necessary SQL statements to undo the erroneous changes. Which option would you choose？（）
A. RMAN only.
B. Flashback Table only.
C. Flashback Version Query only.
D. Flashback Database and Flashback Transaction Query.
E. Flashback Version Query and Flashback Transaction Query.
