Choose three of the following statements that are true about performing Data Manipulation Language (DML) operations on a view without having defined any INSTEAD OF triggers.

An uncommitted transaction in progress, which updated 5000 rows in a table, exists in an Oracle database server session.

Choose three of the following situations in which the transactions is completed, committing the updates.

The ORDER_ID column in the ORDERS table has a primary key constraint. 

The ORDER_ID column in the ORDER_ITEMS table has a foreign key constraint, referencing the primary key of the ORDERS table. 

The constraint is defined with ON DELETE CASCADE. There are rows in the ORDERS table with an ORDER_TOTAL of less than 1000. 

Choose two of the following DELETE statements that will execute successfully?

Choose three of the following statements that are true about indexes.

You are asked to calculate the number of days from 1st January 2019 until today. 

Dates are stored in the default format of DD-MON-RR. With which two of the following queries the desired output will be obtained?

Choose three of the following actions that can be performed by using the ORACLE_DATAPUMP access driver.

Choose two of the following statements that are true regarding a SAVEPOINT.

Three of the following privileges can be restricted to a subset of columns in a table. 

Select them.