More DBA job interview questions and answers at
http://dba.fyicenter.com/Interview-Questions/
(Continued from previous question...)
Oracle DBA Checklist - All indexes should use INDEXES tablespace. Run mkrebuild_idx.sql - Weekly Procedures
All indexes should use INDEXES tablespace. Run mkrebuild_idx.sql.
Schemas should look identical between environments, especially test and production.
a) To check data type consistency, run datatype.sql.
b) To check other object consistency, run obj_coord.sql.
c) Better yet, use a tool like Quest Software's Schema Manager.
(Continued on next question...)