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?

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

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

Which of the following Subqueries will work?

While working with Oracle Database 12c. which of the following transaction control statements are supported in distributed transaction?

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

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

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

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?

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