View the Exhibit and examine the structure and data in the INVOICE table.

Which statements are true regarding data type conversion in expressions used in queries? (Choose all that apply.)

• A. inv_date > '01-02-2008' : uses implicit conversion
• B. inv_no BETWEEN '101' AND '110' : uses implicit conversion
• C. inv_date = '15-february-2008' : uses implicit conversion
• D. CONCAT(inv_amt,inv_date) : requires explicit conversion
• E. inv_amt ='0255982' : requires explicit conversion

Which statements are true regarding the FOR UPDATE clause in a SELECT statement? (Choose all that apply.)

• A. It can be used in SELECT statements that are based on a single or multiple tables.
• B. After it is enforced by a SELECT statement, no other query can access the same rows until a COMMIT or ROLLBACK is issued.
• C. It locks only the columns specified in the SELECT list.
• D. It can be used only in SELECT statements that are based on a single table.
• E. It locks the rows that satisfy the condition in the SELECT statement.

Evaluate the following SQL statements:
Exhibit:

Which is the correct output of the above query?

• A. +25-00, +54-02, +00 11:12:10.123457
• B. +25-00,+00-650,+00 11:12:10.123457
• C. +00-300, +54-02,+00 11:12:10.123457
• D. +00-300,+00-650,+00 11:12:10.123457

You work as a database administrator at ABC.com. You study the exhibit carefully.
Exhibit:

and examine the structure of CUSTOMRS AND SALES tables:
Evaluate the following SQL statement:
Exhibit:

Which statement is true regarding the execution of the above UPDATE statement?

• A. It would not execute because the SELECT statement cannot be used in place of the table name
• B. It would not execute because a sub query cannot be used in the WHERE clause of an UPDATE statement
• C. It would execute and restrict modifications to only the column specified in the SELECT statement
• D. It would not execute because two tables cannot be used in a single UPDATE statement

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_credit_limit, cust_income_level, cust_city ;
• B. SELECT cust_city, cust_income_level, MAX(cust_credit_limit) FROM customers GROUP BY cust_city, cust_income_level;
• C. SELECT cust_city, cust_income_level, MAX(cust_credit_limit) FROM customers GROUP BY cust_city, cust_income_level, MAX(cust_credit_limit);
• D. SELECT cust_city, cust_income_level, MAX(cust_credit_limit ) FROM customers GROUP BY cust_city, cust_income_level, cust_credit_limit;