Explore topic-wise InterviewSolutions in .

WWW, Search engine, Engine

(c) Domain Name Resolution

Suppose you mention a URL in the web-browser to visit a website. The browser first checks your computer to find if the IP address of the server is present. If this address is present then with the help of this address, the corresponding server is contacted and then the website opens in your browser. This process is called Domain Name Resolution.

(d) Firewall

Mr. Franco regularly visited this site to visit this site he has to type the address repeatedly every time. It is laborious work and it can be avoided if he marks the particular address as favorite. A favorite is a link to a web page. So that he can access that page faster.

To do this click add to favorite option then a dialog box appears that asks for a name for the favorite. To make the web page available offline, then ‘Make available offline1 option has to be checked.

1. Phishing 

2. Google it is a search engine All others are web browsers

Answer is (c) Media

(a) Favorites

Simple Mail Transfer Protocol(SMTP)

cookies are small text files that are created in our computer when we use a browser to visit a website.

The process of visiting the websites of various companies, organization, government, individuals etc is called internet browsing or surfing with the help of a browser software we can browse websites.

There are two ways to connect to the internet. First one dialing to an ISP’s computer or with a direct connection to an ISP. 

1. Dial-up Connection: 

Here the internet connection is established by dialing into an ISP’s computer and they will connect our computer to the internet. It uses Serial Line Internet Protocol (SLIP) or Point to Point Protocol (PPP). It is slower and has a higher error rate. 

2. Direct connection: 

In direct connection there is a fixed cable or dedicated phone line to the ISP. Here it uses ISDN (Integrated Services Digital Network) a high speed version of a standard phone line. Another method is leased lines that uses fiber optic cables.

Digital Subscribers Line (DSL) is another direct connection, this uses copper wires instead of fiber optic for data transfer. Direct connection provides high speed internet connection and error rate is less.

History will help her.

The address bar is also known as URL

(c) Facebook

The small text files used by browsers to remember our email id’s, user names, etc are known as Cookies.

I am Browser.

Refresh the web page.

(a) A browser

The correct answer is Solid State Drive

• Solid State Drive
  • A solid-state drive (SSD) is a new generation of storage device used in computers. SSDs replace traditional mechanical hard disks by using flash-based memory, which is significantly faster.
  • Older hard-disk storage technologies run slower, which often makes your computer run slower than it should.
  • SSDs speed up computers significantly due to their low read-access times and fast throughputs. 
• Advantages of SSD over HDD
  • The standard HDD (hard disk drive) has been the predominant storage device for computers (both desktops and laptops) for a long time. The main draw is the high storage capacity and low cost.
  • The SSD (solid-state drive) is another storage solution and is slowly replacing the majority of hard disk drives. As you'll learn by reading the following comparison table, the SSD technology is superior. However, due to its price per unit of memory, it doesn't make sense to use SSDs in all instances. For most computer users, we recommend using an SSD as the primary drive for your operating system, and the programs you access most frequently. Then, we suggest purchasing a large HDD (either internal or external) for storing documents, pictures, and music.

• ROM
  • Read-only memory is a type of non-volatile memory used in computers and other electronic devices.
  • Data stored in ROM cannot be electronically modified after the manufacture of the memory device.
• RAM
  • Random-access memory is a form of computer memory that can be read and changed in any order, typically used to store working data and machine code.
  • A random-access memory device allows data items to be read or written in almost the same amount of time irrespective of the physical location of data inside the memory

It is Browser

The correct answer is Motherboard.

• The software and hardware of a computer get instructions for processing a task that is generated or produced by a complex and heavy set of electronics devices that are embedded on a platform which is known as a motherboard.
• The motherboard allows communication to and between the CPU, RAM, and all other computer hardware components.
• A motherboard (also called mainboard, main circuit board, system board, baseboard, planar board, logic board, or mobo) is the main printed circuit board (PCB) in general-purpose computers and other expandable systems.
• It holds and allows communication between many crucial electronic components of a system, such as the central processing unit (CPU) and memory, and provides connectors for other peripherals.  

