What is true regarding sub queries?

• A. The inner query always sorts the results of the outer query
• B. The outer query always sorts the results of the inner query
• C. The inner query returns a value to the outer query
• D. The inner query must always return a value or the outer query will give an error
• E. The outer query must return a value to the outer query

You need to display the first names of all customers from the CUSTOMERS table that contain the character 'e' and have the character 'a' in the second last position.
Which query would give the required output?

• A. SELECT cust_first_name FROM customers WHERE INSTR(cust_first_name, 'e')<>'' AND SUBSTR(cust_first_name, -2, 1)='a';
• B. SELECT cust_first_name FROM customers WHERE INSTR(cust_first_name, 'e')<>0 AND SUBSTR(cust_first_name, LENGTH(cust_first_name),-2)='a';
• C. SELECT cust_first_name FROM customers WHERE INSTR(cust_first_name, 'e')<>0 AND SUBSTR(cust_first_name, -2, 1)='a';
• D. SELECT cust_first_name FROM customers WHERE INSTR(cust_first_name, 'e')IS NOT NULL AND SUBSTR(cust_first_name, 1,-2)='a';

Examine the structure of the EMPLOYEES and NEW_EMPLOYEES tables:

Which DELETE statement is valid?

• A. DELETE FROM employees WHERE employee_id IN(SELECT employee_id FROM new_employees WHERE name = 'Carrey');
• B. DELETE FROM employees WHERE employee_id =(SELECT employee_id FROM employees);
• C. DELETE * FROM employees WHERE employee_id IN(SELECT employee_id FROM new_employees WHERE last_name = 'Carrey');
• D. DELETE * FROM employees WHERE employee_id =(SELECT employee_id FROM new_employees);

When does a transaction complete? (Choose all that apply.)

• A. When a data definition language statement is executed
• B. When a ROLLBACK command is executed
• C. When a PL/SQL anonymous block is executed
• D. When a DELETE statement is executed
• E. When a TRUNCATE statement is executed after the pending transaction

View the Exhibit and examine the structure of the CUSTOMERS table .Which statement would display the highest credit limit available in each income level in each city in the CUSTOMERS table?

• A. SELECT cust_city, cust_income_level, MAX(cust_credit_limit) FROM customers GROUP BY cust_city, cust_income_level;
• B. SELECT cust_city, cust_income_level, MAX(cust_credit_limit) FROM customers GROUP BY cust_credit_limit, cust_income_level, cust_city ;
• C. SELECT cust_city, cust_income_level, MAX(cust_credit_limit ) FROM customers GROUP BY cust_city, cust_income_level, cust_credit_limit;
• D. SELECT cust_city, cust_income_level, MAX(cust_credit_limit) FROM customers GROUP BY cust_city, cust_income_level, MAX(cust_credit_limit);