READ Free Dumps For Oracle- 1z0-007
Question ID 1702 | Click the Exhibit button to examine the structures of the EMPLOYEES and TAX tables. |
Option A | A. You cannot find the information because there is no common column between the two tables. |
Option B | B. SELECT employee_id, salary, tax_percent |
Option C | C. SELECT employee_id, salary, tax_percent |
Option D | D. SELECT employee_id, salary, tax_percent FROM employees e JOIN tax t |
Correct Answer | C |
Question ID 1703 | Which SELECT statement will get the result 'elloworld' from the string 'HelloWorld'? |
Option A | A. SELECT SUBSTR( 'HelloWorld',1) FROM dual; |
Option B | B. SELECT INITCAP(TRIM ('HelloWorld', 1,1)) FROM dual; |
Option C | C. SELECT LOWER(TRIM ('H' FROM 'HelloWorld')) FROM dual; |
Option D | D. SELECT LOWER(SUBSTR('HelloWorld', 1, 1) FROM dual; |
Correct Answer | C |