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?

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?

In Oracle Database 12c. which of the following table types CANNOT have invisible columns?

Which of the following are included in the control f‌ile of Oracle Database 12c?

Which of the following statements are correct about DBMS_REPAIR procedures?

In Oracle Database 12c, which of the following resource consumer groups are the special groups that cannot be modif‌ied or deleted and are always present in the data dictionary?

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

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 create database objects in an undo tablespace.

Which of the given SQL statements is equivalent to the following SQL statement?

What is the relative f‌ile number of a data f‌ile to identify a bigf‌ile tablespace on the 0s/390 platform?