How do companies evaluate AMCAT score to select candidate for direct interview? Do they evaluate the total percentile or do they prefer sectional cut off?
Honestly speaking it has a lot to do with scores and nearly nothing with percentile. I came to this conclusion after variety of research. This post is useful for:1) Those who think why they don't get calls or what criteria is set so that they will get a call.From here starts know-hows:1) http://talentsearch.amcat.com/ is where employers login to short list candidates.2) If a company has to search candidates for "Software development Trainee" AMCAT gives them some recommended cut-off (Your sectional scores to be precise)And this is the screenshot of a sample AMCAT score:Here's the screenshot of what employer finds on his screen:Now, something really interesting about AMCAT's recommendation whether the score is good, average or bad.Categorization based on your score:English ->455-520(average score), 520+(excellent score)Logical ->455-520(average score), 510+(excellent score)Quant ->445-520(average score) , 550+(excellent score)Computer Programming -> 350 and above is average scoreAgain, Refer to the Employer login screenshot to understand about various color codes used (Light green, Green, Red).Fields marked with: 1) Light green is average2) Pure green is excellent3) Red is worstCompany people selects whoever they think meets their Job profile and sends them an e-mail or SMS.So, bottom line is Score are much more important than percentile. P.S: This was an experiment done among us, we had same question from long time. In no way, I am trying to reveal any confidential information. If there is any issue, please report I will remove!All the best!
How do I find the first, second, and third largest marks obtained for a particular subject in mySQL?
This answer applies to MySQLIt can happen that three students have the highest marks (lets assume 100) and four other students have marks 60,70,80 and 90 respectively. In such a case, a query like:SELECT * FROM `student` WHERE subject='Science' ORDER BY marks DESC LIMIT 0,3will return you three rows, all being 100. If however, you need top three distinct marks you should add a GROUP BY clause.SELECT * FROM `student` WHERE subject='Science' GROUP BY marks ORDER BY marks DESC LIMIT 0,3This will return three rows of the students, with top three distinct marks. Please note that the other information (maybe id, name etc) will correspond to the first student having such marks, as returned by the query.If you only want the second highest marks along with the first student who has such marks, you can change the LIMIT clause to LIMIT 1,1. For the third highest marks change limit to LIMIT 2,1.In LIMIT x,y x is the offset and y is the limit. LIMIT 2,1 means return y(1) rows from an offset of x(2). So this offset will skip the two results and return you one row.
How can you write a query to display the name of the students whose total marks is divisible by 25 (total marks may be 175, 200, 150…)?
If you want to get instant success in the Cisco 200-150 Exam. I highly recommend DumpsOfficial actual Cisco 200-150 exam study material. That is relevant to Cisco actual exam. After using DumpsOfficial actual 200-150 exam questions and answers you will accept that it take you a step closer to the success. They have 100% money-back guarantee. Their payment refund procedure is very simple. Just require enrollment slip of 200-150 Exam, score report and the order number of product.You can download Cisco 200-150 training material from 100% Pass Guarantee on 200-150 Exam and pass the Cisco 200-150 exam in the first attemptand the CCNA Data Center 200-150 exam preparation kit contains all the necessary 200-150 questions that you need to know.Good Luck to you!
While updating my PAN card details against my UAN, an error shows as "Name against UAN does not match with the name in the Income Tax Department". How can I resolve this?
Solution is that… you can correct your name in EPFO record as per PAN. Because of that EPFO record easily change instead of Income tax.Solutions:-Login Epfindia site under employee login through UAN and update your profile as per PAN. After that try to attached PAN with UAN.I hope you will be find your solution. If not let me personally message.Regards
What are the advantages / disadvantages of using Visual FoxPro over a more modern language (like Java)?
Advantages:(1) Visual FoxPro is a dynamic language (While Java uses Static Typing)So Visual FoxPro is more suitable for prototyping, rapid development and getting things done quickly in little code (Easy to write & Easy to run)But Java is more suitable for large projects written by large teams, Where the compiler will help you to find more bugs in early stages.(3) Focus : Most of Visual FoxPro developers focus only on (Database Applications, Windows Platform, Porting Legacy Application ) - So when you get a job as a Visual FoxPro developer, You know exactly what you will do, But in Java world (There are many domains!)VFP is a fourth generation programming language (4GL)(4) All of the important tools in one package (Database, IDE, Report Designer, Class Designer, etc).(5) Nice Wizards to quickly start an application(6) Interactive development through the command window (Like REPL in scripting languages)(7) Visual FoxPro is here with all of these features before JavaSo Visual FoxPro presented real Object-Oriented Programming language + GUI for database development in 1993 ! (Visual FoxPro 3.0)Disadvantages(1) Just for Windows!(2) The GUI is not modern(3) Support web development (but not designed for that)(4) No support for Mobile Development(5) No more version, and no more support from MicrosoftWant to see a project developed using Visual FoxProSee : Programming Without Coding Technology : PWCTSince VFP is dead, I created the Ring programming language (http://ring-lang.net) to use for rewriting the project.So if you are a Visual FoxPro fan and would like to see something else that share a lot with Visual FoxPro, there are many choices but I recommendedThe Harbour programming languageHarbour