Path: dp-news.maxwell.syr.edu!spool.maxwell.syr.edu!news-spur1.maxwell.syr.edu!news.maxwell.syr.edu!postnews.google.com!j33g2000cwa.googlegroups.com!not-for-mail From: "Mark D Powell" Newsgroups: comp.databases.oracle.server Subject: Re: Interview Questions(Oracle9i DBA), help me Date: 3 Mar 2006 07:08:42 -0800 Organization: http://groups.google.com Lines: 17 Message-ID: <1141398522.346139.261960@j33g2000cwa.googlegroups.com> References: <1141396393.059303.129060@z34g2000cwc.googlegroups.com> NNTP-Posting-Host: 192.85.50.1 Mime-Version: 1.0 Content-Type: text/plain; charset="iso-8859-1" X-Trace: posting.google.com 1141398527 14212 127.0.0.1 (3 Mar 2006 15:08:47 GMT) X-Complaints-To: groups-abuse@google.com NNTP-Posting-Date: Fri, 3 Mar 2006 15:08:47 +0000 (UTC) In-Reply-To: <1141396393.059303.129060@z34g2000cwc.googlegroups.com> User-Agent: G2/0.2 X-HTTP-UserAgent: Mozilla/4.0 (compatible; MSIE 6.0; Windows NT 5.1; .NET CLR 1.1.4322),gzip(gfe),gzip(gfe) Complaints-To: groups-abuse@google.com Injection-Info: j33g2000cwa.googlegroups.com; posting-host=192.85.50.1; posting-account=J7QqBQwAAABTieek3RP_669Gs2iATWzr Xref: dp-news.maxwell.syr.edu comp.databases.oracle.server:262701 These look more like OCP preparation type questions than interview questions. But assuming they are interview questions if you do not know the answers you should not be get the job because you are not qualified. If these are interview questions you can argue that the correct answer is not present on several of them such as in question 24. In order to successfully get the currval of a sequence you must issue a nextval first. So did all four attempt to get the current value of the sequence error off or work? If the attempts worked then 6 sequence values have been used and the correct answer is not present. If all 4 attempts failed then only 2 values have been used and the next value is present. Just assume the question is poorly constructed and take this value as the answer. IMHO -- Mark D Powell --