Which of the following DBMS_STATS procedures for gathering optimizer statistics is used to collect statistics for all system schemas?

In Oracle Database 12c, which of the following tablespace data dictionary views is used to display the total used and free space in all temporary tablespaces?

Which of the following SQL commands disables the force full database caching?

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

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

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

In Oracle 12c Database. which of the following administrative privileges allow(s) you tdrop the database?

What is the permissible range of values for DDL_LOCK_TIMEOUT parameter tenable blocking DDL statements twait for locks?

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

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

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?