Thursday, 31 July 2014

Windows sysadmin interview questions

Windows sysadmin interview questions

  1. What are the required components of Windows Server 2003 for installing Exchange 2003? - ASP.NET, SMTP, NNTP, W3SVC

  1. What must be done to an AD forest before Exchange can be deployed? - Setup /forestprep

  1. What Exchange process is responsible for communication with AD? - DSACCESS

  1. What 3 types of domain controller does Exchange access? - Normal Domain Controller, Global Catalog, Configuration Domain Controller

  1. What connector type would you use to connect to the Internet, and what are the two methods of sending mail over that connector? - SMTP Connector: Forward to smart host or use DNS to route to each address

  1. How would you optimise Exchange 2003 memory usage on a Windows Server 2003 server with more than 1Gb of memory? - Add /3Gb switch to boot.ini

  1. What would a rise in remote queue length generally indicate? - This means mail is not being sent to other servers. This can be explained by outages or performance issues with the network or remote servers.

  1. What would a rise in the Local Delivery queue generally mean? - This indicates a performance issue or outage on the local server. Reasons could be slowness in consulting AD, slowness in handing messages off to local delivery or SMTP delivery. It could also be databases being dismounted or a lack of disk space.

  1. What are the standard port numbers for SMTP, POP3, IMAP4, RPC, LDAP and Global Catalog? - SMTP – 25, POP3 – 110, IMAP4 – 143, RPC – 135, LDAP – 389, Global Catalog - 3268

  1. Name the process names for the following: System Attendant? – MAD.EXE, Information Store – STORE.EXE, SMTP/POP/IMAP/OWA – INETINFO.EXE

  1. What is the maximum amount of databases that can be hosted on Exchange 2003 Enterprise? - 20 databases. 4 SGs x 5 DBs.

  1. What are the disadvantages of circular logging? - In the event of a corrupt database, data can only be restored to the last backup.


Screening questions for Windows admin

Screening questions for Windows admin

1.                     What is Active Directory?

2.                     What is LDAP?
 3.                     Can you connect Active Directory to other 3rd-party Directory Services?                 Name a few options.

4.                     Where is the AD database held? What other folders are related to AD?

5.                     What is the SYSVOL folder?

6.                     Name the AD NCs and replication issues for each NC

7.                     What are application partitions? When do I use them

8.                     How do you create a new application partition

9.                     How do you view replication properties for AD partitions and DCs?

10.                 What is the Global Catalog?

11.                 How do you view all the GCs in the forest?

12.                 Why not make all DCs in a large forest as GCs?

13.                 What are the Support Tools? Why do I need them?

14.                 What is LDP?

15.                 What is REPLMON?

16.                 What is ADSIEDIT?

17.                 What is NETDOM?

18.                 What is REPADMIN?

19.                 What is the KCC?

20.                 What is the ISTG? Who has that role by default?

21.                 What are the requirements for installing AD on a new server?

22.                 What can you do to promote a server to DC if you’re in a remote location with slow WAN link?

23.                 How can you forcibly remove AD from a server, and what do you do later? • Can I get user passwords from the AD database?

24.                 What tool would I use to try to grab security related packets from the wire?


25.                 What do you do to install a new Windows 2003 DC in a Windows 2000 AD?

26.                 What do you do to install a new Windows 2003 R2 DC in a Windows 2003 AD?

27.                 How would you find all users that have not logged on since last month?

28.                 What are the DS* commands?

29.                 What are the FSMO roles? Who has them by default? What happens when each one fails?

30.                 What FSMO placement considerations do you know of?

31.                 I want to look at the RID allocation table for a DC. What do I do?

32.                 What’s the difference between transferring a FSMO role and seizing one? Which one should you NOT seize? Why?

33.                 How do you configure a “stand-by operation master” for any of the roles?

34.                 How do you backup AD? How do you restore AD?

35.                 How do you change the DS Restore admin password?

