AllExam Dumps

DUMPS, FREE DUMPS, VCP5 DUMPS| VMWARE DUMPS, VCP DUMPS, VCP4 DUMPS, VCAP DUMPS, VCDX DUMPS, CISCO DUMPS, CCNA, CCNA DUMPS, CCNP DUMPS, CCIE DUMPS, ITIL, EXIN DUMPS,


READ Free Dumps For Oracle- 1z1-051





Question ID 4972

Examine the statement:
Create synonym emp for hr.employees;
What happens when you issue 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
Explanation


Question ID 4973

Examine the structure of the EMPLOYEES table: EMPLOYEE_IDNUMBERPrimary Key FIRST_NAMEVARCHAR2 (25) LAST_NAMEVARCHAR2 (25) HIRE_DATEDATE
Which UPDATE statement is valid?
 

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
SET first_name = ‘John’, last_name = ‘Smith’ WHERE employee_id = 180;
 

Correct Answer D
Explanation

Send email to admin@getfreedumps for new dumps request!!!