Advanced Stats exam

profilemottcr
ib_300_midterm_2015.docx

Course: IB300 , Advanced Computer Sciences

Mid Term Exam

WARNING: Caution: Any Copy and Paste from the Internet will be detected and will result in an automatic "F". There will be no second chances given.

Part 1

1- Define a local computer network?

_______________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________

2- What is the difference between a network node and a network host? Give an example of each

_______________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________

3- What is the use of a computer modem?

_______________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________

4- Define a Public IP address?

_______________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________

5- State an example where you would need a static Local IP address?

_______________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________

6- It is said that ISP’s are hierarchical. What does that mean?

_______________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________

7- Which Protocol(s) (TCP/IP, UDP, FTP, DNS, VOIP) do we use when doing the following operations:

Chatting on skype using Text and using Webcam: _______

Talking voice and sending images using whatsapp: _______

Entering Credit Card information on Amazon: _______

8- What does DNS stand for and what does it do?

__________________________________________________________________________________________________________________________________________________________________________

9- Define TCP/IP and Briefly describe how it works?

_______________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________

10- How can you find out the public IP address of Amazon.com?

____________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________

11- What is the major international incident that led to the creation of ARPA

_______________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________

12- State two drawbacks of using file systems for Data Bases

_______________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________

13- What is SQL stands for and what does it do?

__________________________________________________________________________________________________________________________________________________________________________

14- The Internet and World Wide Web are NOT the exact same thing:

True

False

Part 2: Network Troubleshooting

Tiger electronics is a known tech company that has just purchased a new building that will be used for housing Four departments: HR, Finance, Engineering and Logistics.

The HR department is made of 4 employees and will occupy Floor 1. Finance consist of 6 employees and will occupy F2. Logistics has 5 employees and will occupy F3. Engineering consistes for 3 Emplyees and is located in the Basement.

The company has ordered a phone line and DSL internet connection of 12 Mbps.

A- How many switches and routers does Tiger electronics need to get all the employees access to the network.

________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________

B- Draw the network diagram of Tiger Electronics’ new building

C- Mr Smith from the Logistics department has no Internet access, but has access to the network. Knowing that the rest of his team have all access to the internet, state one possible reason that can cause such issue.

__________________________________________________________________________________________________________________________________________________________________________________________________________________________________________

D- The company wants to order three printers and give access to all employees for printing. Where should these 3 printers be installed and how (state and Draw your answer)?

____________________________________________________________________________________________________________________________________________________________

E- All equipment is connected to the network, however there the company has no internet. State three possible reasons for such issue.

__________________________________________________________________________________________________________________________________________________________________________________________________________________________________________

F- The company decided to add a small office on the roof for the security guard. After running a cable from the router (located in the basement), the computer on the roof seem to have internment and slow connection due to the network cable being too long. What would be the best way to fix such issue?

____________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________