Saturday, November 19, 2016

How to use Vlookup in Excel

Basically, VLOOKUP lets you search for specific information in your spreadsheet. For example,if you have a list of employee details, you could search for the details of specific employee.

1.To use vlookup first of all we have to create table (as shown in figure.)
2. Select tables and give table names such as Hulk.(as shown in figure)


3.Now we will write his name TO SEE the vlookup such as we want to see mobile number of Ram. Then we will type Ram and use vlookup formula for Ram.

=VLOOKUP(H19,HULK,6,0)

EXPLANATION

H19= IF YOU WANT TO SEE VLOOKUP OF RAM THEN CLICK ON RAM, H19 WILL BE SELECTED AUTOMATICALLY.BY THIS YOU CAN SEE  ANYONE VLOOKUP.NOW HERE I AM USING RAM. (YOU CAN TYPE ANY ONE NAME INSTEAD OF Ram)
HULK= HULK IS TABLE NAME (TABLE ARRAY)

6= WRITE THAT COLUMN  NUMBER  WHICH COLUMN NUMBER YOU WANT TO SEE.(FOR EX. COL 6)

0= FALSE VALUE(IT SHOW EXACT VALUE)
4.And press enter.It show the mobile number of Ram.


Then it show the Mobile no. of Ram

Now you have learnt the use of vlookup .

Password Protect Any Folder Without Any Software


In my previous post i have teach you to hide files behind images. In this tutorial i will show you interesting and usefull trick to password protect folder without using any software using batch file programming. This trick will work on all windows platform (Win XP, Win 7). Follow below tutorial to learn this trick

How To Lock Folder ?

1. Open Notepad and Copy code given below into it. 
cls
@ECHO OFF
title perfectit4u.blogspot.com
if EXIST "Control Panel.{21EC2020-3AEA-1069-A2DD-08002B30309D}" goto UNLOCK
if NOT EXIST MyFolder goto MDMyFolder
:CONFIRM
echo Are you sure to lock this folder? (Y/N)
set/p "cho=>"
if %cho%==Y goto LOCK
if %cho%==y goto LOCK
if %cho%==n goto END
if %cho%==N goto END
echo Invalid choice.
goto CONFIRM
:LOCK
ren MyFolder "Control Panel.{21EC2020-3AEA-1069-A2DD-08002B30309D}"
attrib +h +s "Control Panel.{21EC2020-3AEA-1069-A2DD-08002B30309D}"
echo Folder locked
goto End
:UNLOCK
echo Enter password to Unlock Your Secure Folder
set/p "pass=>"
if NOT %pass%== SECURITY goto FAIL
attrib -h -s "Control Panel.{21EC2020-3AEA-1069-A2DD-08002B30309D}"
ren "Control Panel.{21EC2020-3AEA-1069-A2DD-08002B30309D}" MyFolder
echo Folder Unlocked successfully
goto End
:FAIL
echo Invalid password
goto end
:MDMyFolder
md MyFolder
echo MyFolder created successfully
goto End
:End
2. Save the notepad file as lock.bat (.bat is must) 
3. Now double click on lock.bat and a new folder will be created with name MyFolder
4. Copy all your data you want to protect in that New folder 
5. Now double click on lock.bat and when command promp appears Type Y and press enter. 
6. Now MyFolder will be hidden from you view, to access that folde double click on lock.bat 
7. It will ask for password enter your password and done. (Default password is security) 
·         To change the password replace Security with new password in the above code

How To Further Secure ?


You might be thinking that anyone can access the password by opening that lock.bat file in Notepad or any other text editor. To make it more secure hide lock.bat in some secure location after following the above tutorial To access the secured file double click on lock.bat. I would suggest copying lock.bat file into Pendrive and copying it into your computer whenever you required to access to your protected files. 

Set up a computer-to-computer (ad hoc) network

An ad hoc network is a temporary connection between computers and devices used for a specific purpose, such as sharing documents during a meeting or playing multiplayer computer games. You can also temporarily share an Internet connection with other people on your ad hoc network, so those people don’t have to set up their own Internet connections. Ad hoc networks can only be wireless, so you must have a wireless NETWORK ADAPTER installed in your computer to set up or join an ad hoc network.

click to open network and sharing center.
click to manage wireless network.
 click to add button.

click on create an ad hoc network

fill the required information,
   such as network name=adhoc ,security type=wpa2-professional
   security key=123@qwe, check save the network tab.
 process start to create ad hoc network.


then click close button.


            click on the network icon tab on the
            created ad hock network. as shown in the figure.

           
For more latest update to visit my website 
rajnishjaiswalj928.blogspot.in



Learn To Hide Files Behind The Images

There are some important  files or document you want to hide from others on your computer. To do that you might be creating folder inside folder to hide such files but in todays tutorial i will change this by teaching you a interesting trick to hide files behind images.To hide a file behind a image  means that if any one opens that image he will see the image, but to see the hidden file we need to open that image in a specific way. So lets get started.

How To Hide File Behind Image ?

In order to do this you should have basic understanding of command line, but if you don't know check out  tutorial given below.
1. Select an image to be used for hiding file behind the image.
2. Now select a file to hide behind the image and make it in .RAR format. With the help of the WinRAR.(Download winrar)
3. And most important is that paste both the files on desktop. You may do this anywhere instead of desktop if you have some basic understanding of command line.
4. Now open cmd by going to Start > Accessories > Command Prompt and type following commands in it.
cd desktop
5. CD stands for change directory by typing above command you change your directory to desktop. After that type command given below.

 Copy /b imagename.jpg + filename.rar finalimage.jpg
Replace imagename.jpg with the name of image you want your file to be hidden behind. Don't forget to add image format (Eg: .jpg,.png,.gif)