36.                 Why can’t you restore a DC that was backed up 4 months ago?

37.                 What are GPOs?

38.                 What is the order in which GPOs are applied?

39.                 What are GPO links? What special things can I do to them?

40.                 What are administrative templates?

41.                 What’s the difference between software publishing and assigning?

42.                 Can I deploy non-MSI software with GPO?

43.                 You want to standardize the desktop environments (wallpaper, My Documents, Start menu, printers etc.) on the computers in one department. How would you do that?


Hiring an IT guy - questions to ask

Hiring an IT guy - questions to ask

1.      What port does telnet use?

2.      What is SMTP?

3.      How would you troubleshoot a printer?

4.      How does traceroute work?

5.      Walk me through everything that happens in the network from the moment you punch in www.google.com in the address bar to when the browser displays the page?

6.      What role do you think computer support analysts should play in the company?

7.      Assuming you have to work for a living and all jobs pay the same, how would you describe the job you want?

8.      What operating system do you prefer and why?

9.      What is the differece between local, global and universal groups?

10.  What is the major difference between FAT and NTFS?

11.  Name the FMSO roles and their functions.

12.  You’ve just been asked to create 20 new Users and update 2 GPOs, ASAP! You go to the Administrative Tools, and discover they are all gone. What do you do? What do you suspect happened?

13.  What is a Global Catalog?

14.  Explain the function of DNS.

15.  Explain a “Two-Way Transitive” trust.

16.  Describe the lease process of DHCP.

17.  Explain NTP.


18.  You have a user call for support for the 5th time on the same issue. How would you handle the call and what would you do differently?

19.  List as many ways you can think of to move a file from a Windows machine to a Linux machine.




Network engineer interview questions

Network engineer interview questions

1.                     User(s) are complaining of delays when using the network. What would you do?

2.                     What are some of the problems associated with operating a switched LAN?

3.                     Name some of the ways of combining TCP/IP traffic and SNA traffic over the same               link.

4.                     What sort of cabling is suitable for Fast Ethernet protocols?

5.                     What is a Class D IP address?

6.                     Why do I sometimes lose a server’s address when using more than one server?

7.                     What is Firewall?

8.                     How do I monitor the activity of sockets?

9.                     How would I put my socket in non-blocking mode?

10.                 What are RAW sockets?

11.                 What is the role of TCP protocol and IP protocol?

12.                 What is UDP?

13.                 How can I make my server a daemon?

14.                 How should I choose a port number for my server?

15.                 Layers in TCP/IP

16.                 How can I be sure that a UDP message is received?

17.                 How to get IP header of a UDP message?

18.                 Writing UDP/SOCK_DGRAM applications

19.                 How many bytes in an IPX network address?

20.                 What is the difference between MUTEX and Semaphore?

21.                 What is priority inversion?

22.                 Different Solutions to dining philosopher’s problem.

23.                 What is a message queue?

24.                 Questions on Shared Memory.

25.                 What is DHCP?

26.                 Working of ping, telnet, and gopher.

27.                 Can I connect two computers to internet using same line?

SQL interview questions and answers

