Check for index owned by sys when table owned by SCOTT select count (*) from dba_indexes where TABLE_NAME in (select object_name from dba_objects where OBJECT_TYPE in ('TABLE') and owner =…

LOCK A USER: alter user SCOTT account lock; UNLOCK A USER: alter user SCOTT account unlock; CHECK STATUS OF USERS: select username,ACCOUNT_STATUS from dba_users where username like '%SCOTT%'; CHECK AND…