Pass the Oracle Oracle Database 19c 1z0-082 Questions and answers with CertsForce

Aggregating functions and columns used in HAVING clauses must be specified in the SELECT list of a query

WHERE and HAVING clauses can be used in the same statement only if applied to different table columns

The HAVING clause can be used with aggregating functions in subqueries

The WHERE clause can be used to exclude rows before dividing them into groups

The WHERE clause can be used to exclude rows after dividing them into groups

You can no longer monitor it

You can reattach to it and monitor it

It is paused and can be resumed

It continues to run in the background

It terminates

Column positions must be used in the ORDER BY clause

Only column names from the first SELECT statement in the compound query are recognized

The first column in the first SELECT of the compound query with the UNION operator is used by default to sort output in the absence of an ORDER BY clause

Each SELECT statement in the compound query must have its own ORDER BY clause

Each SELECT statement in the compound query can have its own ORDER BY clause

It has its own commands that are separate from any SQL statements.

It must be downloaded from the Oracle Technology Network (OTN).

It can run scripts entered at the SQL prompt.

It can run Recovery Manager (RMAN) commands.

It has both command-line and graphical user interfaces (GUI).

It can run scripts passed to it by a shell script.

An undo segment may be used by multiple transactions simultaneously

Undo segments can wrap around to the first extent when a transaction fills the last extend of the undo segment

Undo segments have a minimum of three extents

Undo segments can extend when a transaction fills the last extent of the undo segment

A single transaction may use multiple undo segments simultaneously

Undo segments must be stored in a BIGFILE tablespace

Undo segments must be stored in a SMALLFILE tablespace

It must be the value of the SERVICE_NAMES parameter on the client side

It must resolve to a valid connect descriptor in the server’s tnsnames.ora file

It must resolve to a valid connect descriptor in the client’s tnsnames.ora file

It must be the name of the database to whose instance HR wishes to connect

It must be the name of the server running the database to whose instance HR wishes to connect

AUTOEXTEND is possible for the datafile

It must be bigger than the largest SMALLFILE tablespace

Additional data files may not be added

It will be a dictionary-managed tablespace by default

It will always have a 32K blocksize

CURRENT_TIMESTAMP returns the same date and time as SYSDATE with additional details of fractional seconds

SYSDATE can be queried only from the DUAL table

CURRENT_DATE returns the current date and time as per the session time zone

SYSDATE can be used in expressions only if the default date format is DD-MON-RR

SYSDATE and CURRENT_DATE return the current date and time set for the operating system of the database server

CURRENT_TIMESTAMP returns the same date as CURRENT_DATE

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 can be used only in the WHERE clause of a SELECT statement

The argument can be a column name, variable, literal or an expression

The data type returned can be different from the data type of the argument

They can be nested to any level

They can accept only one argument

They return a single result row per table