Real Time Training - Week-2(Day 6 - 10)
Day - 7(Exercise)| 1. Create a user(without any role) with password oracle123 and the user should belong to user_data tablespace ? |
| 2. Connect to the database as user and create a table tab01 as select * from all_objects ? |
| 3. Check and rectify the error ? |
| 4. Create a user with password expiration limit in 2 days ? |
| 5. Password should have one capital letter, number, special character ? |
| 6. Should not allow the old password to be reused and account to be locked after 3 wrong attempts ? |
| 7. Password expiration, recreate password ? |
| 8. Create a job to gather the stat for schema - SCOTT every one hour ? |
| 9. Create a job to find the fragmentation ? |
