We can create database objects in an undo tablespace.

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 table types CANNOT have invisible columns?

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?