job-interview

What are the disadvantage of SQL views?

Recently I faced an interview and I was asked the above question. I was dumb when I think about it. Interviewer said: All people are saying views have lots of advantages but I find no disadvantages, why so? EDIT Based on the answers of all experts, I think I can summarize it: When table is dropped or modified, view become...

Interviewing for freelance android job

I have a meeting with a newspaper to discuss working on an android app for a non-profit event that is held at my university (I'm a graduate) every year. They have an iphone app and are looking to have an android app made too. My friend who works on a committee brought my name up when they were asking about the app. I'm very capable with...

What are the benefits of using database cursor?

It is based on the interview question that I faced. Very short definition can be It can be used to manipulate the rows returned by a query. Besides the use of the cursor (Points are listed here on MSDN), I have a question in my mind that if we can perform all the operations using query or stored procedure (if I'm not wrong, Like...

Is this a good interview questions to be asked in interview for a software tester?

Hi, I normally ask this question in a interview for tester. Our software is really complex, has GUI and backend component. We require the tester to be good in analytical and can think out of the box. In this context, is the following question good to be asked or is it too complex/bad/ugly? Also our requirement is that the tester should b...

how would you describe yourself as a good programmer?

This is a subjective question and I know it might be closed, however as there are many good programmers here. I would like to ask you fellow out there, if you were to describe yourself to a potential employers in one sentence/in an elevator pitch, what would be a good catch phrase/hook/interesting point that would attract them to let the...

How to print out "Hello World!" ?

It's kinda interesting question. Please prints out "Hello World!", but you have to do this in the following code pattern: if(/**you may add your code here**/){ System.out.print("Hello "); }else{ System.out.println("world!"); } this is a Java version, you can also implement it i...

Algorithm Interview Question

Hi all: I went to an interview today and here is the question: Suppose you have got 1 billion integers which are unsorted at one disk file,please find out the largest 100 numbers,try the best solution as you can. Anybody who has ideas,please do share! Thanks in advance! ...

Another Algorithm Job-Interview Question

Hi all: So here is the question: Suppose you have got 100 thousands integers which ranges from 1 to 1 million,please sort out the integers and its time complexity should be O(n) Anybody who shares his or her ideas is well appreciated. Thanks in advance! ...

Find an array inside another larger array

Hi All, I was recently asked to write 3 test programs for a job. They would be written using just core Java API's and any test framework of my choice. Unit tests should be implemented where appropriate. Although I haven't received any feedback at all, I suppose they didn't like my solutions (otherwise I would have heard from them), so ...

Interview question to ask on knowledge of multi-threading

Someone said 90% of programmers cannot solve a binary search. So for a guy who claimed he has in depth understanding on multi-threading technology, what is the basic but ideal question to ask? It can be either C++ or Java. ...

How to sort millions of rows of data in a file with less/meagre memory

(From here) I attended an interview last week and this question was asked: How do you sort a billion rows of data in a file with only 640KB of memory in a 8080 processor based machine? No virtual memory, no external disk. I explicitly asked the interviewer if I could use a hard drive, so I can serialize trees as I sort them and then c...

Go to Booz Allen Hamilton or stay with Lockheed?

I have a secure offer from Booz Allen Hamilton for a cybersecurity developer position that looks to be pretty interesting work. The BAH offer only pays a few hundred more than my current job at Lockheed Martin, but has a sizable clearance upgrade from my current clearance level. I have about three years of served time with LM though and ...

What are some must-knows for C#?

I just got offered a job interview with short notice. Tomorrow morning I'm interviewing for a positions which has C# as a required proficiency. The position is a co-op position and I'm fairly certain the company understands that incomming students will probably have very limited, if any, experience in C# especially because the local coll...

How to find all words that have the same appearence in two different languages?

The russian alphabet includes many letters that are the same in the English alphabet. Here is the list of common letters: L='acekopuxy' Now, given two huge lists R and E, each in the form [word_A, word_B, ...], where each word_N is a lowercase word, I want to create a list C, which should contain only those words that have the same sp...

Refactoring JavaScript and PHP code [Job Interview]

Hi, recently I had a job interview. I had two tasks: 1) to refactor a JavaScript code // The library 'jsUtil' has a public function that compares 2 arrays, returning true if // they're the same. Refactor it so it's more robust, performs better and is easier to maintain. /** @name jsUtil.arraysSame @description Compares 2 arrays, re...

updating hyperlinks to the text in a paragraph:interview question

One Interview question i was asked in an interview and i was not get an solution. Following is the sample paragraph and our program should give the hyperlinks for the words which mathes "Network protocol Driver- A net-protocol fully Java technology-enabled driver translates JDBC API calls into a DBMS-independent net protocol which is t...