What is the permissible range of values for DDL_LOCK_TIMEOUT parameter tenable blocking DDL statements twait for locks?

In Oracle 12c Database. which of the following administrative privileges allow(s) you tdrop the database?

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

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

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 tablespace data dictionary views is used to display the total used and free space in all temporary tablespaces?

Which of the following DBMS_STATS procedures for gathering optimizer statistics is used to collect statistics for all system schemas?

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?

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

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