READ Free Dumps For Oracle- 1z0-007
| Question ID 7953 | The EMPLOYEES table has these columns: LAST NAME VARCHAR2(35) SALARY NUMBER(8,2) HIRE_DATE DATE Management wants to add a default value to the SALARY column. You plan to alter the table by using this SQL statement: ALTER TABLE EMPLOYEES MODIFY ( SALARY DEFAULT 5000); What is true about your ALTER statement?
|
| Option A | Column definitions cannot be altered to add DEFAULT values.
|
| Option B | A change to the DEFAULT value affects only subsequent insertions to the table.
|
| Option C | Column definitions cannot be altered at add DEFAULT values for columns with a NUMBER data type.
|
| Option D | All the rows that have a NULL value for the SALARY column will be updated with the value 5000.
|
| Correct Answer | B |
Explanation Explanation/Reference: Explanation: A change to the DEFAULT value affects only subsequent insertions to the table. Existing rows will not be affected. Incorrect Answers A: Column definitions can be altered to add DEFAULT values. C: Column definitions can be altered to add DEFAULT values. It works for columns with a NUMBER data type also. D: A change to the DEFAULT value affects only subsequent insertions to the table. Existing rows will not be affected. OCP Introduction to Oracle 9i: SQL Exam Guide, Jason Couchman, p. 219-224 Chapter 5: Creating Oracle Database Objects
| Question ID 7954 | The DBA issues this SQL command: CREATE USER scott IDENTIFIES by tiger; What privileges does the user Scott have at this point?
|
| Option A | No privileges.
|
| Option B | Only the SELECT privilege.
|
| Option C | Only the CONNECT privilege.
|
| Option D | All the privileges of a default user.
|
| Correct Answer | A |
Explanation Explanation/Reference: Explanation: There are no privileges for the user Scott at this point. They are not added themselves to the user immediately after creation. The DBA needs to grant all privileges explicitly. Incorrect Answers B: There are no privileges for the user Scott at this point. SELECT privilege needs to be added to the user Scott. C: There are no privileges for the user Scott at this point. CONNECT privilege needs to be added to the user Scott. D: There is no default user in Oracle. OCP Introduction to Oracle 9i: SQL Exam Guide, Jason Couchman, p. 348-351 Chapter 8: User Access in Oracle