shipt interview questions and answers

amount of the month, Debitoccur: The amount of the occurrence.Database name: Jcyaudit, Data set: Select * from TestDBAnswer: Select A.*From TestDB A, (select Occmonth,max (debitoccur) debit101ccur from TestDB where accid= ' 101 ' GROUP by Occmonth) bwhere A.occmonth=b.occmonth and A.debitoccur>b.debit101ccur************************************************************************************Interview question: How to put such a tableYear Month amount1

Question one: What do you want the work environment to be like?Standard answer: I am not demanding on the environment, I will try to adapt to the environment.Note: This is a question of whether you are testing your job search mentality, whether you are centered on yourself or on the job.Question two: What shortcomings do you think you have?Standard answer: Say some of the small shortcomings of this position, or say that their "shortcomings" is no work experience.Note: This problem is very sinist

Unity3d interview questions (all), unity3d interview questions (all) I have summarized some Unity3d high-frequency interview questions, hoping to help you. Limited to individual levels, only some reference

"). Append ("World"). Append ("I love You"); This time S has more than one string to splice, it is supposed to be a number of objects generated, but the JVM will be an optimization, that is, only create an object, at this time it executes faster than the stringbuffer stitching. Look at this: String s2 = "Hello"; String s3 = "World"; String S4 = "I love You"; String S1 = s2 + s3 + S4; In this case, three more objects are created, resulting in a waste of memory space. J

drawing function.): 10. If the comparison operator is not used to calculate the Greater two numbers Principle of digital axis # Define max (a, B) (a) + (B) + abs (a)-(B)/2) 11. Shuffling Algorithm Solution 1 A. Define a 54-integer array poker [54] with a value of 1 ~ 54 B. generate two random numbers: m = rand () % 54 + 1, n = rand () % 54 + 1 C. Exchange the values of pocker [m] And pocker [n] D. Repeat B and c operations N times. The larger the N value, the larger the average value, but th

.equals (S2));Enter false because S2 is not of type string, and the Equals method of string is type-judged.3. What does the following code enter?"ABC"; String ("abc"); S2.intern (); System.out.println (S1 ==s2); The output False,intern () method returns a reference to the string object from the string pool, but since we have not assigned to S2,S2 no change, if the third line of code is S2 =S2.intern (), enter true.4. The following code will create several string objects.String ("Hello"); Stri

BAT and major Internet companies 2014 front-end written interview questions: Html/cssHTML article:1. Which of the Web pages do you test? What are the cores of these browsers? Ie:trident kernel Firefox:gecko kernel Safari:webkit kernel Opera: formerly the Presto kernel, opera has now switched to Google Chrome's blink kernel Chrome:blink (co-developed with Opera Software based on Webk

100 Interview Questions for Software Developers Hiring smart software developers is not easy.If you're not careful you might end up hiring a bunch of moronicMandrills, like I did last year. And you don't want that. Trust me.Stand-up meetings are very hard to do in a tree. The key is to askChallenging questionsThat enable you to distinguish the smart software developers fromMoronic mandrills. And to help yo

NULL5 8 NULLNULL NULL 9------------------------------------------1)Select a. department name Dname,b. Performance YJ as ' January ', c. Performance YJ as ' February ', d. performance YJ as ' March 'From table1 a,table2 b,table2 c,table2 DWhere a. DEP Department = B. DEP department and b. Month Mon = ' January ' andA. Department dep = c. DEP department and c. Month Mon = ' February ' andA. Department dep = D. Department DEP and d. Month Mon = ' March ' and2)Select A.DEP,SUM (case if B.mon=1 then

asks you to write an immutable object, or asks you why the string is immutable.15) What are the common problems you encounter in a multithreaded environment? How did you deal with it?Memory-interface, race conditions, deadlocks, live locks, and starvation are often encountered in multithreaded and concurrent programs. The problem is endless, and if you get it wrong, it will be hard to find and debug. This is most of the interview-based, not the actua

threadlocal, Blocking Queue, counting semaphore and concurrenthashmap are more prevalent. 15 Java Multi-threaded face questions and answers 1 Now there are T1, T2, T3 three threads, how do you ensure that T2 after T1 execution, T3 after the implementation of T2 execution? This threading problem is usually asked in the first round or during the phone interview

the interview-based, not the actual application-based Java threading problem.A few additional questions to add:1) What is the difference between a green thread and a local thread in Java?2) What is the difference between threads and processes?3) What is context switching in multi-threading?4) What is the difference between a deadlock and a live lock, the difference between a deadlock and a pie?5) What is t