SQL interview questions and answers

  1. What are two methods of retrieving SQL?

  1. What cursor type do you use to retrieve multiple recordsets?

  1. What is the difference between a "where" clause and a "having" clause? - "Where" is a kind of restiriction statement. You use where clause to restrict all the data from DB.Where clause is using before result retrieving. But Having clause is using after retrieving the data.Having clause is a kind of filtering command.

  1. What is the basic form of a SQL statement to read data out of a table? The basic form to read data out of table is ‘SELECT * FROM table_name; ‘ An answer: ‘SELECT * FROM table_name WHERE xyz= ‘whatever’;’ cannot be called basic form because of WHERE clause.

  2. What structure can you implement for the database to speed up table reads?- Follow the rules of DB tuning we have to: 1] properly use indexes ( different types of indexes) 2] properly locate different DB objects across different tablespaces, files and so on.3] create a special space (tablespace) to locate some of the data with special datatype ( for example CLOB, LOB and …)

  1. What are the tradeoffs with having indexes? - 1. Faster selects, slower updates. 2. Extra storage space to store indexes. Updates are slower because in addition to updating the table you have to update the index.

  1. What is a "join"? - ‘join’ used to connect two or more tables logically with or without common field.

  1. What is "normalization"? "Denormalization"? Why do you sometimes want to denormalize? - Normalizing data means eliminating redundant information from a table and organizing the data so that future changes to the table are easier. Denormalization means allowing redundancy in a table. The main benefit of denormalization is improved performance with simplified data retrieval and manipulation. This is done by reduction in the number of joins needed for data processing.

  1. What is a "constraint"? - A constraint allows you to apply simple referential integrity checks to a table. There are four primary types of constraints that are currently supported by SQL Server: PRIMARY/UNIQUE - enforces uniqueness of a particular table column. DEFAULT - specifies a default value for a column in case an insert operation does not provide one. FOREIGN KEY - validates that every value in a column exists in a column of another table. CHECK - checks that every value stored in a column is in some specified list. Each type of constraint performs a specific type of action. Default is not a constraint. NOT NULL is one more constraint which does not allow values in the specific column to be null. And also it the only constraint which is not a table level constraint.

  1. What types of index data structures can you have? - An index helps to faster search values in tables. The three most commonly used index-types are: - B-Tree: builds a tree of possible values with a list of row IDs that have the leaf value. Needs a lot of space and is the default index type for most databases. - Bitmap: string of bits for each possible value of the column. Each bit string has one bit for each row. Needs only few space and is very fast.(however, domain of value cannot be large, e.g. SEX(m,f); degree(BS,MS,PHD) - Hash: A hashing algorithm is used to assign a set of characters to represent a text string such as a composite of keys or partial keys, and compresses the underlying data. Takes longer to build and is supported by relatively few databases.

  1. What is a "primary key"? - A PRIMARY INDEX or PRIMARY KEY is something which comes mainly from
    database theory. From its behavior is almost the same as an UNIQUE INDEX, i.e. there may only be one of each value in this column. If you call such an INDEX PRIMARY instead of UNIQUE, you say something about
    your table design, which I am not able to explain in few words. Primary Key is a type of a constraint enforcing uniqueness and data integrity for each row of a table. All columns participating in a primary key constraint must possess the NOT NULL property.

  1. What is a "functional dependency"? How does it relate to database table design? - Functional dependency relates to how one object depends upon the other in the database. for example, procedure/function sp2 may be called by procedure sp1. Then we say that sp1 has functional dependency on sp2.

  1. What is a "trigger"? - Triggers are stored procedures created in order to enforce integrity rules in a database. A trigger is executed every time a data-modification operation occurs (i.e., insert, update or delete). Triggers are executed automatically on occurance of one of the data-modification operations. A trigger is a database object directly associated with a particular table. It fires whenever a specific statement/type of statement is issued against that table. The types of statements are insert,update,delete and query statements. Basically, trigger is a set of SQL statements A trigger is a solution to the restrictions of a constraint. For instance: 1.A database column cannot carry PSEUDO columns as criteria where a trigger can. 2. A database constraint cannot refer old and new values for a row where a trigger can.

  1. Why can a "group by" or "order by" clause be expensive to process? - Processing of "group by" or "order by" clause often requires creation of Temporary tables to process the results of the query. Which depending of the result set can be very expensive.

  1. What is "index covering" of a query? - Index covering means that "Data can be found only using indexes, without touching the tables"

  1. What types of join algorithms can you have?

  1. What is a SQL view? - An output of a query can be stored as a view. View acts like small table which meets our criterion. View is a precomplied SQL query which is used to select data from one or more tables. A view is like a table but it doesn’t physically take any space. View is a good way to present data in a particular format if you use that query quite often. View can also be used to restrict users from accessing the tables directly.