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 |
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 |