1z0-082 Practice Test

1z0-082 Practice Test practice questions, page 5 of 7, with answer review and explanations.

Question 21

Which four account management capabilities can be configured using Oracle profiles? (Choose four.)

  1. the number of hours for which an account is locked after the configured number of login attempts has been reached
  2. the number of days for which an account may be inactive before it is locked
  3. the maximum amount of CPU time allowed for a user's sessions before their account is locked
  4. the ability to prevent a password from ever being reused
  5. the number of password changes required within a period of time before a password can be reused
  6. the number of days for which an account is locked after the configured number of login attempts has been reached
  7. the maximum number of sessions permitted for a user before the account is locked

Question 22

Which three statements are true about single-row functions? (Choose three.)

  1. They can be used only in the WHERE clause of a SELECT statement
  2. The argument can be a column name, variable, literal or an expression
  3. The data type returned can be different from the data type of the argument
  4. They can be nested to any level
  5. They can accept only one argument
  6. They return a single result row per table

Question 23

You want to use table compression suitable for OLTP that will: 1. Compress rows for all DML statements on that table 2. Minimize the overheads associated with compression Which compression option is best suited for this?

  1. COLUMN STORE COMPRESS FOR QUERY LOW
  2. ROW STORE COMPRESS BASIC
  3. COLUMN STORE COMPRESS FOR ARCHIVE LOW
  4. COLUMN STORE COMPRESS FOR ARCHIVE HIGH
  5. ROW STORE COMPRESS ADVANCED

Question 24

Which two statements are true about space-saving features in an Oracle Database? (Choose two.)

  1. Private Temporary Tables (PTTS) store metadata in memory only
  2. An index created with the UNUSABLE attribute has no segment
  3. If they exist for a session, Private Temporary Tables (PTTs) are always dropped at the next COMMIT OR ROLLBACK statement
  4. An index that is altered to be UNUSABLE will retain its segment
  5. A table that is truncated will always have its segment removed

Question 25

Which two statements are true about the PMON background process? (Choose two.)

  1. It registers database services with all local and remote listeners known to the database instance
  2. It frees resources held by abnormally terminated processes
  3. It records checkpoint information in the control file
  4. It frees unused temporary segments
  5. It kills sessions that exceed idle time