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

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

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?

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?

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

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.