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

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

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

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

A.Employee 200 will have JOB_ID set to the same value as the JOB_ID of employee 100

B.Employee 200 will have SALARY set to the same value as the SALARY of employee 100

C.Employee 100 will have SALARY set to the same value as the SALARY of employee 200

D.Employee 100 will have JOB_ID set to the same value as the JOB_ID of employee 200

E.Employees 100 and 200 will have the same SALARY as before the update command

F.Employees 100 and 200 will have the same JOB_ID as before the update command

A.You can use a single instance of EM Express to manage multiple database running on the same server.

B.EM Express uses a separate repository database to store target database metadata.

C.By default, EM express is available for a database after database creation using DBCA.

D.You can shut down a database instance using EM Express.

E.You cannot start up a database instance using EM Express.

A.Grant DBA to KING

B.Alter user KING to be IDENTIFIED EXTERNALLY

C.Have the OS administrator add KING to the OSDBA group

D.Unset REMOTE_LOGIN_PASSWORDFILE

E.Set OS_AUTHENT_PREFIX to OPS$

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

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

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

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

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