Depending on what you have him/her doing, you might ask: the basic steps to tuning a query. What to do if you have a bunch of processes blocked. what to do in case of an ora-600/ora-7445 maybe some basic change control what to do with an archiver hung error. On Sun, Feb 6, 2011 at 5:06 PM, Guillermo Alan Bort <cicciuxdba@xxxxxxxxx>wrote: > So, I am in the process of reviewing resumes from several JR and SSR > candidates for the team. The question I came up with is, what kind of > questions (technical) should I ask during the interview. I can't use the > same questions I'd use with a Sr. DBA. > > The questions i've come up with so far are the following: > 1. Difference between EXTENT and BLOCK > 2. Difference between USER and ROLE. When would you use each? > 3. Command to extend a Tablespace (tricky question? should it be datafile?) > 4. Command to backup controlfiles (all you can think of) > 5. Steps to switch archivelog on or off. > 6. Minimum requirements in order to take a level 1 online backup (tricky > question?) > 7. What are the minimum required files to be backed up in order to be able > to recreate the database from scratch in the event of complete media > failure? > > I may come up with more, but that's what I have so far... > > thanks in advance > Alan.- > -- Andrew W. Kerber 'If at first you dont succeed, dont take up skydiving.'