1z0-084

1z0-084 practice questions, page 5 of 5, with answer review and explanations.

Question 21

You are informed that the RMAN session that is performing the database duplication is much slower than usual. You want to know the approximate time when the rman operation will be completed. Which view has this information?

  1. V$SESSION
  2. V$SESSTAT
  3. V$RMAN_BACKUP_JOB_DETAILS
  4. V$SESSION_LONGOPS

Question 22

Which two statements are true about space usage in temporary tablespaces? (Choose two.)

  1. When a global temporary table instantiation is too large to fit in memory, space is allocated in a temporary tablespace.
  2. Temporary tablespaces setting includes quotas to limit temporary space used by a session for that Temporary tablespace.
  3. A sort will fail if a sort to disk requires more disk space and no additional extent can be found/allocated in/for the sort segment.
  4. When a session consumes all temporary tablespace storage, then the session would hang until the temporary space used by that session is cleared
  5. Lack of temporary tablespace space for sort operations can be prevented by using temporary tablespace groups.