In the Exhibit below, the COMMISSION column reports the monthly commission earned by the employee. 

Which of the following tasks would need subqueries or joins in order to be accomplished in one step? (Select two.)

Analyze the structure of the following customers table: In the table, CUSTNO is the primary key. 

You list all duplicate names in order to find out if any details of customers have been repeatedly entered by using different CUSTNO. 

Which methods could you use to produce the required outcome? (Select two.)

In order to display the date 11-Oct-2007 in words as 'Eleventh of October, Two Thousand Seven', which of the following SQL statement would produce the required outcome?

Examine the structure of the CUSTOMERS table below. 

Which of the following SQL statements would display the highest credit limit available for each income level and city from the CUSTOMERS table?

Select, from the following CREATE TABLE statements, the one which is valid.

Which of the following options is a system privilege?

Which of the following statements is true about synonyms?

Analyze the following SQL statements: 

SELECT INTERVAL ‘300’ MONTH, INTERVAL ’54-2’ YEAR TO MONTH, INTERVAL ’11:12:10.1234567’ HOUR TO SECOND FROM dual; 

Which option reflects the correct output of the above query?