> Q: In what version of Oracle did the cursor sharing feature become > available? 7.3, 8.0, or 8.1?
Q: In what version of Oracle did the 'cursor sharing' feature stopped producing ORA-0600? Igor Neyman, OCP DBA [EMAIL PROTECTED] ----- Original Message ----- To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]> Sent: Friday, December 07, 2001 9:20 AM > Hello DBAs, > > I'm having a company holiday party today, and as you all may know my company > employs mostly DBAs. (Pythian is an Oracle DBA Outsourcing shop.) > > I'm thinking of having a "DBA Weakest Link" game for fun at some point of > the evening. Yes, I know, the partners/husbands/wives will think it's a bit > of a bore, but imagine the fun for us DBAs! :-) > > So what I'm trying to do is get many, many weakest link-style questions > (with answers) ready. I want them mostly to be easy, but with the odd hard > one snuck in for unfairness. Please help out by submitting your questions, > and I'll summarize and post the complete list back to the list when I'm > done! > > Sound like fun? I'll get us started with a format. > > Q: Name the Oracle error for "Table or view does not exist"? > A: Ora-00942, 942 > > Q: Which of the following return a value? Procedure, Function, Package, > Index? > A: Function > > Q: In what version of Oracle did the cursor sharing feature become > available? 7.3, 8.0, or 8.1? > A: 8.1 > > Q: In Oracle, the function that averages values is called: Average, or AVG? > A: AVG. > > Q: The structure Oracle uses to protect a region from memory from concurrent > access is called: Lock, Latch, or Library Catch? > Q: Latch > > Q: Larger block sizes make more efficient use of the buffer cache, or less > efficient? > A: Less efficient. > > I'd like to get at least a hundred ready for the game, preferably more. > Thanks for your help! > > Paul > --- > www.pythian.com -- [EMAIL PROTECTED] -- 877-PYTHIAN > Smarter than adding another team member, Pythian has new services for > supplementing DBAs: get our help with monitoring, 24x7 on-call, daily > verifications, storage management, performance and more. > > > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.com > -- > Author: Paul Vallee > INET: [EMAIL PROTECTED] > > Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051 > San Diego, California -- Public Internet access / Mailing Lists > -------------------------------------------------------------------- > 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.com -- Author: Igor Neyman INET: [EMAIL PROTECTED] Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051 San Diego, California -- Public Internet access / Mailing Lists -------------------------------------------------------------------- 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).
