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- 1z0-007





Question ID 8041

User Mary has a view called EMP_DEPT_LOC_VU that was created based on the EMPLOYEES, DEPARTMENTS, and LOCATIONS tables. She has the privilege to create a public synonym, and would like to create a synonym for this view that can be used by all users of the database. Which SQL statement can Mary use to accomplish that task?

Option A

CREATE PUBLIC SYNONYM EDL_VU ON emp_dept_loc_vu

Option B

CREATE PUBLIC SYNONYM EDL:VU FOR mary (emp_dept_loc_vu);

Option C

CREATE PUBLIC SYNONYM EDL_VU FOR emp _dept_loc_vu;

Option D

CREATE SYNONYM EDL_VU ON emp_dept_loc_vu FOR EACH USER;

Option E

CREATE SYNONYM EDL_VU FOR EACH USER ON emp_dept_loc_vu

Option F

CREATE PUBLIC SYNONYM EDL_VU ON emp_dept_loc_vu FOR ALL USERS;

Correct Answer C
Explanation Explanation: The general syntax to create a synonym is: CREATE [PUBLIC] SYNONYM synonym FOR object;


Question ID 8042

Which statement accomplish this?

Option A

CREATE TABLE orders ( order_id NUMBER (10), customer_id NUMBER (8), order_status VARCHAR2 (10), date_ordered DATE = SYSDATE);

Option B

CREATE TABLE orders ( order_id NUMBER (10), customer_id NUMBER (8), order_status VARCHAR2 (10), date_ordered DATE DEFAULT SYSDATE);

Option C

CREATE OR REPLACE TABLE orders ( order_id NUMBER (10), customer_id NUMBER (8), order_status VARCHAR2 (10), date_ordered DATE DEFAULT SYSDATE);

Option D

CREATE OR REPLACE TABLE orders ( order_id NUMBER (10), customer_id NUMBER (8), order_status NUMBER (10), date_ordered DATE = SYSDATE);

Option E

CREATE TABLE orders ( order_id NUMBER (10), customer_id NUMBER (8), order_status NUMBER (10), date_ordered DATE = SYSDATE);

Option F

CREATE TABLE orders ( order_id NUMBER (10), customer_id NUMBER (8), order_status NUMBER (10), date_ordered DATE DEFAULT SYSDATE);

Correct Answer B
Explanation

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