Nest 0 Cart
Nest Account
Popular Exams
All Categories...
Nest
Nest 0
Contact
Log In / Sign Up
Copyright 2024 © store. All rights reserved.
Home Oracle 1z0-082

Oracle 1z0-082 Exam Practice Questions (P. 5)

  • Full Access (178 questions)
  • Six months of Premium Access
  • Access to one million comments
  • Seamless ChatGPT Integration
  • Ability to download PDF files
  • Anki Flashcard files for revision
  • No Captcha & No AdSense
  • Advanced Exam Configuration
Get Contributor Access
Question #21
Which four account management capabilities can be configured using Oracle profiles? (Choose four.)
  1. A
    the number of hours for which an account is locked after the configured number of login attempts has been reached
  2. B
    the number of days for which an account may be inactive before it is locked
  3. C
    the maximum amount of CPU time allowed for a user's sessions before their account is locked
  4. D
    the ability to prevent a password from ever being reused
  5. E
    the number of password changes required within a period of time before a password can be reused
  6. F
    the number of days for which an account is locked after the configured number of login attempts has been reached
  7. G
    the maximum number of sessions permitted for a user before the account is locked

Correct Answer:
ADEF
chatbot-img GPT-4o - Answer
In Oracle profiles, you've got various options to manage and secure user accounts effectively. Oracle profiles let you configure PASSWORD_LOCK_TIME to decide how many days an account remains locked after too many unsuccessful login tries (Point F). For password management, the settings PASSWORD_REUSE_MAX and PASSWORD_REUSE_TIME aid in preventing passwords from being reused too soon or too often (Point D and E). These configurations are crucial for maintaining strict security protocols and ensuring that users adhere to best password practices. Remember, these profile settings are designed to boost security while managing user efficiency and access rigorously.

Question #22
Which three statements are true about single-row functions? (Choose three.)
  1. A
    They can be used only in the WHERE clause of a SELECT statement
  2. B
    The argument can be a column name, variable, literal or an expression
  3. C
    The data type returned can be different from the data type of the argument
  4. D
    They can be nested to any level
  5. E
    They can accept only one argument
  6. F
    They return a single result row per table

Correct Answer:
BCD
chatbot-img GPT-4o - Answer
The correct choices, B, C, and D, illustrate the versatility and functionality of single-row functions in Oracle SQL. Option B is accurate because single-row functions can indeed accept various inputs such as column names, literals, or expressions, making them highly adaptable in queries. For instance, you can use expressions like `LOWER(TO_DATE('12-JAN-08','DD-MONTH-RR'))`. Option C is also true since functions like `LENGTH` or `MONTHS_BETWEEN` may return a data type different from their argument's type, enhancing data processing capabilities. Lastly, option D highlights the functionality of deep nesting with no documented limits on levels, allowing complex calculations and data manipulation within a single query. This flexibility in input types, return types, and nesting capabilities underline the power of single-row functions in data querying and manipulation.

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. A
    COLUMN STORE COMPRESS FOR QUERY LOW
  2. B
    ROW STORE COMPRESS BASIC
  3. C
    COLUMN STORE COMPRESS FOR ARCHIVE LOW
  4. D
    COLUMN STORE COMPRESS FOR ARCHIVE HIGH
  5. E
    ROW STORE COMPRESS ADVANCED

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

Question #24
Which two statements are true about space-saving features in an Oracle Database? (Choose two.)
  1. A
    Private Temporary Tables (PTTS) store metadata in memory only
  2. B
    An index created with the UNUSABLE attribute has no segment
  3. C
    If they exist for a session, Private Temporary Tables (PTTs) are always dropped at the next COMMIT OR ROLLBACK statement
  4. D
    An index that is altered to be UNUSABLE will retain its segment
  5. E
    A table that is truncated will always have its segment removed

Correct Answer:
BC

Question #25
Which two statements are true about the PMON background process? (Choose two.)
  1. A
    It registers database services with all local and remote listeners known to the database instance
  2. B
    It frees resources held by abnormally terminated processes
  3. C
    It records checkpoint information in the control file
  4. D
    It frees unused temporary segments
  5. E
    It kills sessions that exceed idle time

Correct Answer:
AB
Reference:
https://docs.oracle.com/cd/B19306_01/server.102/b14220/process.htm

Previous Questions Next Questions

All Pages