| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Mailing Lists -> Oracle-L -> RE: RE: dba interview questions
What do you need the stmt for? Just do:
begin
for a in (select username from dba_users
where username not in ('SYS','SYSTEM',.......))
loop
execute immediate 'alter user '||a.username||' account
lock';
end loop;
end;
/
Scott Canaan (srcdco_at_rit.edu)
(585) 475-7886
"Life is like a sewer, what you get out of it depends on what you put
into it." - Tom Lehrer.
-----Original Message-----
Sent: Friday, October 24, 2003 2:00 PM
To: Multiple recipients of list ORACLE-L
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" <Rajendra.Jamadagni_at_espn.com>
> Date: 2003/10/24 Fri AM 11:39:33 EDT
> To: Multiple recipients of list ORACLE-L <ORACLE-L_at_fatcity.com>
> 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
>
>
-- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: <rgaffuri_at_cox.net INET: rgaffuri_at_cox.net 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: ListGuru_at_fatcity.com (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: DGoulet_at_vicr.com 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: ListGuru_at_fatcity.com (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: Scott Canaan INET: srcdco_at_rit.edu 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: ListGuru_at_fatcity.com (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).Received on Fri Oct 24 2003 - 14:24:40 CDT
 |
 |