1z0-082 Free Practice Test

You have been tasked to create a table for a banking application. One of the columns must meet three requirements:
Be stored in a format supporting date arithmetic without using conversion functions
Store a loan period of up to 10 years
Be used for calculating interest for the number of days the loan remains unpaid Which data type should you use?

1. A. INTERVAL YEAR TO MONTH
2. B. INTERVAL DAY TO SECOND
3. C. TIMESTAMP WITH LOCAL TIMEZONE
4. D. TIMESTAMP
5. E. TIMESTAMP WITH TIMEZONE

Correct Answer: B

Which three Oracle database space management features will work with both Dictionary and Locally managed tablespaces? (Choose three.)

1. A. Oracle Managed Files (OMF)
2. B. Online table segment shrink
3. C. Online index segment shrink
4. D. Automatic data file extension (AUTOEXTEND)
5. E. Capacity planning growth reports based on historical data in the Automatic Workload Repository (AWR)

Correct Answer: ADE

Which two statements are true about the Automatic Diagnostic Repository (ADR)? (Choose two.)

1. A. The ADR base defaults to $ORACLE_HOME/rdbms/admin ifneither DIAGNOSTIC_DEST nor ORACLE_BASE is set
2. B. The ADR base defaults to $ORACLE_HOME/dbs if the DIAGNOSTIC_DEST parameter and the ORACLE_BASE environment variable are not set
3. C. It supports diagnostics for Automatic Storage Management (ASM)
4. D. It supports diagnostics for Oracle Clusterware
5. E. It is held inside an Oracle database schema

Correct Answer: AE

Which three statements are true about inner and outer joins? (Choose three.)

1. A. A full outer join returns matched and unmatched rows
2. B. An inner join returns matched rows
3. C. Outer joins can only be used between two tables per query
4. D. A full outer join must use Oracle syntax
5. E. Outer joins can be used when there are multiple join conditions on two tables
6. F. A left or right outer join returns only unmatched rows

Correct Answer: ABF

Which three statements are true about time zones, date data types, and timestamp data types in an Oracle database? (Choose three.)

1. A. The CURRENT_TIMESTAMP function returns data without time zone information
2. B. A TIMESTAMP WITH LOCAL TIMEZONE data type column is stored in the database using the time zone of the session that inserted the row
3. C. A TIMESTAMP data type column contains information about year, month, and day
4. D. The DBTIMEZONE function can return an offset from Universal Coordinated Time (UTC)
5. E. The SESSIONTIMEZONE function can return an offset from Universal Coordinated Time (UTC)

Correct Answer: ADE