Explain an ORA-01555

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

(Continued from previous question...)

24. Explain an ORA-01555

You get this error when you get a snapshot too old within rollback. It can usually be solved by increasing the undo retention or increasing the size of rollbacks. You should also look at the logic involved in the application getting the error message.

(Continued on next question...)

Other Job Interview Questions

• What command would you use to encrypt a PL/SQL application?
• Which parameter specified in the DEFAULT STORAGE clause of CREATE TABLESPACE cannot be altered after creating the tablespace?
• What is a schema?
• From which designation is it preferred to send the output to the printed?
• What is a physical page? What is a logical page?
• At what point of report execution is the before Report trigger fired?
• What are the different styles of activation of ole Objects?
• How do you add a data file to a tablespace?
• Explain the difference between $ORACLE_HOME and $ORACLE_BASE.
• Display Odd/ Even number of records
• More...