Nope - you will get the diagram and basic description
in Tom's book (and of course the Concepts manual) but
that's not the idea of using this for an interview.
As they (hopefully) draw the SGA you can drift into
"musings" like: "So - if all these changes are in
memory - how do we ensure against no
I always find syntax examples in manuals ... don't know why ...
Raj
-Original Message-
Sent: Friday, October 24, 2003 11:59 AM
To: Multiple recipients of list ORACLE-L
not sure i like the 'read outside the oracle manuals'. I find that alot of people read
alot of really bad books and th
I would have answered:
I'd send the list to the help desk as they take care of logins
and tell them to lock all accounts except the list I send.
What is it you say?? your help desk doesn't do that? Tsk, tsk, tsk...
hehehe
-Original Message-
Sent: Friday, October 24, 2003 1:00 PM
I usually tend to ask questions like what has been your worst disaster
scenario and how did you fix it, what other options would you have had and
why didn't you use these etc.. The same with performance tuning issues...
Tanel.
- Original Message -
To: "Multiple recipients of list ORACLE-
sigh... add to this weekend's reading list Tom's new book (it's sitting
on my dining room table, waiting)
--- [EMAIL PROTECTED] wrote:
> that question is diagrammed and answered in tom kytes new book. :) im
> waiting to get asked it.
>
> there is a new ault book out on interview questions. I do
Title: RE: Re: dba interview questions
and at least if someone takes the time to read a book and get the whole picture, they have some kind of gumshun.
April Wells
Oracle DBA/Oracle Apps DBA
Corporate Systems
Amarillo Texas
Heck, Our helpdesk doesn't even reset passwords!!
Dick Goulet
Senior Oracle DBA
Oracle Certified 8i DBA
-Original Message-
Sent: Friday, October 24, 2003 3:04 PM
To: Multiple recipients of list ORACLE-L
I would have answered:
I'd send the list to the help desk as they take care of lo
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
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:
declar
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 1
not sure i like the 'read outside the oracle manuals'. I find that alot of people read
alot of really bad books and then dont read the stuff on OTN.
oracle has very good docs. I do have a beef over lack of syntax examples...
>
> From: "Jamadagni, Rajendra" <[EMAIL PROTECTED]>
> Date: 2003/10/2
PROTECTED]>
> Date: 2003/10/24 Fri AM 11:29:25 EDT
> To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
> Subject: RE: Re: dba interview questions
>
> Ryan
>Would that diagram be in "Effective Oracle by Design" by Tom Kyte? Can
> you elaborate?
>
Ryan
Would that diagram be in "Effective Oracle by Design" by Tom Kyte? Can
you elaborate?
Dennis Williams
DBA
Lifetouch, Inc.
[EMAIL PROTECTED]
-Original Message-
Sent: Friday, October 24, 2003 9:29 AM
To: Multiple recipients of list ORACLE-L
that question is diagrammed and answere
Oh! Well. I have not seen Tom's book yet.
But still, when the candidate is explaining this stuff to you, there are plenty of
opps to
question him/her to find out if he/she really knows fundamental things..
During one phone interview, we could clearly hear the paper shuffle in the background,
whi
that question is diagrammed and answered in tom kytes new book. :) im waiting to get
asked it.
there is a new ault book out on interview questions. I dont think they are very tough.
I think situational questions are better. Have a development DB set up with things for
the applicant to do.
I
15 matches
Mail list logo
