Pages

Tuesday, 2 February 2016

Overview on SQL Queries- IBPS SO IT Officer




Overview on SQL Queries
Ø DML - Data Manipulation Language





Command


Description

SELECT


Retrieves certain records from one or more tables

INSERT


Creates a record

UPDATE


Modifies records

DELETE


Deletes records


Top 100 Networking Questions & Answers for IBPS SO Part 2

Top 100 Networking Questions & Answers for IBPS SO Part 2

21) What is the importance of the OSI Physical Layer?
The physical layer does the conversion from data bits to electrical signal, and vice versa. This is
where network devices and cable types are considered and setup.

22) How many layers are there under TCP/IP?
There are four layers: the Network Layer, Internet Layer, Transport Layer and Application Layer.

23) What are proxy servers and how do they protect computer networks?
Proxy servers primarily prevent external users who identifying the IP addresses of an internal
network. Without knowledge of the correct IP address, even the physical location of the network
cannot be identified. Proxy servers can make a network virtually invisible to external users.

Monday, 1 February 2016

Top 100 Networking Questions & Answers for IBPS SO Part 1

Top 100 Networking Questions & Answers for IBPS SO Part 1

1) What is a Link?
A link refers to the connectivity between two devices. It includes the type of cables and
protocols used in order for one device to be able to communicate with the other.

2) What are the layers of the OSI reference model?
There are 7 OSI layers: Physical Layer, Data Link Layer, Network Layer, Transport Layer,
Session Layer, Presentation Layer and Application Layer.

3) What is backbone network?
A backbone network is a centralized infrastructure that is designed to distribute different routes
and data to various networks. It also handles management of bandwidth and various channels.