Free Oracle 1z0-082 Practice Exam with Questions & Answers | Set: 4

MOD : returns the quotient of a division operation

FLOOR : returns the smallest integer greater than or equal to a specified number

TRUNC : can be used with NUMBER and DATE values

CONCAT : can be used to combine any number of values

CEIL : can be used for positive and negative numbers

UNDO_RETENTION specifies for how long Oracle attempts to keep expired and unexpired UNDO.

UNDO_RETENTION specifies how long all types of UNDO are retained.

Unexpired UNDO is always retained.

Active UNDO is always retained.

UNDO_RETENTION specifies for how long Oracle attempts to keep unexpired UNDO.

A TRUNCATE command issued in a session causes all rows in a GLOBAL TEMPORARY TABLE for the issuing session to be deleted.

GLOBAL TEMPORARY TABLE rows inserted by a session are available to any other session whose user has been granted select on the table.

GLOBAL TEMPORARY TABLE space allocation occurs at session start.

Any GLOBAL TEMPORARY TABLE rows existing at session termination will be deleted.

A GLOBAL TEMPORARY TABLE’S definition is available to multiple sessions.

A DELETE command on a GLOBAL TEMPORARY TABLE cannot be rolled back.

It is owned by the sys user.

Data dictionary base tables can be queried directly.

It is owned by the system user.

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

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

Ensure that DB_RECOVERY_FILE_DEST and DB_CREATE_FILE_DEST each specify with at least 50 Mb of available space.

Specify a path in the DATAFILE clause of the command specifying a location with at least 100M of available space.

Ensure that DB_CREATE_FILE_DEST specifies a location with at least 100 Mb of available space.

Add the AUTOEXTEND ON clause with NEXT set to 100M.

Ensure that DB_RECOVERY_FILE_DEST and DB_CREATE_FILE_DEST each specify locations with at least 50 Mb of available space.

INTERSECT

UNION ALL

UNION

SUBTRACT

MINUS

The online redo logs are opened

The online data files are opened

The alert log records the execution details

The Oracle background processes are started

The initialization parameter file is read

The control file is read

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

SELECT join_date I I ' ' II salary FROM employees;

SELECT SUBSTR

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

writing inbound request to the common request queue from all shared server connections

checking for outbound shared server responses on the common outbound response queue

receiving inbound requests from processes using shared server connections

sending each connection input request to the appropriate shared server input queue

broadcasting shared server session responses back to requesters on all connections

sending shared server session responses back to requesters on the appropriate connection

They must be placed on the right side of the comparison operator or condition.

They must be placed on the left side of the comparison operator or condition.

They can be used in the where clause.

A SQL statement may have multiple single row subquery blocks.

They must return a row to prevent errors in the SQL statement.

They can be used in the having clause.