READ Free Dumps For Oracle- 1z1-051
Question ID 4972 | Examine the statement: |
Option A | A. An error is generated. |
Option B | B. You will have two identical tables in the HR schema with different names. |
Option C | C. You create a table called employees in the HR schema based on you EMP table. |
Option D | D. You create an alternative name for the employees table in the HR schema in your own schema. |
Correct Answer | D |
Question ID 4973 | Examine the structure of the EMPLOYEES table: EMPLOYEE_IDNUMBERPrimary Key FIRST_NAMEVARCHAR2 (25) LAST_NAMEVARCHAR2 (25) HIRE_DATEDATE |
Option A | A. UPDATE employees SET first_name = ‘John’ SET last_name = ‘Smith’ WHERE employee_id = 180; |
Option B | B. UPDATE employees SET first_name = ‘John’, SET last_name = ‘Smoth’ WHERE employee_id = 180; |
Option C | C. UPDATE employee SET first_name = ‘John’ AND last_name = ‘Smith’ WHERE employee_id = 180; |
Option D | D. UPDATE employee |
Correct Answer | D |