Amazon
Avaya
Checkpoint
Cisco®
CompTIA
CrowdStrike
EC-Council
EXIN
Fortinet
Google
ISC
ISC2
ITIL®
Juniper
Microsoft
MuleSoft
Okta
Oracle
Palo Alto Networks
Salesforce
All Vendors
  1. Home
  2. Oracle
  3. 1Z0-082

Oracle 1Z0-082 Exam (page: 5)
Oracle Database Administration I
Updated on: 31-Aug-2025

Viewing Page 5 of 30
1Z0-082 PDF 178 Questions

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

Answer(s): D,E,F,G



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

Answer(s): B,C,F


Reference:

https://www.folkstalk.com/2012/01/oracle-single-row-functions-examples.html



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

Answer(s): E


Reference:

https://www.oracle.com/technetwork/database/options/compression/advanced-compression-wp-12c-1896128.pdf



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

Answer(s): B,C



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

Answer(s): A,B


Reference:

https://docs.oracle.com/cd/B19306_01/server.102/b14220/process.htm



Viewing Page 5 of 30



Share your comments for Oracle 1Z0-082 exam with other users:

Biswa 11/20/2023 8:50:00 AM

refresh db knowledge
Anonymous


Biswa 11/20/2023 9:07:00 AM

understanding about joins
Anonymous


Biswa 11/20/2023 9:28:00 AM

understand sql col.
Anonymous