DBA > Job Interview Questions > Oracle DBA Checklist

Oracle DBA Checklist - All tables should have un

More DBA job interview questions and answers at http://dba.fyicenter.com/Interview-Questions/

(Continued from previous question...)

Oracle DBA Checklist - All tables should have unique primary keys- Weekly Procedures

a) To check missing PK, run no_pk.sql.
b) To check disabled PK, run disPK.sql.
c) All primary key indexes should be unique. Run nonuPK.sql to check.

(Continued on next question...)

Other Job Interview Questions