READ Free Dumps For Oracle- 1z0-001
| Question ID 8188 | 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 task successfully? |
| Option A | GRANT CREATE TABLE, CREATE PACKAGE TO smith; |
| Option B | GRANT CREATE TABLE, CREATE PROCEDURE TO smith; |
| Option C | GRANT CREATE SESSION,CREATE TABLE,CREATE PROCEDURE TO smith; |
| Option D | GRANT CREATE CONNECT,CREATE TABLE,CREATE PROCEDURE TO smith; |
| Correct Answer | C |
| Question ID 8189 | The EMP table contains columns to hold the birthdate and the hire date of the employees. Both of these columns are defined with date as their data type. You want to insert a row with the details of the employee Smith who was born in 1944 and hired in 2004. Which statement will ensure that values are inserted into the table in the correct century? |
| Option A | INSERT INTO EMP(empno,ename,birthdate,hiredate) VALUES(EMPNO_SEQ.NEXTVAL, 'Smith', '12-dec-44', '10-jun-04' ) |
| Option B | INSERT INTO EMP(empno,ename,birthdate,hiredate) VALUES(EMPNO_SEQ.NEXTVAL, 'Smith', TO_DATE('12-dec-44', 'DD-MON-RR'), TO_DATE('10-jun-04', 'DD-MON-RR')); |
| Option C | INSERT INTO EMP(empno,ename,birthdate,hiredate) VALUES(EMPNO_SEQ.NEXTVAL, 'Smith', TO_DATE('12-dec-44', 'DD-MON-YY'), '10-jun-04'); |
| Option D | INSERT INTO EMP(empno,ename,birthdate,hiredate) VALUES(EMPNO_SEQ.NEXTVAL, 'Smith', TO_DATE('12-dec-44', 'DD-MON-YY'), TO_DATE('10-jun-04', 'DD-MON-YY')); |
| Correct Answer | D |