ࡱ> EODmM X.bjbj== vWW)l<<<8<$=_>(8>L>>>>:?<v? ~~~~~~~$ /d?>>??L>>LLL? >>~L?~LLQ^yX"}>> M8<E*z("}/0_zDL"}L EMBED Word.Picture.8  Database Group Screening Examination Self Assessment Please rate your aptitude in the following areas using this scale: 0 never heard of it 1-6 somewhat proficient 7 proficient 8 very proficient 9 one of industry leaders 10 the industry authority Language or TechnologySelf-RatingC ProgrammingC++ ProgrammingUNIX Scripting (sh, awk, etc.)SQL ProgrammingBuilding and Debugging on UNIXBuilding and Debugging on Win32Is there a favorite language that you would like to call attention to: Over the past 5 years, please estimate the percentage of time you have spent: Writing & Debugging Your CodeDebugging Other Peoples CodeProject ManagementMentoring and People ManagementTesting, QA, Configuration MgmtTech Support, Pre/Post Sales SupportNon-technical Tasks100% Please exchange this page for your examination booklet.  EMBED Word.Picture.8  Database Group Screening Examination You will have approximately one hour to complete this examination but will most likely need much less time. Please feel free to ask for coffee or refreshments or to use the facilities. We would prefer that you do not make telephone calls or consult reference materials during the exam. Thank you for your interest in Concord. We look forward to speaking with you in a more personal way soon. C Programming Problem One Using the space below, please complete a C program (which we will compile and link as foo) that prints out the command line arguments so that they look like this (or as close as possible) : % foo one 2 III four arg : 001 = one arg : 002 = 2 arg : 003 = III arg : 004 = four Your code: int main (int argc, char* argv[]) ( ) /* main */ Problem Two Consider this C function: char* getHostname () { char hostname[100+1]]; *hostname = 0; FILE* pipe = popen (/bin/hostname); if (!pipe) return (hostname); // ( on error, return if (!fgets (hostname, 100, pipe)) return (hostname); // ( on error, return pclose (pipe); return (hostname); } /* getHostname */ Q1. Very briefly, describe your analysis of whats wrong with it: Q2. Your solution to this problem (mark up the code): char* getHostname () { char hostname[100+1]]; *hostname = 0; FILE* pipe = popen (/bin/hostname); if (!pipe) return (hostname); // ( on error, return if (!fgets (hostname, 100, pipe)) return (hostname); // ( on error, return pclose (pipe); return (hostname); } /* getHostname */ Q3. An alternate solution to this problem (mark up the code): char* getHostname () { char hostname[100+1]]; *hostname = 0; FILE* pipe = popen (/bin/hostname); if (!pipe) return (hostname); // ( on error, return if (!fgets (hostname, 100, pipe)) return (hostname); // ( on error, return pclose (pipe); return (hostname); } /* getHostname */ Problem Three The following piece of code works fine. Our product (which embodies this code) has passed all its functional tests and is ready for release. int add2array (int* IntArray, int iNumElements, int iNewElement) { // make memory for new array: int* NewArray = (int*) malloc ((iNumElements+1) * sizeof(int)); // copy old elements into new array: for (int ii=0; ii/dev/null | sort (just constrast this to Q1) Q3. myprog 2>&1 | sort (just constrast this to Q1 or Q2) Problem Three Simply show the output from these Bourne Shell code fragments. Be as precise as possible. Q1. echo My name is Fred Flintstone and I like rocks. \ | sed e s/e/a/g \ | awk {print $4, $5} Q2. echo Rocks rock! | /bin/tr [a-z] [A-Z] General Oracle Knowledge Q1. In order to connect to an Oracle database on the local machine using SQL*Plus, two environment variables need to be set. Please name those two variables: Q2. Where does the SQL*Plus utility live (in a normal Oracle installation) and what exactly is it called? Q3. Where does Oracles INIT.ORA file live and what exactly is it called (show the naming convention using environment variables). Q4. Circle the INIT.ORA parameter below that (in your opinion) has the greatest impact on the Oracle SGA (system global memory): db_block_buffers db_domain db_files db_name global_names instance_name job_queue_processes log_checkpoint_timeout max_dump_file_size service_names Q5. If the default tablespace for the current Oracle user has not been set and the following CREATE TABLE statement is issued, what tablespace does this table get created in: create table FRED as select * from DUAL; General Oracle Knowledge, cont. Q6. If I want to enable Oracle networking (formerly called SQL*Net) on a local database so that people on other machines can connect remotely to that database, which of the following files would I need to configure? (circle one) tnsnames.ora listener.ora init.ora oratab the control files Q7. After configuring the appropriate files, which Oracle utility (or utilities) could I use to turn on the networking? (circle all that apply) NONE (editing the config file will enable networking when you save the file) cmctl dbsnmp lsnrctl namesctl oratclsh sqlplus svrmgrl tnsping trcroute Q8. What does OCI stand for? General Oracle Knowledge, cont. Q9. Can you recognize the key library required by all Oracle Pro*C and OCI programs at runtime: (circle one) libJNLSTool.so libagtsh.so libclntsh.so libctx.so libldapclnt.so libsvrmgrl.so libnhost.so libwwg.so libcommon.so Q10. If you want to ensure that an Oracle Pro*C or OCI program can find the runtime library that you circled in Q9, which environment variable (on Sun/Solaris) must be altered to include Oracles lib directory: (circle one) $AOUT_PATH $DLL_PATH $LD_LIBRARY_PATH $LIB $LIBPATH $OBJPATH $PATH $SO_PATH  HYPERLINK "/"  INCLUDEPICTURE "http://www.concord.com/images/logo.gif" \* MERGEFORMATINET   INCLUDEPICTURE "http://www.concord.com/images/tagline.gif" \* MERGEFORMATINET  Page -  PAGE 14 -CUV*+O-/57\abES X # = >   m n r v w XYZ89 jCJmHnHuCJ jCJmHnHuCJ5\ jUCJ 5CJ\6]CJ 6CJ$]CJ0j/ A UV jUG-CDEUV *+BN (($If  ^ ^$$d&dNPa$$a$-W.NO]^_opq@HH (($Ifp$$Ifl0L064 la.  (($Ifp$$Ifl0L064 la./012 * p$$Ifl0L064 la (($IfZ$$Ifl064 la234567v $(($Ifa$p$$Ifl0L064 la (($If xTxxx $(($Ifa$ (($Ifp$$Ifl0L064 la DEFZ[\axXxp$$Ifl0L064 la $(($Ifa$ (($Ifabc$$d&dNPa$$a$]$$Ifl06L4 la  y z | } ~ X Y n  !           " # = > S U }  2 3 C D X Y m  !m n  * Q ] YZoqNO_`tu+,-np)- sw $in)45<`bwxy gj=acj ~"'6;LMOYf 5CJ\6]CJ>*CJOJQJ^JCJ5\Y>?X   klmnopqrs*89`cdeffghi*+,-./0`abdefgwxy (Jj !#Lfg<=c}~LM./Sr Fm  & F^^f./S -/6cdhil  > ? [ \ ! !!!&!*!c!g!!!!!! """#"'"M"g"v"x"###8#<#[#v#}####4$8$$$%%% %%%&"&6CJOJQJ]^J5CJOJQJ\^JCJ>*CJ 5CJ\6]5\Sm /Jdefghi % ? @ A B C E F G H [ \ \ h i !!!!!!$!%!&!5!N![!^!_!`!a!b!c!r!!! ^``^!!!!!!!! """" "!"""#"2"i"y"}"~"""""""" ^``"""###3#4#5#6#7#8#w#x#y#z#{#|#}##########2$3$3$4$o$$$$$$$$$$$$$$$$$$$$$$$$$$% !%%%%%%%%%%&&&&&&&&&&&&&&&+','='G' & F"&&&''(())**%+(+p+r+++V,Z,-------------->.?.@.A.I.J.P.Q.S.T.X.ڻ0JmHnHu0J j0JU j U"j~B*CJOJQJUaJphB*CJOJQJaJph"jB*CJOJQJUaJph jU>*CJOJQJ^J5\+G'P'X'e's'''''''''t(u((((((((((((() & F ! & F)))))))))))********+ +++"+#+$+%+F+ & F  & F & F F+G+H+I+K+L+M+m+n+o+p+++++ ,,#,1,=,G,T,U,V,+-8-9-:- & F & F !:-E-O-`-e-n-w-}-------U.V.W.X. $ ! & F/ =!"#h$%DdJ  C A? "2!r-8[2G0D`!r-8[2G0& 20@xڍR=OA}>ߝ/#i0h-Qɦ)) U"D} qEi(+R$ m P'9 sݙy3soV d> KhYn求^6P JY?:Ck3,N?!,Qz^GA8>'A'%GIڅл oWŗWr4_p'RqO9}h8`蔅:XYYR6;꒻-J'&lqKuL|^u$+C >2bnv'ٟrijn^y6{Uzߍ x*ǾێԑzU4*BѪH2}U*(^ d"!;tj@Rt^ dt7SX 1Ūi^ⷘ%cKp$~Zg`' /q̿DdJ  C A? "2!r-8[2G0`!r-8[2G0& 20@xڍR=OA}>ߝ/#i0h-Qɦ)) U"D} qEi(+R$ m P'9 sݙy3soV d> KhYn求^6P JY?:Ck3,N?!,Qz^GA8>'A'%GIڅл oWŗWr4_p'RqO9}h8`蔅:XYYR6;꒻-J'&lqKuL|^u$+C >2bnv'ٟrijn^y6{Uzߍ x*ǾێԑzU4*BѪH2}U*(^ d"!;tj@Rt^ dt7SX 1Ūi^ⷘ%cKp$~Zg`' /qrDdY  s AN0http://www.concord.com/images/logo.gifConcordyK yK /bBA+N5jnA+N5jPNG  IHDR0PLTEٴɞvhyXk?U}+Cm!tRNS@fbKGDHgIFg>U cmPPJCmp0712OmNIDAT8͔kAn~5ЦErYrIR\"BEs-ں%Ro$RRƽ(D_ffc=7oyyo6Dkz-/ix5=ϻ*m+y>+-P9,QL)DY[T7u@roA{M米~fe,/)XOsj1n,)L'y^Y(&,hZn;^s: K!y =G^uWR݌{+~700ˇf^dQ)ݎIgurZ.A\e5>RtMNg<{Жk8a/l9 mZo8HrK=`G~ NH{Ib>S_+`?8IUuFIENDB`Dd   S tAThttp://www.concord.com/images/tagline.gifbkYEDYaU s4 nkYEDYaU sPNG  IHDRm``PLTEYY@@p⿿MMyssffٙ33fobKGDH cmPPJCmp0712HsIDATHKV펣0 'BLn][UgJ3׬_ţZw<|~OS}ؿq^$.[ ^>p)n50Ej[8T$TVmsZqj[*b4.bxo ZlRcpdӐ'91[z"9dcCNGb 16kS |h]Z6~[L\fRj; 8| fP)FPO1I>qȍ;f!]Lc!jDFu=Š0z qA*B*<Xv 1f#-kw]LYYp@A.kHmj%;{MTR+fA94b\ȯTs!FV4>I1C"܍3LQ[YQMWS !>`Z5sDLlAɹ$mXmKtq%dn>2b"u8}n `:fF-ot6S3BGSkq&%hAq(x?L*ZnCF Xup,>l$W?@ABCFQHIJKLMNkjSTUVWXY[\]^_`acdefghilopqrstuvwxyz{|}~Root Entry  FMPData <WordDocument vObjectPoolMM_1091424559 FM`GM1TableGCompObjhObjInfo i0@0 Normal_HmH sH tH <A@< Default Paragraph Font-3-03  @V304003328@(  H  #  (  B S  ?3jt t44@h x 3@UnknownGz Times New Roman5Symbol3& z Arial"h*hf+hf!~02Joseph KueflerJoseph Kuefler   FMicrosoft Word Picture MSWordDocWord.Picture.89qOh+'0   < H T `lt| ssJoseph Kuefleroseose Normal.dotlJoseph KueflObjectPool `GM`GMWordDocumentRSummaryInformation( ZDocumentSummaryInformation8bM 3bjbj==  WW.l$jjjj v $)))IKKKKKK$ bo)@)))oI[III)8II)IIIII QI$Fj9II0IIII Candidate, please print your initials here: /3CJjUmHnHu01232N N!"$#$ /%Oh+'0x  4 @ LX`hpssJoseph Kuefleroseose Normal.dotlJoseph Kuefler2seMicrosoft Word 9.0@F#@x$I@"@> Heading 1$ & F@& 5CJ$\>@> Heading 2$ & F@& 6CJ$]V@V Heading 3$ & F<@&5CJOJQJ\^JaJJ@J Heading 4$ & F<@&5CJ\aJL@L Heading 5 & F<@&56CJ\]aJF@F Heading 6 & F<@&5CJ\aJ@@@ Heading 7 & F<@&CJaJF@F Heading 8 & F<@&6CJ]aJL @L Heading 9 & F<@&CJOJQJ^JaJ<A@< Default Paragraph Font,@, Header  !, @, Footer  !&)@& Page Number$O2$ Body ^4oB4 Code ^CJOJQJ^JX*$v-CDEUV *+BNO]^_opq./01234567DEFZ[\abc     yz|}~XYn"#=>SU}23CDXYmn  * Q ]     Y Z o q  N O _ ` t u + , - n p  > ? X     klmnopqrs*89`cdefghi*+,-./0`abdefgwxy (Jj#Lfg<=c}~LM./Sr Fm /Jdefghi %?@ABCEFGH[\hi$%&5N[^_`abcr  !"#2iy}~345678wxyz{|}2 3 4 o !!!!!!!!!!"""""""""""""""+#,#=#G#P#X#e#s#########t$u$$$$$$$$$$$$$%%%%%%%%%%%&&&&&&&&' '''"'#'$'%'F'G'H'I'K'L'M'm'n'o'p''''' ((#(1(=(G(T(U(V(+)8)9):)E)O)`)e)n)w)})))))))U*Y*0000000 00E0E0E0E0E0E0E0E0E0E0E0E0E0E0E0E0E0E0E0E0E0E0E0E0E0E0E0E0E0E0E0E0E0E0E0E0E0E0E0E0E0E0E0E0E0E0E0E0E0E0E0E0E0E0E0E0E0E0E0E0E0E0E0E0E0E0E0E0E0E0E0E0E0E0E0E0E0E0E0E0E0E0E0E0E0E0E0E0E0E0E0E0E 00~ 0~~000000000000000000000000000000000000000000000000 0~~000000000000000000000000000000000000000000000000000000000000000 0~~0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 @0 @0 0 0  0~~000000000000000000000@00@000000 0000000000000000000000000000000000000000 00g0g0g0g0g0g0g0g0g0g0g0g0g0g0g0g0g0g0g0g0g0g0g0g0g0g0g0g0g0g0g0g0g0g0g0g0g0g0g0g0g0g0g0g0g0g0g0g0g0g0g0g0000000000000000000000000000000000000000 00H 0HH0\0\0\0\0\0\0\0\@0\0\0\0\0\0\0\0\0\@0\@0\@0\@0\@0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\ 0HH@000000000000000000000000 0HH@000000000000000000000@000000000 0@0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 @0 @0 @0 0 0  0  0  0  0  0  0  0  0  0  0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 00$0$0$0$0$ 0$ 0$ 0$ 0$ 0$0$0$0$0$0$0$0$ 0$ 0$ 0$ 0$ 0$ 0$ 0$ 0$ 0$ 0$0$0$0$0$0$0$0$0$@0$@0$@0@0I'@0I'0I'00I' 0I' 0I' 0I' 0I' 0I' 0I' 0I' 0I' 0I'0I'0I'00I'0I'0I' 0I' 0I' 0I' 0I' 0I' 0I' 0I' 0I'0I'0I'0I'0@0@0 0f"&X.(/6N.2a m fm\ !"3$%G')F+:-X. !"#$%&')*+,-.012345789:W.X*::_abdXtCtCt!t _1091423918 _1091423982 _1091424522 _Hlt17683119 _Hlt17683120 _Hlt17683129 _Hlt17683150))))Y*@@@@@@@))))Y*[^nqDO4:^i8 =  ` k   P V z A I O [ a l  ! ) 0 8 Y a b n r }  >B (1jq<CDMSZr{ 'FN6>?I$+/;?[]hly} (,9=bfz|%+>Dajs v ,#<#=#F#G#O#P#W#X#d#e#r#s##########I$S$%%%%%%%%&&&&&&&&&''''!'''''' ( ((("(#(0(1(<(=(F(G(S((()V*Y*TW[^nq >BVZ 4:EK^i  R T _ e  Z ^ r v ! ' P V a g z - 0 t x ! * C F Y b !+.:=  (,JN#(=A~'SWrv $FImr  69 +/57NR[]hlrt (,24imz|%+>D9 = s v ,#.#=#?#G#I#P#R#X#^#e#m#s#v#######p$s$v$|$%%%%%%%%%%%%t&z&&&&&&&&&&''' '''''!'''''''' ( ((("(#(0(1(<(=(F(G(S(\(*),)2))V*Y*333333333333333333333333333333333333333333333333333333333333333333333333333333333333333333333333333333333333333333333333333333333333333333333333333333Joseph Kuefler!U:\jkuefler\doc\CandidateExam.docJoseph Kuefler!U:\jkuefler\doc\CandidateExam.docJoseph Kuefler!U:\jkuefler\doc\CandidateExam.docJoseph Kuefler!U:\jkuefler\doc\CandidateExam.docJoseph Kuefler!U:\jkuefler\doc\CandidateExam.docJoseph Kuefler!U:\jkuefler\doc\CandidateExam.docJoseph KuefleraC:\WINNT\Profiles\jkuefler\Application Data\Microsoft\Word\AutoRecovery save of CandidateExam.asdJoseph KuefleraC:\WINNT\Profiles\jkuefler\Application Data\Microsoft\Word\AutoRecovery save of CandidateExam.asdJoseph Kuefler!U:\jkuefler\doc\CandidateExam.docJoseph Kuefler!U:\jkuefler\doc\CandidateExam.docH5 HLD-}iZnE,$'  ::3F<**5$ZQǾcGZ4*)|d;0Dig CVjbj1YjҲVYnpN8es`)s(xx2wlpp^p`o(@ @ ^@ `.L^`L.^`.^`.L^`L.PP^P`.  ^ `.L^`L.h ^`OJQJo(h pp^p`OJQJo(oh @ @ ^@ `OJQJo(h ^`OJQJo(h ^`OJQJo(oh ^`OJQJo(h ^`OJQJo(h PP^P`OJQJo(oh   ^ `OJQJo(808^8`0o(^`.pLp^p`L.@ @ ^@ `.^`.L^`L.^`.^`.PLP^P`L.h^`.8^`.^`.p ^p`)@  ^@ `()x^`()H^`()^`()^`()h ^`OJQJo(h pp^p`OJQJo(oh @ @ ^@ `OJQJo(h ^`OJQJo(h ^`OJQJo(oh ^`OJQJo(h ^`OJQJo(h PP^P`OJQJo(oh   ^ `OJQJo(h ^`OJQJo(h pp^p`OJQJo(oh @ @ ^@ `OJQJo(h ^`OJQJo(h ^`OJQJo(oh ^`OJQJo(h ^`OJQJo(h PP^P`OJQJo(oh   ^ `OJQJo(^`o(^`.pLp^p`L.@ @ ^@ `.^`.L^`L.^`.^`.PLP^P`L.^`o(^`.pLp^p`L.@ @ ^@ `.^`.L^`L.^`.^`.PLP^P`L.h ^`OJQJo(h pp^p`OJQJo(oh @ @ ^@ `OJQJo(h ^`OJQJo(h ^`OJQJo(oh ^`OJQJo(h ^`OJQJo(h PP^P`OJQJo(oh   ^ `OJQJo(pp^p`o(@ @ ^@ `.L^`L.^`.^`.L^`L.PP^P`.  ^ `.L^`L.h ^`OJQJo(h pp^p`OJQJo(oh @ @ ^@ `OJQJo(h ^`OJQJo(h ^`OJQJo(oh ^`OJQJo(h ^`OJQJo(h PP^P`OJQJo(oh   ^ `OJQJo(bb^b`o(2 2 ^2 `. L ^ `L.^`.^`.rLr^r`L.BB^B`.^`.L^`L.^`o(^`o(-33^3`o(-.V"V"^V"`o(-.. y,y,^y,`o( -... 66^6`o( -....  A A^ A`o( -..... L`L^L``o(-...... V`V^V``o(-.......h ^`OJQJo(h pp^p`OJQJo(oh @ @ ^@ `OJQJo(h ^`OJQJo(h ^`OJQJo(oh ^`OJQJo(h ^`OJQJo(h PP^P`OJQJo(oh   ^ `OJQJo(h ^`OJQJo(h pp^p`OJQJo(oh @ @ ^@ `OJQJo(h ^`OJQJo(h ^`OJQJo(oh ^`OJQJo(h ^`OJQJo(h PP^P`OJQJo(oh   ^ `OJQJo(^`o(^`.pLp^p`L.@ @ ^@ `.^`.L^`L.^`.^`.PLP^P`L.h ^`OJQJo(h pp^p`OJQJo(oh @ @ ^@ `OJQJo(h ^`OJQJo(h ^`OJQJo(oh ^`OJQJo(h ^`OJQJo(h PP^P`OJQJo(oh   ^ `OJQJo(}i)s$ZQGZ,$*51YjH5 DigVYn)|dCVjxx2wL8es::3pnhe                 '|X                          Vb        ZX                 9                                           WB                 +BNO]^_opq./012345DEFZ[\abY*@((|.(?(X*@@UnknownGz Times New Roman5Symbol3& z Arial;WingdingsE5  Lucida Console?5 z Courier New7&  Verdana"1hhfhFhF!@"I$0d* 2Q Joseph KueflerJoseph Kuefler