1z0-082 Premium Exam Questions

as SCOTT in DALLAS_DB

as SCOTT in BOSTON_DB

as SCOTT in BOSTON_DB and SYS in DALLAS_DB

as SYS in both the databases

as SCOTT in both the databases

Sequences can always have gaps.

A sequence can Issue duplicate values.

A sequence's unallocated cached values are lost if the instance shuts down.

Two or more tables cannot have keys generated from the same sequence.

A sequence can only be dropped by a DBA.

A sequence number that was allocated can be rolled back if a transaction fails.

The CURRENT_TIMESTAMP function returns data without time zone information

A TIMESTAMP WITH LOCAL TIMEZONE data type column is stored in the database using the time zone of the session that inserted the row

A TIMESTAMP data type column contains information about year, month, and day

The DBTIMEZONE function can return an offset from Universal Coordinated Time (UTC)

The SESSIONTIMEZONE function can return an offset from Universal Coordinated Time (UTC)

The second rollback command restores the row that was inserted.

The first rollback command leaves the table's 100 original rows locked.

The second rollback command rolls back the rollback to savepoint a command.

The first rollback command leaves the inserted row locked.

The first RollBack command restores the row that was inserted.

The second rollback command restores the 100 rows that were in the table originally.

The first rollback command restores the 100 rows that were in the table originally.