Interview Questions

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

Oracle DBA Checklist


(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 Interview Questions