• HDD:-
  • A hard disk drive (sometimes abbreviated as a hard drive, HD, or >HDD) is a non-volatile storage device.
  • It is usually installed internally in a computer, attached directly to the disk controller of the computer's motherboard.
• SMPS:-
  • SMPS or switched-mode power supply is an electronic device that is used to convert AC to DC, AC to AC, DC to DC, and DC to AC voltages. 
• RAM:-
  • It is called 'volatile' memory by analogy because if the computer loses power, all the data stored in RAM (or other volatile memory) is lost or 'evaporates'.

The correct answer is File system

• File system
  • A file system is a process that manages how and where data on a storage disk, typically a hard disk drive (HDD), is stored, accessed and managed.
  • It is a logical disk component that manages a disk's internal operations as it relates to a computer and is abstract to a human user.
  • Commonly used file systems include File Allocation Table 32 (FAT 32), New Technology File System (NTFS) and Hierarchical File System (HFS).
• Database 
  • A database is a systematic collection of data.
  • They support electronic storage and manipulation of data. Databases make data management easy.
  • Example of Database-
    • An online telephone directory uses a database to store data of people, phone numbers, and other contact details.
    • The electricity service provider uses a database to manage billing, client-related issues, handle fault data, etc.
• Operating system
  • An Operating System (OS) is an interface between a computer user and computer hardware.
  • An operating system is a software that performs all the basic tasks like file management, memory management, process management, handling input and output, and controlling peripheral devices such as disk drives and printers. 
  • Operating System (OS) is a type of system software kernel that sits between computer hardware and end-user.
  • It is installed first on a computer to allow devices and applications to be identified and therefore functional.

The correct answer is Operating system

• Operating system
  • An Operating System (OS) is an interface between a computer user and computer hardware.
  • An operating system is a software that performs all the basic tasks like file management, memory management, process management, handling input and output, and controlling peripheral devices such as disk drives and printers. 
  • Operating System (OS) is a type of system software kernel that sits between computer hardware and end-user.
  • It is installed first on a computer to allow devices and applications to be identified and therefore functional.

• Firmware
  • In computing, firmware is a specific class of computer software that provides low-level control for a device's specific hardware.
  • Firmware, such as the BIOS of a personal computer may contain only elementary basic functions of a device and may only provide services to higher-level software.
• Translator
  •   A translator is a programming language processor that converts a computer program from one language to another.
  • It takes a program written in source code and converts it into machine code.

The interface between user and internet is Browser.

The correct answer is Operating System.

• Operating System acts as an interface connecting the computer user to the computer hardware.
• It is system software that manages computer hardware, software resources, and provides common services for computer programs.
• It sits in between the applications you run and the hardware, using the hardware drivers as the interface between the two.
• For example, when an application wants to print something, it hands that task off to the operating system.
• Following are some of the important functions of an operating System: Memory Management, Processor Management, Device Management, File Management, Security, Control over system performance, Job accounting, Error detecting aids, Coordination between other software and users.
• Some of the commonly used Operating Systems-
  • Microsoft Windows
  • Apple macOS
  • Linux
  • Android
  • Apple's iOS
  • UNIX

The correct answer is Plotter.

• Plotters are special types of printers designed to produce large size engineering drawings and similar large graphics.
  • Plotters are used to print graphical output on paper.
  • It actually draws point-to-point lines directly from vector graphics files.
  • The plotter was the first computer output device that could print graphics as well as accommodate full-size engineering and architectural drawings.
  • It interprets computer commands and makes line drawings on paper using multicolored automated pens.
  • It is capable of producing graphs, drawings, charts, maps, etc.

• Laser printers are machines that melt toner powder onto paper to create a print.
• A scanner is a device that captures images from photographic prints, posters, magazine pages, and similar sources for computer editing and display.
• A data projector is a projection device that takes a signal output by a computer and projects an image onto a projector screen via a lens system.

The correct answer is monitor.

