Oracle DBA Checklist - Weekly Procedures - disPK

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

(Continued from previous question...)

Oracle DBA Checklist - Weekly Procedures - disPK.sql

-- disPK.sql
--
-- To find out which primary keys are disabled


SELECT owner, constraint_name, table_name, status
FROM all_constraints
WHERE owner = '&OWNER' AND status = 'DISABLED' AND constraint_type = 'P'

(Continued on next question...)

Other Job Interview Questions

• Oracle DBA Checklist - Read DBA manuals for one hour - Daily Procedures
• Oracle DBA Checklist - Daily Procedures - Space.sq
• Oracle DBA Checklist - Look for Harmful Growth Rates - Monthly Procedures
• Oracle DBA Checklist - Copy Archived Logs to Standby Database and Roll Forward - Daily Procedures
• Oracle DBA Checklist - -Verify rollback segment - Daily Procedures
• Oracle DBA Checklist - -Verify DBSNMP is running - Daily Procedures
• Oracle DBA Checklist - Nightly Procedures - mk_volfact.sql
• Oracle DBA Checklist - Daily Procedures - nr_extents.sql
• Oracle DBA Checklist - -Verify rollback segment - Daily Procedures
• Oracle DBA Checklist - -Verify DBSNMP is running - Daily Procedures
• More...