Replace filename with name of your file you want to hide. It must be in .rar format.
Finally Replace finalimage.jpg with whatever name you want your final image with hidden files should be. This is the image where your file will be hidden.
6. Now when you will try to open this newly created image it will open as normal image, but to open you hidden file you need follow steps given below.
How To Access Hidden File ?
To access your hidden file you need to open the newly created image in winrar. Just follow simple steps given below to do that.

HOW TO MAKE MULTIBOOTABLE WINDOWS USB FROM WinSetupFromUsb


In this guide, we will show you how to create multi-boot USB drive containing Windows 7 and Windows 8.1 installation files with the help of WinSetupFromUSB software.

ollow the given below instructions carefully to prepare your multi-boot USB drive containing Windows 7 and Windows 8.1 installation files,



Things you will need to prepare multiboot USB:
# Windows 7 ISO file
# Windows 8/8.1 ISO file
# 8 GB+ USB drive (we recommend 16 GB for 64-bit Windows)
# A computer running Windows 7, 8, or 8.1
NOTE: You must have Windows 7 and Windows 8/8.1 ISO files. If you have Windows 7 or Windows 8.8.1 DVDs, you need to prepare an ISO file image out of the DVD first. There are plenty of tools out there to help you crate bootable ISO image file from DVD. Almost all popular ISO image burning software, including popular ISO Workshop (free) allows you create ISO image from DVD.
Procedure:
Step 1: Visit this page and download the latest version of WinSetupFromUSB file. Extract the compressed zip file to get a folder named WinSetupFromUSB with separate executable for 32-bit and 64-bit Windows.
Step 2: Connect your USB drive to the PC and backup all data to a safe location, as the drive will be erased before making bootable.
Step 3: Run WinSetupFromUSB. Note that if you’re on x64 bit Windows, please run the executable named WinSetupFromUSB x64. Click Yes button when you see the UAC dialog.
Step 4: Under USB disk selection and format tools section, select your USB flash drive that you would like to make multi-boot.
Step 5: Turn the option titled Auto format it with FBinst on and then select NTFS as the file system. Note that if you’re preparing this multi-boot USB to install Windows 7/8.1 on a UEFI based PC, you need to selectFAT32 instead of NTFS.

Step 6: Under Add to USB disk section, check the box titled Windows Vista/7/8/Server 2008/2012 based ISO to see the browse button and then click the browse button to browse to your Windows 7 ISO image file. Select your Windows 7 ISO and then click Open button.
NOTE: If you have selected NTFS as the file system in Step 5, when you click the browse to select the ISO file, you will get a message saying that “If you need (U)EFI support for the 64-bit versions of Windows Vista SP1 or later, you must use FAT32 partition.”
Step 7: Finally, click Go button to begin transferring Windows 7 setup files to your USB. Click Yes button when you see the warning dialogs to continue. The process might take 15-30 
minutes depending on the version of Windows you’ve selected and your PC’s hardware.
Once done, you’ll see Job done message.
Now that we have added Windows 7 installation files to the USB, it’s time to transfer Windows 8/8.1 files to the USB. Don’t disconnect the USB from the PC and also don’t quit WinSetupFromUSB.
Step 8: In this step, we’re going to add Windows 8/8.1 installation files to the USB. Select your USB drive andbe sure to keep the option Auto format with FBinst turned off (selecting it will format the USB drive again, so be sure not to select it).
Step 9: Check Windows Vista/7/8/Server 2008/2012 based ISO file and this time, browse to your Windows 8.1 ISO file and click Open button to select it.
Step 10: Finally, click GO button, click Yes when you see two warning messages to begin transferring Windows 8/8.1 installation files to the selected USB. Once WinSetupFromUSB completes its business, you’ll see Job done message. You can safely remove the USB and then use it as multi-boot USB to install Windows 7 or Windows 8/8.1. That’s it! Good luck |






