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

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

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?

Which of the following statements are correct about DBMS_REPAIR procedures?

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

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?