While using DBMS_STATS.SET_'_PREFS procedures for setting statistics preferences, which of the following options is the correct order of precedence?

Which SQL statements will be used to create a table Student having the following attributes, such that the table has a PRIMARY KEY constraint on the column StudentID and also has UNIQUE and NOT NULL constraints on both the columns Phone and City?

In Oracle Database 12c, which of the following statements is NOT valid?

In a multitenant environment, which of the following techniques can be used to create a pluggable database (PDB)? 1.Using the files of a seed 2.C|oning an existing PDB or non—CDB 3.Using an XML metadata f‌ile that describes the PDB and the f‌iles associated with the PDB 4.Moving a non—CDB into a PDB

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?

Which of the following Subqueries will work?

In Oracle Database 12c, which of the following options is/are the correct scheduling method(s) used for job execution?

Which of the following statements can be used tenable or disable triggers in Oracle Database 12C?

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?

Which of the following statements are correct about DBMS_REPAIR procedures?