Examine the data in the CUST_NAMEcolumn of the CUSTOMERStable.
CUST_NAME
-------------------
Renske Ladwig
Jason Mallin
Samuel McCain
Allan MCEwen
Irene Mikilineni
Julia Nayer
You need to display customers' second names where the second name starts with "Mc" or "MC".
Which query gives the required output?

• A.SELECT SUBSTR (cust_name, INSTR (cust_name, ' ')+1)
  FROM customers
  WHERE INITCAP (SUBSTR(cust_name, INSTR (cust_name, ' ')+1))
  LIKE 'Mc%';
• B.SELECT SUBSTR (cust_name, INSTR (cust_name, ' ')+1)
  FROM customers
  WHERE INITCAP (SUBSTR(cust_name, INSTR (cust_name, ' ')+1))
  INITCAP 'MC%';
• C.SELECT SUBSTR (cust_name, INSTR (cust_name, ' ')+1)
  FROM customers
  WHERE SUBSTR (cust_name, INSTR (cust_name, ' ')+1)
  LIKE INITCAP ('MC%');
• D.SELECT SUBSTR (cust_name, INSTR (cust_name, ' ')+1)
  FROM customers
  WHERE INITCAP (SUBSTR(cust_name, INSTR (cust_name, ' ')+1))
  'Mc';

Comment: *

Name: *

Email: *

Verification: *

View and Exhibit and examine the structure and data in the INVOICE table. (Choose two.)

Which two statements are true regarding data type conversion in query expressions?

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

Comment: *

Name: *

Email: *

Verification: *

View the Exhibit and examine the structure of the ORDER_ITEMS table.

Examine the following SQL statement:
SELECT order_id, product_id, unit_price
FROM order_items
WHERE unit_price
(SELECT MAX(unit_price)
FROM order_items
GROUP BY order_id);
You want to display the PRODUCT_ID of the product that has the highest
UNIT_PRICE per ORDER_ID. What correction should be made in the above SQL statement to achieve this?

• A.Remove the GROUP BY clause from the subquery and place it in the main query
• B.Replace = with the >ANY operator
• C.Replace = with the >ALL operator
• D.Replace = with the IN operator

Comment: *

Name: *

Email: *

Verification: *

View the Exhibit and examine the structure of the CUSTOMERS and CUST_HISTORY tables.

The CUSTOMERS table contains the current location of all currently active customers.
The CUST_HISTORY table stores historical details relating to any changes in the location of all current as well as previous customers who are no longer active with the company.
You need to find those customers who have never changed their address.
Which SET operator would you use to get the required output?

• A.UNION
• B.INTERSECT
• C.UNION ALL
• D.MINUS

Comment: *

Name: *

Email: *

Verification: *

Which four statements are true regarding primary and foreign key constraints and the effect they can have on table data?

• A.The foreign key columns and parent table primary key columns must have the same names.
• B.A table can have only one primary key and one foreign key.
• C.Primary key and foreign key constraints can be defined at both the column and table level.
• D.It is possible for child rows that have a foreign key to be deleted automatically from the child table at the time the parent row is deleted
• E.A table can have only one primary key but multiple foreign keys.
• F.It is possible for child rows that have a foreign key to remain in the child table at the time the parent row is deleted.
• G.Only the primary key can be defined at the column and table level.

Comment: *

Name: *

Email: *

Verification: *