In Oracle Database 12c, how many f‌iles, with up to 4M block each, can be contained by a smallf‌ile tablespace?

While managing diagnostic data in Oracle Database 12c. which of the following files contain a memory dump, in an all- binary and port - specific format?

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?

Which of the following statements are correct about tablespaces in Oracle Database 12c?

While cloning a PDB, which of the following requirements are valid?

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?