Sure do, here's my favorite:
You have a database with 3000 registered users, you need to lock all accounts
except for a list of 20. How would you do it?
Obviously there's several correct answers. But the one I'm looking for is the
"anonymous PL/SQL block" defined like:
declare
stmt varchar2(200);
begin
for a in (select username from dba_users
where username not in ('SYS','SYSTEM',.......)) loop
stmt := 'alter user '||a.username||' account lock';
execute immediate stmt;
end loop;
end;
/
Dick Goulet
Senior Oracle DBA
Oracle Certified 8i DBA
-----Original Message-----
Sent: Friday, October 24, 2003 12:00 PM
To: Multiple recipients of list ORACLE-L
do any of you ask dbas pl/sql questions? I think its important for DBAs to be good
developers as well. especially if they are part of a development team. I dont think
the skill sets should be seperate. they overlap.
>
> From: "Jamadagni, Rajendra" <[EMAIL PROTECTED]>
> Date: 2003/10/24 Fri AM 11:39:33 EDT
> To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
> Subject: RE: dba interview questions
>
> We prefer to ask their experiences and then throw a curve ball and ask them to
> defend it. Small issues like "Why would/wouldn't an index help?" etc ...
>
> Another question that I *always* ask is "what do you or have you read in last 3
> months outside of Oracle manuals?" or "Do you know any other sites that give you lot
> of oracle related information?" I expect to hear at-least couple form following list
> ... ixora, hotsos, jlcomp, oracle-dba, oraperf, orapub. If they mention that they
> have read YAPP, that's a bonus too.
>
> But if someone says they haven't read anything other than manuals questions become a
> little steep.
>
> Raj
>
> -----Original Message-----
> Sent: Friday, October 24, 2003 9:49 AM
> To: Multiple recipients of list ORACLE-L
>
>
> The problem with such lists is that the prospects also have those...
> A few years ago Mike Ault published one. We used it to screen candidates via phone
> interviews.
> Two out of four I talked to gave me perfect answers: word to word from Mike's list.
>
> Use Conner's approach: Give the candidate a white/black board, and ask him/her to
> draw the SGA
> with all it interal structures, all background processes, and explain how all this
> works
> together.....
>
> - Kirti
>
> **************************************************************************************
> This e-mail message is confidential, intended only for the named recipient(s) above
> and may contain information that is privileged, attorney work product or exempt from
> disclosure under applicable law. If you have received this message in error, or are
> not the named recipient(s), please immediately notify corporate MIS at (860)
> 766-2000 and delete this e-mail message from your computer, Thank you.
> **************************************************************************************4
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.net
> --
> Author: Jamadagni, Rajendra
> INET: [EMAIL PROTECTED]
>
> Fat City Network Services -- 858-538-5051 http://www.fatcity.com
> San Diego, California -- Mailing list and web hosting services
> ---------------------------------------------------------------------
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from). You may
> also send the HELP command for other information (like subscribing).
>
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: <[EMAIL PROTECTED]
INET: [EMAIL PROTECTED]
Fat City Network Services -- 858-538-5051 http://www.fatcity.com
San Diego, California -- Mailing list and web hosting services
---------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from). You may
also send the HELP command for other information (like subscribing).
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: Goulet, Dick
INET: [EMAIL PROTECTED]
Fat City Network Services -- 858-538-5051 http://www.fatcity.com
San Diego, California -- Mailing list and web hosting services
---------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from). You may
also send the HELP command for other information (like subscribing).
