Go back to
C2090-919 - Informix 11.70 System Administrator Exam
What does the following SQL statement do? execute function task("reset sysadmin", "admindbs");
Renames sysadmin database to admindbs.
Purges all "mon_*" tables in sysadmin database as user admindbs.
Turns the whole Database Scheduler off and finally drops sysadmin database.
Locks sysadmin database in exclusive mode and recreates it in dbspace admindbs.
Want to practice for C2090-919 - Informix 11.70 System Administrator Exam ?