Which CREATE TABLE statement is valid?

• A.Option C
• B.Option D
• C.Option A
• D.Option B

Comment: *

Name: *

Email: *

Verification: *

Examine the data in the CUST NAME column of the CUSTOMERS table:
CUST_NAME
------------------------------
Renske Ladwig
Jason Mallin
Samuel McCain
Allan MCEwen
Irene Mikkilineni
Julia Nayer
You want to display the CUST_NAME values where the last name starts with Mc or MC. Which two WHERE clauses give the required result?

• A.WHERE UPPER (SUBSTR(cust_name, INSTR(cust_name, '') +1)) LIKE UPPER('MC%')
• B.WHERE SUBSTR(cust_name, INSTR(cust_name,'') +1) LIKE'Mc%'
• C.WHERE INITCAP(SUBSTR(cust_name, INSTR(cust_name,'') +1)) LIKE'Mc%'
• D.WHERE INITCAP (SUBSTR(cust_name, INSTR(cust_name,'') +1)) IN ('MC%','Mc%)
• E.WHERE SUBSTR(cust_name,INSTR(cust_name,'') +1) LIKE'Mc%' OR'MC%'

Comment: *

Name: *

Email: *

Verification: *

You need to display the date 11-oct-2007 in words as 'Eleventh of October, Two Thousand Seven'.
Which SQL statement would give the required result?

• A.SELECT TO_CHAR (TO_DATE ('11-oct-2007'), 'fmDdthsp "of" Month, Year') FROM DUAL
• B.SELECT TO_CHAR ('11-oct-2007', 'fmDdspth "of" Month, Year')
  FROM DUAL
• C.SELECT TO_CHAR (TO_DATE ('11-oct-2007'), 'fmDdspth of month, year')
  FROM DUAL
• D.SELECT TO_DATE (TO_CHAR ('11-oct-2007'), 'fmDdspth "of" Month, Year')) FROM DUAL

Comment: *

Name: *

Email: *

Verification: *

Examine the data in the COLORS table:

Examine the data in the BRICKS table:

Which two queries return all the rows from COLORS?

• A.SELECT.
  FROM bricks b
  RIGHT JOIN colors c
  ON b. color _rgb_ hex_ value = c. rgb hex_ value;
• B.SELECT
  EROM colors C
  LEFT JOIN bricks
  USING (rgb _ hex_ value) ;
• C.SELECT
  FROM bricks b
  FULL JOIN colors C
  ON b. color rgb _ hex_ value = c. rgb _hex_ value;
• D.SELECT *
  EROM bricks | b
  JOIN colors C
  ON b. color_ rgb_ hex_ value =c. rgb _hex value;
• E.SELECT
  EROM colors C
  LEET JOIN bricks b
  ON b. color_ rgb_ hex value = c. rgb. hex.

Comment: *

Name: *

Email: *

Verification: *

View the Exhibit and examine the structure of the EMPLOYEES and JOB_HISTORY tables. (Choose all that apply.) Examine this query which must select the employee IDs of all the employees who have held the job SA_MAN at any time during their employment.
SELECT EMPLOYEE_ID
FROM EMPLOYEES
WHERE JOB_ID = 'SA_MAN'
-------------------------------------
SELECT EMPLOYEE_ID
FROM JOB_HISTORY
WHERE JOB_ID = 'SA_MAN';
Choose two correct SET operators which would cause the query to return the desired result.

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

Comment: *

Name: *

Email: *

Verification: *