READ Free Dumps For Oracle- 1z0-001
Question ID 1497 | As a DBA, you have just created a user account for employee Smith by using the CREATE USER command. Smith should be able to create tables and packages in his schema. Which command will the DBA need to execute next so that Smith can perform his tasks successfully? |
Option A | A. GRANT CREATE CONNECT, CREATE TABLE, CREATE PROCEDURE TO smith; |
Option B | B. GRANT CREATE TABLE, CREATE PACKAGE TO smith; |
Option C | C. GRANT CREATE TABLE, CREATE PROCEDURE TO smith; |
Option D | D. GRANT CREATE SESSION, CREATE TABLE, CREATE PROCEDURE TO smith; |
Correct Answer | D |
Question ID 1498 | Evaluate this IF statement: value > 100 THEN |
Option A | A. 250 |
Option B | B. 1250 |
Option C | C. 750 |
Option D | D. 500 |
Correct Answer | D |