READ Free Dumps For Oracle- 1z0-001
| Question ID 1643 | You have decided to permanently remove all the data from the STUDENT table, and you need the table structure in the future. Which single command performs this? |
| Option A | A. DELETE * FROM student KEEP STRUCTURE; |
| Option B | B. DELETE * FROM student; |
| Option C | C. TRUNCATE TABLE student; |
| Option D | D. TRUNCATE TABLE student KEEP STRUCTURE; |
| Option E | E. DROP TABLE student; |
| Correct Answer | C |
| Question ID 1644 | You are updating the employee table. Jane has been granted the same privileges as you on the employee table. You ask Jane to log on to the database to check your work before you issue a COMMIT command. What can Jane do to the employee table? |
| Option A | A. Jane can access the table, but she cannot see your changes and cannot make the same changes. |
| Option B | B. Jane cannot access the table. |
| Option C | C. Jane can access the table, but she cannot see your changes. She can make the changes for you. |
| Option D | D. Jane can access the table and verify your changes. |
| Correct Answer | A |