While allocating memory for dynamic components in the System Global Area (SGA), what will be the granule size, if the requested SGA memory is greater than 16 GB and less than or equal to 32 GB?

We can use the following SQL command to disable remote jobs on a database: DROP USER REMOTE_SCHEDULER_AGENT CASCADE;

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?

The given image contains three tables and their attributes. Which of the following queries will determine the names of the Authors whhave written more than one book?

While managing optimizer statistics using cloud control in Oracle Database 12c, which of the following operations will you find on the Manage Optimizer Statistics page?

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?