SELECT dept_id, AVG(MAX(salary)) FROM employees GROUP BY dept_id;

SELECT dept_id, join_date, SUM(salary) FROM employees GROUP BY dept_id;

SELECT dept_id, join_date, SUM(salary) FROM employees GROUP BY dept_id,
join_date;

SELECT dept_id, MAX(AVG(salary)) FROM employees GROUP BY dept_id;

The Oracle Net Configuration Assistant is only used when running the Oracle installer

Oracle Net Manager can be used to centrally configure listeners on any database server
target

The lsnrctl utility requires a listener.ora file to exist before it is started

Oracle Net Manager can be used to locally configure naming methods on a database server

Enterprise Manager Cloud Control can be used to centrally configure listeners on any managed database server

They can be written by server processes

Trace files are written to the Fast Recovery Area (FRA)

They can be written by background processes

All trace files contain error information that require contacting Oracle Support

Trace file names are based on the database name concatenated with a sequential number

The Oracle join syntax supports creation of a Cartesian product of two tables

The Oracle join syntax performs better than the SQL:1999 compliant ANSI join syntax

The SQL:1999 compliant ANSI join syntax supports natural joins

The SQL:1999 compliant ANSI join syntax supports creation of a Cartesian product of two tables

The Oracle join syntax only supports right outer joins

SELECT &&col1, &&col2FROM &tableWHERE &&condition = &&cond;

SELECT &col1, &col2FROM &&tableWHERE &condition;

SELECT &col1, &col2FROM “&table”WHERE &condition;

SELECT ‘&&col1’, ‘&&col2’FROM &tableWHERE ‘&&condition’ = ‘&cond’;

SELECT &&col1, &&col2FROM &tableWHERE &&condition;

SELECT NVL(cust_credit_linit * .15, ‘Not Available’) FROM customers;

SELECT NVL2(cust_credit_linit * .15, ‘Not Available’) FROM customers;

SELECT NVL(TO_CHAR(cust_credit_limit * .15), ‘Not Available’) FROM customers;

SELECT TO_CHAR(NVL(cust_credit_limit * .15, ‘Not Available’)) FROM customers;

SELECT NVL2(cust_credit_limit, TO_CHAR(cust_credit_limit * .15), ‘Not Available’) FROM customers;

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

Duplicates are eliminated automatically by the UNION ALL operator

The number of columns selected in each SELECT statement must be identical

The names of columns selected in each SELECT statement must be identical

The output is sorted by the UNION ALL operator

NULLS are not ignored during duplicate checking