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 ?
Recent Videos | Today

Fragmentationm

Description about Fragmentationm

Oracle Installation

Description about Installation