Choose two of the following statements that are true regarding scalar subquery expressions.

Choose three of the following statements that are true regarding privileges and roles.

Evaluate the data in the COLORS table:   

Choose two of the following queries that will return all the rows from COLORS table.

Evaluate this description of the PRODUCTS table: 

Rows exist in the table above with data in every column. 

The PRODUCTS table is set in read-only mode. 

Choose three of the following commands that will execute successfully.

Choose two of the following statements that are true regarding transactions in the Oracle Database server.

Evaluate the structure of the PRODUCTS and NEW_PRODUCTS tables. 

Choose two of the following queries that will execute successfully.

You can find the columns EMPLOYEE_ID, JOB_ID and SALARY in the table EMPLOYEES. 

Only the EMPLOYEE_ID column is indexed. 

Rows exist for employees 100 and 200. 

Analyze the statement above. 

Choose two of the following statements that are true.