A friend recently had a telephone interview for an Oracle technical contract role. Here are the questions he was asked:
- What is the command to edit a crontab?
- What are the first and fourth parameters on the crontab?
- What is the command to email the list of files that are too big and need to be deleted to prevent a tablespace getting too big?
- Have you used the OLAP command? and who invented it?
- When do you set PCTFREE?
- When is the PGA in the SGA?
- Where is the Java pool?
- How do I stop a checkpoint when I commit?