单项选择题
You observed the following output for a user session:
What do you infer from the preceding output?()
A. Resumable set for session with sid 18
B. The user session has entered into a deadlock
C. The database instance is enabled to use asynchronous commit
D. The threshold warning limit is exceeded for the tablespace that is used by the user session
多项选择题 WhichstatementsaretrueregardingtheQueryResultCache?()
单项选择题 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?()
单项选择题 Your database interface is running. A user SCOTT starts a SQL *Plus session, and issues the following query: SQL> SELECT * FROM sales; Which process would retrieve the result from the database and return it to the client program?()