NETWORKING QUESTION WITH ANSWER FOR AN INTERVIEW


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.
4) What is a LAN?
LAN is short for Local Area Network. It refers to the connection between computers and other network devices that are located within a small physical location.
5) What is a node?
A node refers to a point or joint where a connection takes place. It can be computer or device that is part of a network. Two or more nodes are needed in order to form a network connection.
6) What are routers?
Routers can connect two or more network segments. These are intelligent network devices that store information in its routing table such as paths, hops and bottlenecks. With this info, they are able to determine the best path for data transfer. Routers operate at the OSI Network Layer.
7) What is point to point link?
It refers to a direct connection between two computers on a network. A point to point connection does not need any other network devices other than connecting a cable to the NIC cards of both computers.
8) What is anonymous FTP?
Anonymous FTP is a way of granting user access to files in public servers. Users that are allowed access to data in these servers do not need to identify themselves, but instead log in as an anonymous guest.
9) What is subnet mask?
A subnet mask is combined with an IP address in order to identify two parts: the extended network address and the host address. Like an IP address, a subnet mask is made up of 32 bits.
10) What is the maximum length allowed for a UTP cable?
A single segment of UTP cable has an allowable length of 90 to 100 meters. This limitation can be overcome by using repeaters and switches.
11) What is data encapsulation?
Data encapsulation is the process of breaking down information into smaller manageable chunks before it is transmitted across the network. It is also in this process that the source and destination addresses are attached into the headers, along with parity checks.
12) Describe Network Topology
Network Topology refers to the layout of a computer network. It shows how devices and cables are physically laid out, as well as how they connect to one another.
13) What is VPN?
VPN means Virtual Private Network, a technology that allows a secure tunnel to be created across a network such as the Internet. For example, VPNs allow you to establish a secure dial-up connection to a remote server.
14) Briefly describe NAT.
NAT is Network Address Translation. This is a protocol that provides a way for multiple computers on a common network to share single connection to the Internet.
15) What is the job of the Network Layer under the OSI reference model?
The Network layer is responsible for data routing, packet switching and control of network congestion. Routers operate under this layer.
16) How does a network topology affect your decision in setting up a network?
Network topology dictates what media you must use to interconnect devices. It also serves as basis on what materials, connector and terminations that is applicable for the setup.
17) What is RIP?
RIP, short for Routing Information Protocol is used by routers to send data from one network to another. It efficiently manages routing data by broadcasting its routing table to all other routers within the network. It determines the network distance in units of hops.
18) What are different ways of securing a computer network?
There are several ways to do this. Install reliable and updated anti-virus program on all computers. Make sure firewalls are setup and configured properly. User authentication will also help a lot. All of these combined would make a highly secured network.
19) What is NIC?
NIC is short for Network Interface Card. This is a peripheral card that is attached to a PC in order to connect to a network. Every NIC has its own MAC address that identifies the PC on the network.
20) What is WAN?
WAN stands for Wide Area Network. It is an interconnection of computers and devices that are geographically dispersed. It connects networks that are located in different regions and countries.
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.
24) What is the function of the OSI Session Layer?
This layer provides the protocols and means for two devices on the network to communicate with each other by holding a session.  This includes setting up the session, managing information exchange during the session, and tear-down process upon termination of the session.
25) What is the importance of implementing a Fault Tolerance System? Are there limitations?
A fault tolerance system ensures continuous data availability. This is done by eliminating a single point of failure. However, this type of system would not be able to protect data in some cases, such as in accidental deletions.
26) What does 10Base-T mean?
The 10 refers to the data transfer rate, in this case is 10Mbps. The word Base refers to base band, as oppose to broad band. T means twisted pair, which is the cable used for that network.
27) What is a private IP address?
Private IP addresses are assigned for use on intranets. These addresses are used for internal networks and are not routable on external public networks. These ensures that no conflicts are present among internal networks while at the same time the same range of private IP addresses are reusable for multiple intranets since they do not “see” each other.
28) What is NOS?
NOS, or Network Operating System, is specialized software whose main task is to provide network connectivity to a computer in order for it to be able to communicate with other computers and connected devices.
29) What is DoS?
DoS, or Denial-of-Service attack, is an attempt to prevent users from being able to access the internet or any other network services. Such attacks may come in different forms and are done by a group of perpetuators. One common method of doing this is to overload the system server so it cannot anymore process legitimate traffic and will be forced to reset.
30) What is OSI and what role does it play in computer networks?
OSI (Open Systems Interconnect) serves as a reference model for data communication. It is made up of 7 layers, with each layer defining a particular aspect on how network devices connect and communicate with one another. One layer may deal with the physical media used, while another layer dictates how data is actually transmitted across the network.
31) What is the purpose of cables being shielded and having twisted pairs?
The main purpose of this is to prevent crosstalk. Crosstalks are electromagnetic interferences or noise that can affect data being transmitted across cables.
32) What is the advantage of address sharing?
By using address translation instead of routing, address sharing provides an inherent security benefit. That’s because host PCs on the Internet can only see the public IP address of the external interface on the computer that provides address translation and not the private IP addresses on the internal network.
33) What are MAC addresses?
MAC, or Media Access Control, uniquely identifies a device on the network. It is also known as physical address or Ethernet address. A MAC address is made up of 6-byte parts.
34) What is the equivalent layer or layers of the TCP/IP Application layer in terms of OSI reference model?
The TCP/IP Application layer actually has three counterparts on the OSI model: the Session layer, Presentation Layer and Application Layer.
35) How can you identify the IP class of a given IP address?
By looking at the first octet of any given IP address, you can identify whether it’s Class A, B or C. If the first octet begins with a 0 bit, that address is Class A. If it begins with bits 10 then that address is a Class B address. If it begins with 110, then it’s a Class C network.
36) What is the main purpose of OSPF?
OSPF, or Open Shortest Path First, is a link-state routing protocol that uses routing tables to determine the best possible path for data exchange.
37) What are firewalls?
Firewalls serve to protect an internal network from external attacks. These external threats can be hackers who want to steal data or computer viruses that can wipe out data in an instant. It also prevents other users from external networks from gaining access to the private network.
38) Describe star topology
Star topology consists of a central hub that connects to nodes. This is one of the easiest to setup and maintain.
39) What are gateways?
Gateways provide connectivity between two or more network segments. It is usually a computer that runs the gateway software and provides translation services. This translation is a key in allowing different systems to communicate on the network.
40) What is the disadvantage of a star topology?
One major disadvantage of star topology is that once the central hub or switch get damaged, the entire network becomes unusable.
41) What is SLIP?
SLIP, or Serial Line Interface Protocol, is actually an old protocol developed during the early UNIX days. This is one of the protocols that are used for remote access.
42) Give some examples of private network addresses.
10.0.0.0 with a subnet mask of 255.0.0.0
172.16.0.0 with subnet mask of 255.240.0.0
192.168.0.0 with subnet mask of 255.255.0.0
43) What is tracert?
Tracert is a Windows utility program that can used to trace the route taken by data from the router to the destination network. It also shows the number of hops taken during the entire transmission route.
44) What are the functions of a network administrator?
A network administrator has many responsibilities that can be summarize into 3 key functions: installation of a network, configuration of network settings, and maintenance/troubleshooting of networks.
45) Describe at one disadvantage of a peer to peer network.
When you are accessing the resources that are shared by one of the workstations on the network, that workstation takes a performance hit.
46) What is Hybrid Network?
A hybrid network is a network setup that makes use of both client-server and peer-to-peer architecture.
47) What is DHCP?
DHCP is short for Dynamic Host Configuration Protocol. Its main task is to automatically assign an IP address to devices across the network. It first checks for the next available address not yet taken by any device, then assigns this to a network device.
48) What is the main job of the ARP?
The main task of ARP or Address Resolution Protocol is to map a known IP address to a MAC layer address.
49) What is TCP/IP?
TCP/IP is short for Transmission Control Protocol / Internet Protocol. This is a set of protocol layers that is designed to make data exchange possible on different types of computer networks, also known as heterogeneous network.
50) How can you manage a network using a router?
Routers have built in console that lets you configure different settings, like security and data logging. You can assign restrictions to computers, such as what resources it is allowed access, or what particular time of the day they can browse the internet. You can even put restrictions on what websites are not viewable across the entire network.
51) What protocol can be applied when you want to transfer files between different platforms, such between UNIX systems and Windows servers?
Use FTP (File Transfer Protocol) for file transfers between such different servers. This is possible because FTP is platform independent.
52) What is the use of a default gateway?
Default gateways provide means for the local networks to connect to the external network. The default gateway for connecting to the external network is usually the address of the external router port.
53) One way of securing a network is through the use of passwords. What can be considered as good passwords?
Good passwords are made up of not just letters, but by combining letters and numbers. A password that combines uppercase and lowercase letters is favorable than one that uses all upper case or all lower case letters. Passwords must be not words that can easily be guessed by hackers, such as dates, names, favorites, etc. Longer passwords are also better than short ones.
54) What is the proper termination rate for UTP cables?
The proper termination for unshielded twisted pair network cable is 100 ohms.
55) What is netstat?
Netstat is a command line utility program. It provides useful information about the current TCP/IP settings of a connection.
56) What is the number of network IDs in a Class C network?
For a Class C network, the number of usable Network ID bits is 21. The number of possible network IDs is 2 raised to 21 or 2,097,152. The number of host IDs per network ID is 2 raised to 8 minus 2, or 254.
57) What happens when you use cables longer than the prescribed length?
Cables that are too long would result in signal loss. This means that data transmission and reception would be affected, because the signal degrades over length.
58) What common software problems can lead to network defects?
Software related problems can be any or a combination of the following:
– client server problems
– application conflicts
– error in configuration
– protocol mismatch
– security issues
– user policy and rights issues
59) What is ICMP?
ICMP is Internet Control Message Protocol. It provides messaging and communication for protocols within the TCP/IP stack. This is also the protocol that manages error messages that are used by network tools such as PING.
60) What is Ping?
Ping is a utility program that allows you to check connectivity between network devices on the network. You can ping a device by using its IP address or device name, such as a computer name.
61) What is peer to peer?
Peer to peer are networks that does not reply on a server. All PCs on this network act as individual workstations.
62) What is DNS?
DNS is Domain Name System. The main function of this network service is to provide host names to TCP/IP address resolution.
63) What advantages does fiber optics have over other media?
One major advantage of fiber optics is that is it less susceptible to electrical interference. It also supports higher bandwidth, meaning more data can be transmitted and received. Signal degrading is also very minimal over long distances.
64) What is the difference between a hub and a switch?
A hub acts as a multiport repeater. However, as more and more devices connect to it, it would not be able to efficiently manage the volume of traffic that passes through it. A switch provides a better alternative that can improve the performance especially when high traffic volume is expected across all ports.
65) What are the different network protocols that are supported by Windows RRAS services?
There are three main network protocols supported: NetBEUI, TCP/IP, and IPX.
66) What are the maximum networks and hosts in a class A, B and C network?
For Class A, there are 126 possible networks and 16,777,214 hosts
For Class B, there are 16,384 possible networks and 65,534 hosts
For Class C, there are 2,097,152 possible networks and 254 hosts
67) What is the standard color sequence of a straight-through cable?
orange/white, orange, green/white, blue, blue/white, green, brown/white, brown.
68) What protocols fall under the Application layer of the TCP/IP stack?
The following are the protocols under TCP/IP Application layer: FTP, TFTP, Telnet and SMTP.
69) You need to connect two computers for file sharing. Is it possible to do this without using a hub or router?
Yes, you can connect two computers together using only one cable. A crossover type cable can be use in this scenario. In this setup, the data transmit pin of one cable is connected to the data receive pin of the other cable, and vice versa.
70) What is ipconfig?
Ipconfig is a utility program that is commonly used to identify the addresses information of a computer on a network. It can show the physical address as well as the IP address.
71) What is the difference between a straight-through and crossover cable?
A straight-through cable is used to connect computers to a switch, hub or router. A crossover cable is used to connect two similar devices together, such as a PC to PC or Hub to hub.
72) What is client/server?
Client/server is a type of network wherein one or more computers act as servers. Servers provide a centralized repository of resources such as printers and files. Clients refers to workstation that access the server.
73) Describe networking.
Networking refers to the inter connection between computers and peripherals for data communication. Networking can be done using wired cabling or through wireless link.
74) When you move the NIC cards from one PC to another PC, does the MAC address gets transferred as well?
Yes, that’s because MAC addresses are hard-wired into the NIC circuitry, not the PC. This also means that a PC can have a different MAC address when the NIC card was replace by another one.
75) Explain clustering support
Clustering support refers to the ability of a network operating system to connect multiple servers in a fault-tolerant group. The main purpose of this is the in the event that one server fails, all processing will continue on with the next server in the cluster.
76) In a network that contains two servers and twenty workstations, where is the best place to install an Anti-virus program?
An anti-virus program must be installed on all servers and workstations to ensure protection. That’s because individual users can access any workstation and introduce a computer virus when plugging in their removable hard drives or flash drives.
77) Describe Ethernet.
Ethernet is one of the popular networking technologies used these days. It was developed during the early 1970s and is based on specifications as stated in the IEEE. Ethernet is used in local area networks.
78) What are some drawbacks of implementing a ring topology?
In case one workstation on the network suffers a malfunction, it can bring down the entire network. Another drawback is that when there are adjustments and reconfigurations needed to be performed on a particular part of the network, the entire network has to be temporarily brought down as well.
79) What is the difference between CSMA/CD and CSMA/CA?
CSMA/CD, or Collision Detect, retransmits data frames whenever a collision occurred. CSMA/CA, or Collision Avoidance, will first broadcast intent to send prior to data transmission.
80) What is SMTP?
SMTP is short for Simple Mail Transfer Protocol. This protocol deals with all Internal mail, and provides the necessary mail delivery services on the TCP/IP protocol stack.
81) What is multicast routing?
Multicast routing is a targeted form of broadcasting that sends message to a selected group of user, instead of sending it to all users on a subnet.
82) What is the importance of Encryption on a network?
Encryption is the process of translating information into a code that is unreadable by the user. It is then translated back or decrypted back to its normal readable format using a secret key or password. Encryption help ensure that information that is intercepted halfway would remain unreadable because the user has to have the correct password or key for it.
83) How are IP addresses arranged and displayed?
IP addresses are displayed as a series of four decimal numbers that are separated by period or dots. Another term for this arrangement is the dotted decimal format. An example is 192.168.101.2
84) Explain the importance of authentication.
Authentication is the process of verifying a user’s credentials before he can log into the network. It is normally performed using a username and password. This provides a secure means of limiting the access from unwanted intruders on the network.
85) What do mean by tunnel mode?
This is a mode of data exchange wherein two communicating computers do not use IPSec themselves. Instead, the gateway that is connecting their LANs to the transit network creates a virtual tunnel that uses the IPSec protocol to secure all communication that passes through it.
86) What are the different technologies involved in establishing WAN links?
Analog connections – using conventional telephone lines; Digital connections – using digital-grade telephone lines; switched connections – using multiple sets of links between sender and receiver to move data.
87) What is one advantage of mesh topology?
In the event that one link fails, there will always be another available. Mesh topology is actually one of the most fault-tolerant network topology.
88) When troubleshooting computer network problems, what common hardware-related problems can occur?
A large percentage of a network is made up of hardware. Problems in these areas can range from malfunctioning hard drives, broken NICs and even hardware startups. Incorrectly hardware configuration is also one of those culprits to look into.
89) What can be done to fix signal attenuation problems?
A common way of dealing with such a problem is to use repeaters and hub, because it will help regenerate the signal and therefore prevent signal loss. Checking if cables are properly terminated is also a must.
90) How does dynamic host configuration protocol aid in network administration?
Instead of having to visit each client computer to configure a static IP address, the network administrator can apply dynamic host configuration protocol to create a pool of IP addresses known as scopes that can be dynamically assigned to clients.
91) Explain profile in terms of networking concept?
Profiles are the configuration settings made for each user. A profile may be created that puts a user in a group, for example.
92) What is sneakernet?
Sneakernet is believed to be the earliest form of networking wherein data is physically transported using removable media, such as disk, tapes.
93) What is the role of IEEE in computer networking?
IEEE, or the Institute of Electrical and Electronics Engineers, is an organization composed of engineers that issues and manages standards for electrical and electronic devices. This includes networking devices, network interfaces, cablings and connectors.
94) What protocols fall under the TCP/IP Internet Layer?
There are 4 protocols that are being managed by this layer. These are ICMP, IGMP, IP and ARP.
95) When it comes to networking, what are rights?
Rights refer to the authorized permission to perform specific actions on the network. Each user on the network can be assigned individual rights, depending on what must be allowed for that user.
96) What is one basic requirement for establishing VLANs?
A VLAN requires dedicated equipment on each end of the connection that allows messages entering the Internet to be encrypted, as well as for authenticating users.
97) What is IPv6?
IPv6 , or Internet Protocol version 6, was developed to replace IPv4. At present, IPv4 is being used to control internet traffic, butis expected to get saturated in the near future. IPv6 was designed to overcome this limitation.
98) What is RSA algorithm?
RSA is short for Rivest-Shamir-Adleman algorithm. It is the most commonly used public key encryption algorithm in use today.
99) What is mesh topology?
Mesh topology is a setup wherein each device is connected directly to every other device on the network. Consequently, it requires that each device have at least two network connections.
100) what is the maximum segment length of a 100Base-FX network?
The maximum allowable length for a network segment using 100Base-FX is 412 meters. The maximum length for the entire network is 5 kilometers.