• A monitor is a standard output device that displays text, images, and user interface elements by illuminating thousands of pixels with different colors. 
• The output devices of the computer are used to display results in electronic or paper medium.
• A monitor is a display device that can produce text and graphics as output. A monitor may use different display technologies like a Cathode Ray Tube (CRT) and Liquid Crystal Display (LCD).

The correct answer is OnTime

• OnTime method can make macros run automatically in MS-excel 2013, once you have done some setup for scheduling macros.
• OnTime method can make macros run automatically, once you've done some setup.
• Suppose you have a macro that you want to run each day at 15:00 (3:00 p.m.).
• First, you need to determine how to kick off the OnTime method.
• You can do this using the Workbook_Open event in the private module of the Workbook object.

Explanation:

Accumulator:

• “Accumulator” is the most frequently used register to store data from memory. It is an indifferent number in the different microprocessors.
• An Accumulator is a register for the short-term, intermediate storage of arithmetic and logic data in a computerized CPU.
• Intermediate results of an operation are progressively written to the accumulator, overwriting the previous value.

The correct answer is 100 % Stacked.

• 100 % Stacked type of column chart in MS-Excel 2013 is like a stacked column in that it uses a single bar for each category and subdivides that bar to show the proportion from each series.
• The stacked bar chart (aka stacked bar graph) extends the standard bar chart from looking at numeric values across one categorical variable to two. Each bar in a standard bar chart is divided into a number of sub-bars stacked end to end, each one corresponding to a level of the second categorical variable.
• The stacked bar chart above depicts revenue from a fictional fitness retailer for a particular period of time, across two categorical variables: store location and department.

The correct answer is "Bluetooth".

Bluetooth:

• Bluetooth is a wireless communication technology that can be used for close-range data transmission from one digital device to another.
• Bluetooth is essentially a one-to-one wireless connection that uses 2.4 GHz-band radio waves.
• Bluetooth technology was created by a telecom company called Ericsson in 1994. It was developed in order to connect two devices without wires.
• It is a short-range wireless convergent technology.
• The maximum connectivity range of a Bluetooth device is about 30 feet.

The correct answer is KB, MB, GB, TB.

• Storage Capacity of a Computer refers to how much data a computer system can store.
• Generally, there are two types of Storage Devices

1. Primary Storage Devices such as RAM and ROM
2. Secondary Storage Devices such as Hard Drive, Floppy Disk.

• Computer Storage is often measured in megabytes( MB) and gigabytes( GB).
• 1 KB( Kilobytes)= 1024 bytes.
• 1 Mb (Megabytes)= 1024 KB
• 1 GB (Gigabytes)= 1024 MB
• 1 TB (Terabytes)= 1024 GB

The correct answer is BIOS.

• Due to the fact that the main memory is volatile, when we turn on our computer, the CPU cannot access the main memory directly. However, there is a special program called BIOS stored in ROM that is accessed for the first time by the CPU.
• BIOS contains the code, by executing which, the CPU access the very first partition of the hard disk that is MBR.
• It contains a partition table for all the partitions of the hard disk.
• Since, MBR contains the information about where the operating system is being stored and it also contains a program that can read the boot sector record of the partition, hence the CPU fetches all this information and load the operating system into the main memory.

The correct answer is 50 GB.

• Blu-ray Storage Capacity:
  • Blu-ray or Blu-ray Disc (BD) is an optical disc data storage format developed by the Blu-ray Disc Association.
  • And it was officially released in 2006.
  • Blu-ray discs can be single-layer or dual-layer. A single-layer disc has 25 GB and a dual-layer disc has 50 GB storage capacity.
  • That means more than five times the storage capacity of standard DVDs.
  • First Blu-ray movies such as "50 First Dates", "Hitch", "The Fifth Element" were released coinciding with the release of the first Blu-ray DVD player. 

The correct answer is Transmission Control Protocol.

• TCP is the acronym of Transmission Control Protocol.
• TCP/IP is the most popular internet protocol.
• It is the communication protocol of the internet.
• IP stands for Internet Protocol.
• The Internet Protocol (IP) is the address system of the Internet.
• Internet Protocol helps for delivering packets of information from a source device to a target device.
• TCP/IP came into being in 1982.
• There are a total of 4 layers in a TCP/IP model.
  1. Application Layer
  2. Transport Layer
  3. Internet Layer
  4. Network Interface
