Which of the given options is correct about the following twSQL statements?

SELECT last_name, salary, hire_date FROM EMPLOYEES ORDER BY salary DESC

SELECT last_name, salary, hire_date FROM EMPLOYEES ORDER BY 2 DESC

Output of command? SOL> SELECT NAME FROM V$CONTROLFILE;

In Oracle Database 12c. which of the following options is the correct statement for backing up the control f‌ile ta binary file?

If you want tdrop an external destination using DROP_AGENT_DESTINATION procedure in Oracle Database 12C, then which of the following privileges is required tcarry out the task?

Which types of links can be used by a user taccess a remote database? 1.Connected user link 2.Current user link 3.Fixed user link

In Oracle Database 12c. multiple buffer pools are available for which of the following block size caches?

Which of the following statements can be used to change the open mode of a current PDB. from mounted to migrate?

In Oracle Database 12c, which of the following statements can be used to drop redo log group number 3?

Which of the following statements can be used to change the open mode of a current PDB to mounted?

In Oracle Database 12c, what is the minimum size permitted for a redo log file?

In Oracle Database 12c, which of the following statements is NOT correct about Temporary tablespaces?