Oracle
1Z0-054 · Question #7
View the Exhibit and examine a portion of the output obtained from the following query: SQL> SELECT * FROM v$sys_time_model; Select three correct interpretations of the time model statistics…
The correct answer is B. SQL execute elapsed time includes the time spent in performing fetches of query results. D. SQL execute elapsed time includes components of the hard parse elapsed time like bind elapsed E. DB time includes the connection management call elapsed time excluding the background. See the full explanation below for the reasoning.
Question
View the Exhibit and examine a portion of the output obtained from the following query:
SQL> SELECT * FROM v$sys_time_model; Select three correct interpretations of the time model statistics. (Choose three.)
Exhibit
Options
- ADB time includes the wait time of all the nonidle and idle user sessions.
- BSQL execute elapsed time includes the time spent in performing fetches of query results.
- CDB CPU includes the CPU time spent on database user-level calls and background CPU time.
- DSQL execute elapsed time includes components of the hard parse elapsed time like bind elapsed
- EDB time includes the connection management call elapsed time excluding the background
How the community answered
(39 responses)- A18% (7)
- B72% (28)
- C10% (4)
Community Discussion
No community discussion yet for this question.