How To Delete Usb History From The Registry


Delete USB history
Punitive is portable device to carry data. Through pen drive you can share data to anyone .but some organization plugging of pen drive is restricted.in this case if you plug your pen drive in such kind of organization by mistake.so you are in trouble.
So I have trick to delete pen drive history.

Step 1

If you want to see when you were plugged pen drive last time. To download this software.(Click Here)
It show you all history.

Step 2

To delete pen drive history there is software called USBObellian.this software delete all pen drive history from registry. To download this software from here.(Click Here)

When you plug pen drive, the pen drive history are stored in registry.
If you want to check usb history from the registry follow this Steps
Press windows key + R  and type Regedit in Run dialog box
HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\Enum\USBSTOR  in that you get all USBHistory
To delete usb history double click on the USBObellian setup.
Check the box Do real clean and uncheck save backup .reg file and Click the Clean button.
By this you can successfully clean USB History.



Registry Hacks to Tweak Your Windows PC

☺☺
Microsoft Windows offers a feature-rich interface and several customization options that make it one of the most user friendly operating systems in the world. However, computer geeks would still love to hack the Windows Registry so as to add more extra features and functionalities to their operating system.
If you’re one such geek who would like to customize Windows in your own way, here is a list of 8 interesting registry hacks that you need to try:

1. Disable USB Devices:


Disabling USB ports can be a smart idea to add security to the computer. This can be really handy if the computer is on a public place where the chances of virus and other malware infection is really high. You can easily disable access to USB ports with the following registry hack:
Open the Registry Editor (Start -> Run -> Type regedit and hit Enter)
In the registry, navigate to the following key:
HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\Services\UsbStor
In the right-side pane, double-click on “Start”.
In the “Value data” field enter 4 and click on “OK”.
Close the Registry Editor and reboot.
To enable USB devices, follow the same procedure as above except in the step-4 enter 3 in the “Value data” field.

Works on Windows XP, Vista and 7.

2. Disable Notification Balloons in Windows 7 and Vista:

You can now disable the annoying notification balloons that keeps popping up frequently with warning messages and reminders. Here is a step-by-step procedure to do that:
Open the Registry Editor and navigate to the following key:
HKEY_CURRENT_USER\Software\Microsoft\Windows\CurrentVersion\Explorer\Advanced
Right-click on the right-hand pane, and create a new “DWORD”.
Rename it to EnableBalloonTips, double-click on it and set the “Value data” to 0. Reboot the computer to see the changes in effect.
3. Add “Recycle Bin” to My Computer in Windows 7 and Vista:


Would you like to add the “Recycle Bin” icon to My Computer so that you need not go back to the desktop to access it when required? Well, here is how you can do that:
Open the Registry Editor and navigate to the following key:
HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Windows\CurrentVersion\Explorer\MyComputer\NameSpace
Right-click on “NameSpace” and select New -> Key. Name the key with the following name:
{645FF040-5081-101B-9F08-00AA002F954E}
Now, open “My Computer” and hit F5 to refresh the screen. This should show up the “Recycle Bin” icon.
4. Disable the Windows Task Manager:

Need to limit access to your computer by disabling the Task Manager? Here is a simple registry hack to do this:
Open the Registry Editor and navigate to the following key:
HKEY_CURRENT_USER\Software\Microsoft\Windows\CurrentVersion\Policies
Right-click on “Policies”, select New -> Key and name the key as System.
If you are on Windows XP, you need not create the new key “System” as it is already present in it. So, you can directly navigate to: HKEY_CURRENT_USER\Software\Microsoft\Windows\CurrentVersion\Policies\System in the Step-1 itself.
Right-click on “System”, create a new “DWORD” and name it to DisableTaskMgr.
Double-click on the DWORD “DisableTaskMgr” and set the “Value data” to 1 (0=Enable, 1=Disable).
To enable the Task Manager, Set the “Value data” back to 0.
Works on Windows XP, Vista and 7.

5. Change the Registered Owner and Organization Name:

Here is a simple hack to change the name of the Registered owner on your computer:
Open the Registry Editor and navigate to:
HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Windows NT\CurrentVersion
On the right-side pane, find the keys RegisteredOwner and RegisteredOrganization. Double-click on them to change the names to whatever you want.
To see the changes, right-click on “My Computer” and select “Properties”.
Works on Windows XP, Vista and 7.

6. Add Programs to Windows Startup:  
                   
You can now add your favorite programs to Windows Startup without the need for using the start-up folder. Here is a way to do this:
Open the Registry Editor and navigate to the following key:
HKEY_CURRENT_USER\Software\Microsoft\Windows\CurrentVersion\Run
On the right-side pane, create a new “String Value” and rename it to the name of the program that you want to add (you can give any name, it doesn’t matter).
Double-click on the “String Value”, in the “Value data” field add the path of the executable program that has to execute at startup.
Reboot the computer to see the changes in effect.
Works on Windows XP, Vista and 7.

7. Add “Pin to Start Menu” Option for Folders in Windows 7 and Vista:

Ever wanted to pin a folder to the start menu to gain faster access to it? Well, it is possible to add the “Pin to Start Menu” option so that you can plug your favorite folders to Start Menu. Here is a step-by-step procedure:
Open the Registry Editor and navigate to:
HKEY_CLASSES_ROOT\Folder\shellex\ContextMenuHandlers
Right-click on “ContextMenuHandlers” and select New -> Key. Name the key as follows:
{a2a9545d-a0c2-42b4-9708-a0b2badd77c8}
Now, whenever you want to add a folder to Start Menu, hold down the Shift key and right-click on the folder. You should see the “Pin to Start Menu” option in the context menu”.
8. Disable “Aero Shake” in Windows 7:

One of the new additions to Windows 7 is the “Aero Shake” feature using which it is possible to grab a window using its title bar and shake it. This will minimize all the other open windows if any. It is really a handy feature! However, if you ever wanted to disable this feature, here is a solution:
Open the Registry Editor and navigate to the following key:
HKEY_CURRENT_USER\Software\Policies\Microsoft\Windows
Now, right-click on “Windows” key and create a new Key called Explorer.
Right-click on the “Explorer” key and create a new “DWORD” called NoWindowMinimizingShortcuts and set its value to 1.
Close the Registry Editor and reboot the computer to see the changes in effect.
I hope you enjoyed this post. Try the registry hacks and share your experiences.

Thanks for your reading.

Make Your Computer Welcome You

Do you watch movies? Have you always loved the way how Computers in movies welcome their users by calling out their names? I bet that you too would want to know how you can achieve similar results on your PC and have a computer said welcome.

Then you are at the right place, this article describes exactly how you can make your computer welcome you like this.

With this trick, you can make your Computer welcome you in its computerized voice. You can make your Windows based computer say "Welcome to your PC, Username."

Make Windows Greet you with a Custom Voice Message at Startup

To use this trick, follow the instructions given below:-
Click on Start. Navigate to All Programs, Accessories and Notepad.
Copy and paste the exact code given below.
Dim speaks, speech
speaks="Welcome to your PC, Username"
Set speech=CreateObject("sapi.spvoice")
speech.Speak speaks
     3.  Replace Username with your own name.
     4.  Click on File Menu, Save As, select All Types in Save as Type option, and save the file as                   Welcome.vbs or "*.vbs".
     5.  Copy the saved file.
     6.  Navigate to C:\Documents and Settings\All Users\Start Menu\Programs\Startup (in Windows                XP) and to C:\Users\ {User-Name}\AppData\Roaming\Microsoft\Windows\Start          Menu\Programs\Startup (in Windows 8, Windows 7 and Windows Vista) if C: is your System drive. AppData is a hidden folder. So, you will need to select showing hidden folders in Folder options to locate it.
  7.  Paste the file.

