多项选择题
A.Every SQL statement in the STS is considered only once for execution
B.The SQL statements in the STS are executed concurrently to produce the execution plan and execution statistics
C.The execution plan and execution statistics are computed for each SQL statement in the STS
D.The effects of DDL and DML are considered to produce the execution plan and execution statistics
多项选择题 Which statements are true regarding the Query Result Cache? ()
单项选择题 You specify a nonzero value for the MEMORY_TARGET initialization parameter, but do not set the PGA_AGGREGATE_TARGET or the SGA_TARGET parameters. You restart your database instance. Which statement about the result is true?()
单项选择题 You are tuning RMAN to optimize performance.You want tape I/O to be asynchronous when you perform tape backups. Which action should you take?()