in the undo tablespace

in the SYSAUX tablespace

in the SGA

in the PGA

in the temporary tablespace

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)

T1, an index segment for the primary key, a LOB segment, and a lobindex segment

no segments are created

T1 only

T1 and an index segment created for the primary key only

T1, an index segment for the primary key, and a LOB segment only

A substitution variable prefixed with & always prompts only once for a value in a session.

A substitution variable prefixed with to prompts only once for a value in a session unless it is set to undefined in the session

A substitution variable can be used only in a select statement.

A substitution variable used to prompt for a column name must be enclosed in single quotation marks.

A substitution variable can be used with any clause in a select statement.

A substitution variable used to prompt for a column name must be enclosed in double quotation marks.

It can be used only in SQL*Plus

It displays values for variables used only in the WHERE clause of a query

It can be used in SQL Developer and SQL*Plus

It displays values for variables created by the DEFINE command

It displays values for variables prefixed with & &

d3_32k_cache_size should be set to a value greater than db_cache_size.

db_32k_cache_size must be set to a value that can be accommodated in the SGA.

db_32r_cache_si2e must be less than db_ca=he_size.

db_cache_s:ze must be set to a size that is smaller than db_32k_cache_size.

The /u02 file system must have at least lOOg space for the datafile.

The operating system must use a 32k block size.

Rolling back to a SAVEPOINT can undo a CREATE INDEX statement

Rolling back to a SAVEPOINT can undo a TRUNCATE statement

Only one SAVEPOINT may be issued in a transaction

A SAVEPOINT does not issue a COMMIT

Rolling back to a SAVEPOINT can undo a DELETE statement

SALES1 has not NULL constraints on any selected columns which had those constraints in the sales table.

SALES1 has primary key and unique constraints on any selected columns which had those constraints in the sales table.

SALES1 is created with 55,000 rows.

SALES1 is created with no rows.

SALES1 is created with 1 row.

Private database link creation requires the same user to exist in both the local and the remote databases.

A public database link can be created only by sys.

A database link can be created only between two Oracle databases.

A public database link can be used by a user connected to the local database instance to connect to any schema in the remote database instance.

A database link created in a database allows a connection from that database ' s instance to the target database ' s Instance, but not vice versa.

The second ROLLBACK command does nothing

The second ROLLBACK command replays the delete

The first ROLLBACK command restores the 101 rows that were deleted, leaving the inserted row still to be committed

The second ROLLBACK command undoes the insert

The first ROLLBACK command restores the 101 rows that were deleted and commits the inserted row