Note: For best results, it is recommended to change sound scheme to No Sounds.
You can change the sound scheme to No Sounds by following the steps given below:-
Go to Control Panel.
Then click on Switch to Classic View.
Then Click on Sounds and Audio Devices.
Then Click on the Sounds Tab.
Select No Sounds from the Sound Scheme option.
If you wish to save your Previous Sound Scheme, you can save it by clicking Yes in the popup menu.
Click on OK.
Try it yourself to see how it works. In my personal opinion, this is an excellent trick. Whenever I start my PC in front of anybody and the PC welcomes me, the fellow is left wondering how brilliant a computer do I have.







Notepad Tricks: Cool Notepad tricks for Windows

Notepad, the text editor that comes bundled in Windows is an excellent tool for text editing. But that is not the only thing for which notepad is famous. It is also famous for its tricks and hacks. Here is a roundup of some of the best and coolest tricks that you can try using Notepad.


Matrix Falling Code Effect - Notepad CMD (.BAT) Tricks

Inspired by the movie Matrix, this falling code trick is extremely popular on social networking websites. Copy and paste the code given below in Notepad and save the file as "Matrix.bat" or *.bat.


@echo off
color 02
:tricks
echo %random%%random%%random%%random%%random%%random%%random%%random%
goto tricks

                                            Matrix Falling Code Effect - Notepad Trick

Upon running the bat file, you will see the "Matrix falling code" effect.

    Make Your Keyboard Type (Any) Message Continuously-VBS Trick

This VBS trick can make any of your friend's keyboard type any message continuously. Open Notepad, copy the code given below and save the file as Tricks.vbs or *.vbs. You will need to restart your computer to stop this. Try this after closing all important programs.

Set wshShell = wscript.CreateObject("WScript.Shell")

do                                   
wscript.sleep 100
wshshell.sendkeys"You r hacked."
loop

Send this file to your friends as an email attachment to see the fun.


Create a Harmless Funny Virus with Notepad-Continuously eject CD/DVD drives

This VBS trick will create a code which will continuously eject all your connected Optical drives. If you put them back in, it will pop them out again. Copy this code and paste it in Notepad as Virus.vbs or *.vbs.     


Set oWMP = CreateObject("WMPlayer.OCX.7")
Set colCDROMs = oWMP.cdromCollection
do
if colCDROMs.Count >= 1 then
For i = 0 to colCDROMs.Count - 1
colCDROMs.Item(i).Eject
Next
For i = 0 to colCDROMs.Count - 1
colCDROMs.Item(i).Eject
Next
End If
wscript.sleep 5000
loop


Click on newly created .vbs file and see effect.
For more latest notepad tricks keep visiting my website.

Thanks for your reading.

Rajnish Jaiswal -+919628273549

   




                                                                       

How To Use Teamviwer


Team viewer
Teamviwer is computer software that establish connection between your computer.it is used for remote control ,desktop sharing, and file transfer between copmputers.it is an excellent screen sharing and file transfer application that can be used  to facilate bussiness collaboration and remotely access a scond computer.
You can easily download the lates version of team viewer.(Click Here)

How to install
Double click on setup, and click Yes
Select  basic installation and  both of the above and click accept and finish as shown in rhe figure

The installation Screen will apper as shown in figur.
Note
The ID and Password on the left side of the screen are of your computer. You have to give this id and password to the user who want to acses your computer using teamviewer.The Partner ID box on the right side will take the id of the user with whome you want to connect.

In the Partner ID box,enter  the Partner ID of the computer to access it.
Click connect to partner button.the teamviwer Authentication Password Dialog box appear.you ask Password From your Partner To connect It.

Team viwer is now connected to troubleshoot problems of remote PC.

contect-+919628273549

Monday, November 14, 2016

History Of Computer In Hindi

कंप्यूटर का इतिहास जानें


कंप्यूटर शब्द की उत्पति अंग्रेज़ी भाषा के कम्प्यूट शब्द से हुई है जिसका अर्थ है गणना करना अतः कम्प्यूटर का विकास गणितिय गणनाओं के उद्देश्य की पूर्ति के लिए किया गया है सबसे पहले कंप्यूटर का आविष्कार 600 ईसा पहले गिनतारे का विकास मेसोपुटामिया में हुआ, इसी प्रकार Calculator का आविष्कार 17वीं शताब्दी के शुरुआत में डानन नेपियर ने किया था जिसका उपयोग गणितिय गणनाओं हेतु किया गया था. इसके बाद 1671 में ब्रान गोट फ्राइड में गणना करने वाले कैलकुलेटर का आविष्कार किया. 1942 में बेब्ज पास्कल ने यांत्रिक कैलकुलेटर बनाया जिसे पास्कलिंग कहा गया यह कैलकुलेटर सिर्फ 6 व्यकित्यों के बराबर गणना कर सकता था.
History of Computer : 1822 में चार्ल्स बेबेज ने सबसे पहले Digital Computer बनाया पास्कलिन से प्रेरणा लेकर डिफ्रेन्सियल और एनालिटीकल एनिंजन का अविष्कार किया, उन्होंने 1937 में स्वचालित कंप्यूटर की परिकल्पना की जिसमे कृत्रिम स्मृति तथा प्रोग्राम के अनुरूप गणना करने की क्षमता हो, किन्तु हथर्न होलेरीथ ने भी पूरा किया ! पंचकार्ड की मदद से सारा कार्य खुद ही करने इलेक्ट्रोनिक टेबूलेशन मशीन का निर्माण किया गया! मतलब प्रथम पीढ़ी के कंप्यूटर में Vacuum Tube या Vacuum Valve का प्रयोग हुआ.
1948 में Valve की जगह ट्रांजिस्टर का उपयोग किया जाने लगा ! इससे Vacuum Tube में होने वाले श्योर में पैदा होने वाली गर्मी से निजात पाया जा सका ! इसमें का खर्चीले और कम जगह घेरने वाले कंप्यूटर का निर्माण संभव हो सका !
1958 में ट्रांजिस्टर के स्थान पर सिलकोन चिप पर इंटीग्रेटेड सर्किट का उपयोग कंप्यूटर के क्षेत्र में किया जाने लगा | इसने कंप्यूटर के क्षेत्र में मूलभूत परिवर्तन तथा एक नयी क्रांति ला दी जिसको कंप्यूटर की तीसरी पीढ़ी कहा गया ! सिलकोन चिप निर्मित कंप्यूटर का आकार अत्यंत छोटा होने के कारण इन्हें मिनी कंप्यूटर कहा जाने लगा.

