Interviews Gone Wild: Basic Facts That I Forgot

On Thursday, I had an interview for an internship dealing with security and application development. This was my second interview with the company; the first being with HR, and this one dealing with determining my technical skill-level. They warned me multiple times that not knowing an answer was alright because this was simply to judge my level of knowledge in a few technical categories. To my own surprise, I had forgotten a few basic concepts about security, SQL, and networking. While I was able to show my knowledge on about half of the questions, others left me shocked that I couldn't remember basic concepts. Here are all of the questions (that I can remember). I'll leave the questions by themselves at the top and leave the answers at the bottom. Try to answer these yourself! If you're interested, I'll put my answers at the bottom.

QUESTIONS

1. How do you push out an image to multiple machines via a Windows Server?
2. How do you create and grant permissions to users in a Windows Server?
3. What is the difference between DNS and DHCP?
4. What is the difference between a Primary Key and a Foreign Key?
5. What is the difference between an INNER JOIN and OUTER JOIN?
6. What command would you use to view and edit an IP address?
7. What is the difference between a proxy, a firewall, and an IDS?
8. What are the three steps to a TCP handshake?

ANSWERS (Do not look here yet if you're trying these yourself)

1. Windows Deployment Services
2. Active Directory
3. DHCP (Dynamic Host Configuration Protocol) automatically assigns IP addresses to computers. DNS (Domain Name Service) converts a URL string like www.google.com to it's IP address.
4. A primary key is a column that identifies each record in a table. A foreign key is a primary key from another table that links the two tables together.
5. INNER JOINs only output the set of records that match in each table, while an outer join will include all records, but the missing matches will contain null values.
6. a. View your ip by typing in ipconfig on the command prompt. b. The change your IP address, go to Control Panel > View Netowrk Connections > right-click your network > Properties > IPv4 OR IPv6 > Properties > Click "Use the following IP address:" and fill in your own IP.
7. A proxy acts as a middle-man to allow or deny access to resources. A firewall rejects packets with headers that do not match the protocol of a given port. An IDS rejects or sends alerts for packets based on user-determined rules.
8. A sends a synchronization (SYN) packet to B. B sends a synchronization-acknowledgement (SYN-ACK) packet to A. A sends an acknowledgement (ACK) packet to B.

MY ANSWERS

1. Unknown
2. Correct
3. Forgot
4. Correct
5. Forgot
6. Correct for view; forgot how to change
7. Correct (minus a few details)
8. Forgot

Really, I should have known almost all of these. I've never done system administration before, so I didn't know about WDS, but I have definitely learned the rest of this information while I was in school and was pretty disappointed in myself when I was unable to answer all of these questions. Now that I've taken the time to pull these back into my memory, hopefully I'll never forget them again! If anybody has better/alternate answers to these questions, leave a comment below!