• The TCP/IP relationship is similar to sending someone a message written on a puzzle through the mail.

The correct answer is 13.

•  The answer of the formula = EVEN(3) + ODD(8) in excel is 13.

• The EVEN function rounds a positive number up to the nearest even integer i.e. 3 will become 4.
• The ODD function rounds a positive number up to the nearest odd integer i.e. 8 will become 9.
• Hence, 9+4= 13.
• A function is a predefined formula that performs calculations using specific values in a particular order.
• How to Write Formulas in Excel
  • All Excel formulas start with an equal (=) sign.
  • The answer to the formula is displayed in the cell into which the formula is entered.
  • Cells are referenced in a formula by their column-row identifier.
  • The symbols for addition, subtraction, multiplication, and division are: + - * /
  • We do not have to enter capital letters in the formula, They will be capitalized automatically.

The correct answer is Primary Data.

• Primary data are original observations collected by the researcher or by his agent for the first time for any investigation and it is a collection of data from first-hand information.
• This type of primary data is mostly pure and original data.
• The primary data is the one type of important data it is useful for current studies as well as for future studies.​​​

• Secondary data are those which have already been collected by someone else and which have through some statistical analysis.
• Secondary data is the already existing data, collected by the investigator agencies and organizations earlier.
• Primary data is real-time data whereas secondary data is one that relates to the past.
• Primary data is collected for addressing the problem at hand while secondary data is collected for purposes other than the problem at hand.
• Primary data collection is a very involved process. On the other hand, the secondary data collection process is rapid and easy.

The correct answer is Subject.

• A Subject Line is an introduction that identifies the intent of the email.
• This subject line displayed to the email user or recipient when they look at their list of messages in their inbox should tell the recipient what the message is about, what the sender wants to convey.
• CC stands for carbon copy which means that whose address appears after the Cc, the header would receive a copy of the message.

• The first electronic mail was sent in 1971 by Ray Tomlinson.
• The very first version of what would become known as email was invented in 1965 at the Massachusetts Institute of Technology (MIT).
• The Simple Mail Transfer Protocol (SMTP) is used to deliver e-mail messages over the Internet.

The correct answer is Baidu.

• BAIDU:
  • Baidu search engine is the Chinese search engine developed by Baidu Inc in the year 2000.
  • According to the Alexa Internet rankings, Baidu is currently the fourth largest website.
  • Services provided by the search engine - Baidu Baike (online encyclopedia), Baidu Wangpan (cloud storage services), Baidu Tieba (keyword-based discussion forum).
  • It has been blocked by the government in India in 2020.

• PACKETS:
  • Donald Davies gave this term in the year 1965.
  • The word 'packet' in computer terminology refers to a segment of data sent from one computer or device to another over a network.
  • A packet contains some important information like - source, destination, data, size, etc.
• COOKIES:
  • The web-browser programmer, Lou Montulli gave the term 'cookie'.
  • The text files containing data like username and password, that identify a computer over a network are known as 'cookies'.
  • HTTP cookies are a specific type of cookies stored on the user's computer and used to identify specific users by the web browser while browsing a website, thus improving the web browsing experience.
  • Cookies remember information and record the browsing activity of the user.

The correct answer is Desktop.

• The desktop is the main screen area that you see after you turn on your computer and log on to Windows.
• Like the top of an actual desk, it serves as a surface for your work.
• When you open programs or folders, they appear on the desktop.
• The desktop is the primary user interface of a computer.
• It includes the desktop background (or wallpaper) and icons of files and folders you may have saved to the desktop.
• In Windows, the desktop includes a taskbar, which is located at the bottom of the screen by default.

• The Start menu is a graphical user interface element used in Microsoft Windows since Windows 95 and in some other operating systems.  
• A file manager or file browser is a computer program that provides a user interface to manage files and folders. 
• An operating system is system software that manages computer hardware, software resources, and provides common services for computer programs.