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 7985

Examine the structure of the EMPLOYEES table: EMPLOYEE_ID NUMBER Primary Key FIRST_NAME VARCHAR2(25) LAST_NAME VARCHAR2(25) Which three statements insert a row into the table? (Choose three.)

Option A

INSERT INTO employees VALUES (NULL, 'John', 'smith');

Option B

INSERT INTO employees (first_name, last_name) VALUES ('John', 'smith');

Option C

INSERT INTO employees VALUES ('1000, 'John', 'smith');

Option D

INSERT INTO employees (first_name, last_name, employee_id) VALUES (1000, 'John', 'smith');

Option E

INSERT INTO employees (employee_id) VALUES (1000);

Option F

INSERT INTO employees ( employee_id, first_name, last_name, ) VALUES (1000, 'John','');

Correct Answer CEF
Explanation Explanation/Reference: Explanation : EMPLOYEE_ID is a primary key. Incorrect answer : A EMPLOYEE_ID cannot be null B EMPLOYEE_ID cannot be null D mismatch of field_name with datatype Refer : Introduction to Oracle9i : SQL, Oracle University Study Guide, 10-11


Question ID 7986

The user Sue issues this SQL statement: GRANT SELECT ON sue. EMP TO alice WITH GRANT OPTION; The user Alice issues this SQL statement: GRANT SELECT ON sue. EMP TO reena WITH GRANT OPTION; The user Reena issues this SQL statement: GRANT SELECT ON sue. EMP TO timber; The user Sue issues this SQL statement: REVOKE select on sue. EMP FROM alice; For which users does the revoke command revoke SELECT privileges on the SUE.EMP table?

Option A

Alice only

Option B

Alice and Reena

Option C

Alice, Reena, and Timber

Option D

Sue, Alice, Reena, and Timber

Correct Answer C
Explanation Explanation : use the REVOKE statement to revoke privileges granted to other users. Privilege granted to others through the WITH GRANT OPTION clause are also revoked. Alice, Reena and Timber will be revoke. Incorrect answer : A the correct answer should be Alice, Reena and Timber B the correct answer should be Alice, Reena and Timber D the correct answer should be Alice, Reena and Timber Refer : Introduction to Oracle9i : SQL, Oracle University Study Guide, 13-17

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