Interview Questions - Revision history

Brianegge: /* C++ */

2010-05-17T21:12:32Z

C++

← Older revision		Revision as of 21:12, 17 May 2010
Line 15:		Line 15:
	== C++ ==		== C++ ==
	* Explain the difference between a macro and a template.		* Explain the difference between a macro and a template.
	* What is an initializer list? Why use them? When would you be required to use one?		* What is an initializer list? Why use them? When would you be required to use one? What order are variables initialized?
	* What~~'s the difference between an int and a long?~~
	* How would you determine the number of elements in a C array?
	* What's the difference between a reference and a pointer? Which one do you prefer to use?		* What's the difference between a reference and a pointer? Which one do you prefer to use?
			* How do you see what functions a dll or so is exporting?
			* How does a unix program determine where to find it's libraries when it is executed?

	== SQL ==		== SQL ==

Brianegge: /* Unix */

2009-07-08T03:16:59Z

Unix

@@ Line 44: / Line 44: @@
 * How do you check the return code of the last command which executed?
 * How can you tell the number of lines in a file?
-* If I chmod a file 644, what permissions will it have?
+* What do the following file permissions mean: 644, 400, 755?

Egge at 22:00, 1 November 2007

2007-11-01T22:00:45Z

← Older revision		Revision as of 22:00, 1 November 2007
Line 4:		Line 4:
	* Interesting blog postings		* Interesting blog postings

	I well prepared canidate as likely Googled me before the interview. In fact, you the reader of this page, may be one such canidate. Well to give you a little help, I'll give you some of the questions I'll probably be asking you. I've posted a subset fo the questions which I usually ask.		I well prepared canidate as likely Googled me before the interview. In fact, you the reader of this page, may be one such canidate. Well to give you a little help, I'll give you some of the questions I'll probably be asking you. I've posted a subset fo the questions which I usually ask. See also my [[Phone interview tips]]

	== Java Questions ==		== Java Questions ==

Brianegge at 19:02, 22 August 2006

2006-08-22T19:02:03Z

← Older revision		Revision as of 19:02, 22 August 2006
Line 27:		Line 27:
	* What is a composite primary key?		* What is a composite primary key?
	* How do you represent a many-to-many relationship?		* How do you represent a many-to-many relationship?

			== Network ==
			* How can you have one thread wait on multiple sockets?
			* Explain how multicast works.
			* What are the five elements which uniquely identify a socket?
			* What is the purpose of the TIME_WAIT state?
			* If a have an echo server on a local network, how many requests per second could a single client make, assuming it has to wait for the response before sending the next request.

			== Architecture ==
			* What is virtual memory?
			* What is the difference between virtual memory and virtual address space?
			* What is the difference between kernel and user address space? How much of each do you get on Windows, Solaris, Linux, etc..?
			* What is a memory mapped file? When might you use one?

			== Unix ==
			* How do you check the return code of the last command which executed?
			* How can you tell the number of lines in a file?
			* If I chmod a file 644, what permissions will it have?

Brianegge: /* SQL */

2006-08-22T18:50:57Z

SQL

← Older revision		Revision as of 18:50, 22 August 2006
Line 22:		Line 22:
	== SQL ==		== SQL ==
	* What is an inner / outer / self / theta join?		* What is an inner / outer / self / theta join?
			* Give me an example of a query with a HAVING clause.
			* If you have a time series table which contains the columns instrument, date, & price, what indexes would you create?
			* What is meant by the ACID model?
			* What is a composite primary key?
			* How do you represent a many-to-many relationship?

Brianegge at 22:32, 17 August 2006

2006-08-17T22:32:44Z

New page

As part of my job, I am regularly interviewing developers. Often, before a interview a canidate, I do a Google search for them. What I'm hoping to find is:
* Open source projects they've contributed to
* Technical postings they've written on messages boards
* Interesting blog postings

I well prepared canidate as likely Googled me before the interview. In fact, you the reader of this page, may be one such canidate. Well to give you a little help, I'll give you some of the questions I'll probably be asking you. I've posted a subset fo the questions which I usually ask.

== Java Questions ==
* What's the difference between .equals and ==. If you can't answer this, it's probably going to be a short interview.
* Can you put constants in an interface? If so, is this a good idea?
* Why do people say Java isn't a true object oriented language?
* What is a weak reference?
* In Java 1.4, how would you create a type safe enum?

== C++ ==
* Explain the difference between a macro and a template.
* What is an initializer list? Why use them? When would you be required to use one?
* What's the difference between an int and a long?
* How would you determine the number of elements in a C array?
* What's the difference between a reference and a pointer? Which one do you prefer to use?

== SQL ==
* What is an inner / outer / self / theta join?