Can someone answer this? Users from the finance department access an Oracle serv
ID: 3559389 • Letter: C
Question
Can someone answer this?
Users from the finance department access an Oracle server for their operations. The computers on the finance department network are assigned public IP addresses. The Oracle server is on a different network than the finance department network. The users complain of slow response from the Oracle server.
What do you learn from the way this statement is made?
public IP address means you are open to DOS attacks or ICMP packets pinging your public ip ports
If the Oracle server is on a "Different" network than the finance department then think about how the data packets must be transferred between the two networks...are there routers and switches involved doing the routing? Are the transmissions open to interference due to public IP addresses...are there potential bandwidth issues...what else can cause latency or slowness affecting the data in this scenario?
Explanation / Answer
Users from the finance department access an Oracle server for their operations. The computers on the finance department network are assigned public IP addresses. The Oracle server is on a different network than the finance department network. The users complain of slow response from the Oracle server.
What do you learn from the way this statement is made?
The above statement tells us that there is network latency while receiving response. This could be due to various reasons :
1. Network congestion - When too many requests are being sent to the same Oracle server simultaneously
2. Low Bandwidth - The server does not have enough bandwidth and can only send few Megabits/second. This speed might be too slow for the people in Finance Department.
3. There could be a network outage, wherein one or more Oracle servers might shut off
Public IP address means you are open to DOS attacks or ICMP packets pinging your public ip ports
If the Oracle server is on a "Different" network than the finance department then think about how the data packets must be transferred between the two networks...
The Finance department computers and Oracle server are on differnt public networks. Since, they are on public networks, each machine has a public ip address. When a request is made from a computer in Finance Department the request is sent to one of the Oracle servers identified by an IP address. Simiarly, when the Oracle server responds back, it send the reponse to the IP address of the Finance Department computer. The data that is transferred between the 2 machines is sent in teh form of "data packets". The data packets have a specific structure that bot sender and receiver machines understand. The data packets contains the actual data along with other information for error correction, header fields, IP address etc.
are there routers and switches involved doing the routing?
Yes. Routers and switches are essential to transferring data across networks and computers. Especially over long distances. A router is a device that forwards data packets between computer networks. When a data packet comes in one of the lines, the router reads the address information in the packet to determine its ultimate destination. Then, using information in its routing table or routing policy, it directs the packet to the next router or destination computer. Switches are used to connect computers, not for transferring packets.
Are the transmissions open to interference due to public IP addresses...
Yes, transmissions are open to interference. The interference can be physical - the network wire being damaged or inclement weather conditions. These factors can introduce noise which can corrupt data. Some packets containing information might get dropped or lost. Also, any data being transmitted publicly can be interceterpted by hackers. Such data should be encrypted by using SSL or some other encryption methods so that data is not suceptible to interferences.
are there potential bandwidth issues...what else can cause latency or slowness affecting the data in this scenario?
Yes, as mentioned in the first answer, there can be several reasons due to which there can be latency issue and slowness of data. These can happne due to low bandwidth, network congestion by too many simultaneous requests leading to Denial of Service, physical damage to devices.