Computer History by Year :कंप्यूटर तकनिकी विकास के द्वारा जो कंप्यूटर के कार्यशेली तथा क्षमताओं में विकास हुआ इसके फलस्वरूप कंप्यूटर विभिन्न पीढ़ियों तथा विभिन्न प्रकार की कंप्यूटर की क्षमताओं का निर्माण का आविष्कार हुआ !
कार्य क्षमता के इस विकास को 1964 में कंप्यूटर जनरेशन कहा जाने लगा.

कंप्यूटर विकास की पहली पीढ़ी (First Generation History in Hindi) :-
वैक्यूम टूयूब्स (1940 - 1956) : इलेक्ट्रॉनिक सिग्नल को नियंत्रण और प्रसारित करने हेतु वैक्यूम टूयूब्स का उपयोग किया गया इसमें भरी भरकम कंप्यूटर का निर्माण हुआ किन्तु सबसे पहले उन्ही के द्वारा कंप्यूटर की परिकल्पना साकार हुई | ये टूयूब्स के आकार में बड़े तथा ज्यादा गर्मी उत्पन्न करते थे तथा उनमे टूट-फुट तथा ज्यादा खराबी होने की संभावना रहती थी और इसकी गणना करने की क्षमता भी काफी कम थी और पहली पीढ़ी के कंप्यूटर ज्यादा स्थान घेरते थे.

कंप्यूटर विकास की दूसरी पीढ़ी (Second Generation History in Hindi):-
ट्रांजिस्टर (1956 - 1963) : में ट्रांजिस्टर का आविष्कार हुआ | इस दौरान के कंप्यूटरों में ट्रांजिस्टरों का एक साथ प्रयोग किया जाने लगा था, जो वाल्व्स की अपेक्षा अधिक सक्षम और सस्ते होते थे | जिन्हें कंप्यूटर निर्माण हेतु वैक्यूम टूयूब्स के स्थान पर उपयोग किया जाने लगा | ट्रांजिस्टर का आकार वैक्यूम टूयूब्स की तुलना में काफी छोटा होता है | जिससे कंप्यूटर छोटे तथा उनकी गणना करने की क्षमता अधिक और तेज | पहली पीढ़ी की तुलना में इनका आकार छोटा और कम गर्मी उत्पन्न करने वाले तथा अधिक कार्यक्षमता व तेज गति के गणना करने में सक्षम थे.

कंप्यूटर विकास की तीसरी पीढ़ी (Third Generation Computer History in Hindi):-
इंटीग्रेटेड सर्किट (1964 - 1971) : इस अवधि के कंप्यूटरो का एक साथ प्रयोग किया जा सकता था. यह समकालित चिप विकास की तीसरी पीढ़ी का महत्वपूर्ण आधार बनी, कंप्यूटर के आकार को और छोटा करने हेतु तकनिकी प्रयास किये जाते रहे जिसके परिणाम स्वरूप सिलकोन चिप पर इंटीग्रेटेड सर्किट निर्माण होने से कंप्यूटर में इनका उपयोग किया जाने लगा ! जिसके फलस्वरूप कंप्यूटर अब तक के सबसे छोटे आकार का उत्पादन करना संभव हो सका ! इनकी गति माइक्रो सेकंड से नेनो सेकंड तक की थी जो स्माल स्केल इंटीग्रेटेड सर्किट के द्वारा संभव हो सका.

कंप्यूटर विकास की चोथी पीढ़ी (Fourth Generation Computer History in Hindi):-
माइक्रोप्रोसेसर (1971 - 1985) : चोथी पीढ़ी के कंप्यूटरों में माइक्रोप्रोसेसर का प्रयोग किया गया ! वी.एस.एल.आई. की प्राप्ति से एकल चिप हजारों ट्रांजिस्टर लगाए जा सकते थे.

कंप्यूटर विकास की पांचवी पीढ़ी (Fifth Generation Computer History in Hindi) :-
आर्टिफीसियल इंटेलिजेंस: विकास की इस पांचवी अवस्था में कंप्यूटरों में कृत्रीम बुद्धि का निवेश किया गया है ! इस तरह के कंप्यूटर अभी पूरी तरह से विकशित नहीं हुए है ! इस तरह के कंप्यूटरों को हम रोबोट और विविध प्रकार के ध्वनि कार्यकर्मो में देख सकते है ! ये मानव से भी ज्यादा सक्षम होगा.
+contect -+919628273549

How to hide folder

1. Hide Folders

Windows offers an easy way to quickly hide folders from unsuspecting eyes. This method requires that Windows does not show hidden files and folders. So to begin with, you have to check this setting:

Open Windows Explorer (open any folder) and go to > Tools > Folder options…
Within Folder Options switch to the > View tab.
Under > Files and Folders find the option > Hidden files and folders and select > Don’t show hidden files, folders, or drives.
Click > OK and proceed to hiding a folder.

Hii 
 To hide a folder do the following:

Right-click the folder you want to hide and select > Properties.
In the > General tab check the option > Hidden.
Go to > Advanced change archive and index attributes.
Click > OK to save your changes.
hide folders



QUESTIONS FOR CAMPUS INTERVIEW with answers 65

Q1:- Differentiate between RAM and ROM? RAM stands for Random Access Memory. It can store information and have new information stored o...