Which from the following are true regarding multitable INSERT statements? (Select three.)

The columns PROD_ID and QUANTITY_SOLD of data type NUMBER belong to the SALES table. 

Which from the following queries would execute successfully? (Select two.)

Evaluate all statements below which were executed in a single Oracle session: 

Which from the following statements are true? (Select three.)

Which from the following statements are true regarding columns which are dropped from a table? (Select two.)

In the EMPLOYEES table are included columns EMP_ID of data type NUMBER and HIRE_DATE of data type DATE. 

You need to display the first Monday’s date after having passed six months from the hiring date. In the session, the NLS_TERRITORY parameter is set to AMERICA, for which Sunday is the first week day. 

Which from the following queries can satisfy the requirement?

Analyze the description of the CUSTOMERS table below:

 In order to display details of those customers whose cities of residence begin with the letter D followed by at least two characters, 

which from the following queries would you use?

Which from the following statements are true regarding multiple row subqueries? (Select three.)

Which of the following situations always imply the start of a new transaction? (Select three.)