Oracle DBA Checklist - Weekly Procedures - No_pk

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

(Continued from previous question...)

Oracle DBA Checklist - Weekly Procedures - No_pk.sql

-- no_pk.sql
--
-- To find tables without PK constraint


SELECT table_name
FROM all_tables
WHERE owner = '&OWNER'
MINUS
SELECT table_name
FROM all_constraints
WHERE owner = '&&OWNER'
AND constraint_type = 'P'

(Continued on next question...)

Other Job Interview Questions

• Oracle DBA Checklist - Look for objects that break rules- Weekly Procedures
• Oracle DBA Checklist - Nightly Procedures - mk_volfact.sql
• Oracle DBA Checklist - All tables should have unique primary keys- Weekly Procedures
• Oracle DBA Checklist - Look for security policy violations - Weekly Procedures
• Oracle DBA Checklist - Weekly Procedures - datatype.sql
• Oracle DBA Checklist - Daily Procedures - Space.sq
• Oracle DBA Checklist - Nightly Procedures - mk_volfact.sql
• Oracle DBA Checklist - -Identify bad growth projections - Daily Procedures
• Oracle DBA Checklist - Copy Archived Logs to Standby Database and Roll Forward - Daily Procedures
• Oracle DBA Checklist - Visit home pages of key vendors - Weekly Procedures
• More...