First interview of PricewaterhouseCoopers

Directions

Please answer all questions in English, expect where the question directs you to answer in Chinese. (For example, translating a portion of an English document into Chinese)

Please do your own work. This is not a group exercise. You may not consult any notes while taking this test.

Some of the questions you may not be able to answer. This is expected. DO your best to answer the ones that you can.

You have exactly 60 minutes to complete the test.

A General
1 Please describe to the best of your knowledge PricewaterhouseCoopers. What are we? What do we do?

2 please describe to the best of your knowledge the work of the IT department of PwC.

3 what is your understanding of the type of work that you are interviewing for. What would be your main responsibilities?

4 what dose the word “professional” mean to you?

5 If you were given a task by your supervisor but did not know how to do it. What would you do?

6 what does the phrase “excellent client service” mean to you?

B Technical Overview
1 what PC operating systems are you familiar with? Please explain how familiar you are with each one. How can your skills help PwC?

2 what NOS are you familiar with? Please explain how familiar you are with each one. How can your skills help PwC?

3 what email systems are you familiar with? Please explain how familiar you are with each one. How can your skills help PwC?

4 what PABX systems are you familiar with? Please explain how familiar you are with each one. How can your skills help PwC?

5 If the company you worked for was expanding rapidly, what would do you think the focus of the IT department should be. Please rank the following items in the order that you believe is the most ideal.
__ Training of IT staff
__ IT policies and procedures
__ Server uptime & proper maintenance
__ stable PCs (desktops and laptops)
__ Documentation
__ Good negotiations for purchasing hardware
__ Backups
__ A good understanding of where the business is going
__ Security of the PCs, Servers and Network
__ Expandable infrastructure
__ Administration/Record keeping
__ Other (please write in)

6 You have been asked to design a new database for the Finance department. Please order the following planning task in the way that you would do them.
__ Create a project proposal detailing the work that would be alone
__ Determine database platform
__ Determine what information will be input into the database
__ Understand the workflow of the Finance department
__ Determine database structure
__ Gain agreement from Finance on proposal
__ Determine what output will be needed
__ Create a project plan detailing what task should be done and when

C Technical Depth

1 Please give a definition for the following terms, including how it might be used.
Bluetooth –
WAN –
MAN –
IR –
RAIDS –
Macro –
@function –
IP Telephony –
Relational Database –
Switch –
FM200 –
CSS –

2 What are the inherent dangers of WLAN? What can be done to reduce these risks?

3 What is a firewall? When would you use one ?

4 If you were given a PC that could not boot normally into Windows XP, what would you do to try and troubleshoot the problem?

5 Microsoft has just issued 2 security patches for Windows XP. You have been asked to update 1000 PCs. How will you handle this problem?

6 Please write an SQL statement that will retrieve records containing the value “Fred” for the field “first name” where the table name is “people”.

7 Please write a very basic HTML code for displaying the following sentences on a webpage.
Hello!
Welcome to our world

8 You have been alerted to a virus on the network. What action will you take?

9 Please translate the article that was given to you into Chinese.