Oracle 1Z0-082 Exam Questions - Real Practice Questions for Guaranteed Success

Question 1

Examine the description of the employees table:

Which query requires explicit data type conversion?

ASELECT join_date FROM employees WHERE join_date > '10-02-2018';

BSELECT join_date I I ' ' II salary FROM employees;

CSELECT SUBSTR<join_date, 1, 2) - 10 FROM employees;

DSELECT join_date + '20' FROM employees; SELECT salary * '120.50' FROM employees;

Correct : A

Options Selected by Other Users:

Mark Question:

Start a Discussions

Submit Your Answer:

ASELECT join_date FROM employees WHERE join_date > '10-02-2018';

BSELECT join_date I I ' ' II salary FROM employees;

CSELECT SUBSTR<join_date, 1, 2) - 10 FROM employees;

DSELECT join_date + '20' FROM employees; SELECT salary * '120.50' FROM employees;

0 / 1500

Question 2

Which two statements are true about the Oracle Data Dictionary?

AIt is owned by the sys user.

BData dictionary base tables can be queried directly.

CIt is owned by the system user.

DData dictionary views are always created with queries that join two or more base tables.

EAll data dictionary view joins base tables to dynamic performance views.

Correct : A, B

Options Selected by Other Users:

Mark Question:

Start a Discussions

Submit Your Answer:

AIt is owned by the sys user.

BData dictionary base tables can be queried directly.

CIt is owned by the system user.

DData dictionary views are always created with queries that join two or more base tables.

EAll data dictionary view joins base tables to dynamic performance views.

0 / 1500

Question 3

Examine this command:

SQL> ALTER TABLE ORDERS SHRINK SPACE COMPACT

Which two statements are true?

AThe high-water mark (HWM) of orders is adjusted.

BOnly queries are allowed on ORDERS while the shrink is executing.

CQueries and DML statements are allowed on ORDERS while the shrink is executing.

DThe shrink operation causes rows to be moved to empty space starting from the beginning of the orders segment.

EDependent indexes become UNUSABLE.

FThe shrink operation causes rows to be moved to empty space starting toward the end of the orders segment.

Correct : C, D

Options Selected by Other Users:

Mark Question:

Start a Discussions

Submit Your Answer:

AThe high-water mark (HWM) of orders is adjusted.

BOnly queries are allowed on ORDERS while the shrink is executing.

CQueries and DML statements are allowed on ORDERS while the shrink is executing.

DThe shrink operation causes rows to be moved to empty space starting from the beginning of the orders segment.

EDependent indexes become UNUSABLE.

FThe shrink operation causes rows to be moved to empty space starting toward the end of the orders segment.

0 / 1500

Question 4

You currently have an active transaction in your session and have been granted select access to vstransaction.

In which three situations will re-executing this query still return a row but with a different XID, indicating a new transaction has started?

Aafter successfully executing a commit or rollback followed by a select statement

Bafter successfully executing a create table as select statement followed by a select for update statement

Cafter successfully executing a commit or rollback followed by a DML statement

Dafter successfully executing a create table statement followed by a create index statement

Eafter successfully executing a DML statement following a failed DML statement

Fafter successfully executing a truncate statement followed by a DML statement

Correct : B, C, F

Options Selected by Other Users:

Mark Question:

Start a Discussions

Submit Your Answer:

Aafter successfully executing a commit or rollback followed by a select statement

Bafter successfully executing a create table as select statement followed by a select for update statement

Cafter successfully executing a commit or rollback followed by a DML statement

Dafter successfully executing a create table statement followed by a create index statement

Eafter successfully executing a DML statement following a failed DML statement

Fafter successfully executing a truncate statement followed by a DML statement

0 / 1500

Question 5

Which two statements are true about interval data types?

AINTERVAL year TO month columns support yearly intervals.

BThe value in an interval day to SECOND column can be copied into an interval year to month column.

CINTERVAL day to second columns support fractions of seconds.

DINTERVAL year to month columns only support monthly Intervals within a single year.

EINTERVAL year to month columns only support monthly intervals within a range of years.

FThe year field in an interval year to month column must be a positive value.

Correct : A, C

Options Selected by Other Users:

Mark Question:

Start a Discussions

Submit Your Answer:

AINTERVAL year TO month columns support yearly intervals.

BThe value in an interval day to SECOND column can be copied into an interval year to month column.

CINTERVAL day to second columns support fractions of seconds.

DINTERVAL year to month columns only support monthly Intervals within a single year.

EINTERVAL year to month columns only support monthly intervals within a range of years.

FThe year field in an interval year to month column must be a positive value.

0 / 1500

Master Oracle 1Z0-082 Exam with Reliable Practice Questions

Options Selected by Other Users:

Options Selected by Other Users:

Options Selected by Other Users:

Options Selected by Other Users:

Options Selected by Other Users: