Cisco®
Oracle
CompTIA
Checkpoint
ISC
EC-Council
EXIN
Fortinet
ITIL®
Juniper
Microsoft
VMware
Avaya
SAP
Google
Salesforce
Amazon
Palo Alto Networks
ISC2
Splunk®
All Vendors
  2. Home
  3. Exams
  4. Oracle
  5. 1Z0-082

Free Oracle 1Z0-082 Exam Questions (page: 20)

Page 7 of 36
PDF with 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



Viewing page 20 of 36



Post your Comments and Discuss Oracle 1Z0-082 exam prep with other Community members:

1Z0-082 Exam Discussions & Posts