A table named PurchaseDetails has the following table structure:

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?

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

In Oracle Database 12c, which of the following statements is/are correct about ADMINISTER_RESOURCE_MANAGER system privilege?

For a multitenant environment, which of the following options is the correct command-line tool that can be used tcreate, manage and monitor pluggable and multitenant container databases?

Which of the following components of a container database, is a template that can be used tcreate a new pluggable database while working with a multitenant environment?

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

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?

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.