Friday, December 23, 2011

Puzzle questions series

Operating Systems:

1) How many server operating system installations have you completed on your own?  How many machines have you built?
2) Have you ever written an OS build doc for other people to follow?
3) Where do operating systems record errors and informational messages?
4) What is an environment variable ? How would you display one?
5) Explain the significance of a path environment variable?
6) What is an ACL?  How would you display or change one?
7) What is a PID number?  How would you display one?
8) Which applications do you use to view a 2GB log file?
9) What are some common tools to parse text or locate a word of phrase in a file or data stream?
10) How would you register or un-register a DLL and why would you do this?
11) What is your preferred file compression tool ?
12) Name a Windows Resource Kit or Support Tools utility and describe how you used it to solve a problem.
13) Describe a shell script of batch file that you've written.
14) How do you redirect the results of a command to a file?  How do you redirect it to be processed by another command?  What are a program's three IO streams called?
15) Describe an administration, troubleshooting or utility script in a non-shell, non-compiled language that you have written?
16) What is the boot.ini/3GB switch?
17) What's the difference between working set, private bytes and virtual bytes?
18) How do you identify and troubleshoot memory leaks in Windows?

SQL and relational database management systems:

1) What is the standard SQL command to query data in a table or view ?
2) What are some common clauses in a SQL SELECT statement?
3) How would you use a subquery in a select statement ?
4) What is the SQL Command to change the values of one or more columns in a table row?
5) Give an example of using an aggregate function in a select statement.
6) What is a stored procedure that executes automatically based on changes to the database?
7) What are the native tools to query databases using Oracle and SQL Server 2000 ?  Which other ones have you used?
8) What is the command in SQL*Plus to make it write the results of its console to a file?  What is the operator character to tell it to open and SQL file and execute its contents?
9) What are some ways to export and import or backup and restore databases in Oracle and SQL Server?
10) How do Oracle and SQL Server record the changes in data that occur between backups?
11) For a full Oracle client, what is the name of the file that lists network information necessary to connect to various databases in the environment?
12) How did you configure a DSN in Windows? 
13) Name the tracing utilities for Oracle and SQL Server.

Web Servers:
1) What is WebLogic Server?
2) Name some http servers and application servers.
3) What's the main configuration file for IIS 6 ?
4) Where are the IIS log files kept in IIS 6 ?
5) What is Microsoft .Net?
6) Which .Net perfmon counters have you used to solve a problem ?
7) What is garbage collection ?

Network:
1) What is a MAC address ?
2) What is a command line or shell tool to display or change the network settings for an operating system ?
3) What kind of device typically acts as the default gateway ?
4) Which IP protocol does ping use ?
5) What is a command line or shell tool to display the network hops between one system and another one ?
6) What are some methods an OS uses to resolve another computer's name to its IP address ?  What's the name of a file that can be edited to set this on a client ?
7) What is an FQDN ?
8) What is a three-way handshake ?
9) What is a TCP reset ?  What conditions would cause a reset ?
10) What is a utility program to list the open sockets on a system ?  What helpful information would you get ?  What is an example socket state ?
11) What are some common ftp commands you might use?
12) What is an secure alternative to telnet ?
13) Name some tools to capture network traffic.  Describe a problem you solved using one.
14) When configuring an application to use an http proxy server, what are some of the settings you will need to make?  Name some proxy server software.

Other:

1) Describe any work you've done with crawlers or spiders
2) Describe any work involving OS virtualization
3) Describe any work you've done with Microsoft Sharepoint, Documentum or Lotus Notes
4) Describe any work you've done with Active Directory, Other directory servers?
5) Describe any work you've done with Microsoft Exchange, Other email systems?
6) Describe any work you've done with Help Desk Ticket Management Systems
7) Describe any work you've done with production environment Change Control Management systems
8) QA and Testing experience
9) Project Management, Software development methodologies?
10) What Social networking tools?  Ever written for a wiki?