Choose the appropriate query for the Products table where data should be displayed. firstly. In ascending order of the ProductGroup column and then. sorting should be in descending order of the CurrentStock column.

CREATE VIEW dept_hq , AS SELECT dept_id. dept_name, |ocation_id, FROM hr.departments, WHERE |ocation_id = 1400, WITH CHECK OPTION CONSTRAINT dept_hq_cnst; Which of the following clauses/statements cannot be included in a CREATE VIEW statement?

In Oracle Database 12c. which of the following indexes are specific tan application/cartridge?

In Oracle Database 12c, which statements can be included in an operation using the CREATE SCHEMA statement? 1.CREATE TABLE statement 2.CREATE VIEW statement 3.GRANT statement

While managing jobs, the value of which of the following additional attributes must be set, if you want tcreate an event—based job in Oracle Database 12C?

Which of the following statements are correct about Global database link?

In Oracle Database 12c. which of the following statements is/are correct about managing Temporary Undo?

Which of the following queries, when run for PurchaseDetails table, will return the names of items and their maximum and minimum prices. such that the maximum price for the items is greater than 600?

A table named PurchaseDetails has the following table structure:

In Oracle Database 12c, which of the following types of operations are NOT permissible in distributed transactions?

In Oracle 12c database, the user session becomes public when you connect with the database as: