BCS LAB VIVA QUESTIONS
What is a computer
Computer is defined as a fast electronic calculating machine that accepts digitalized input information [0,1] process it according to a list of internally stored instruction and produces the resultant output information.
what are the characteristics of computer
Accuracy:
The Accuracy of a computer is consistently high. Error can occur,but these are almost always due to human error rather than technological weaknesses.
Dilligence
Unlike human beings,a computer does not suffer from limitations associated with living beings like tiredness and lack of concentration and hence can work for hours at a stretch without error arising from the above(non-existent) faults.
Versatility
Computer are capable of performing any task. Multi-processing features of computer makes it quiet versatile in nature.
Storage
The computers have a lot of a storage devices which can store a tremendous amount of data.
Flexibility
Flexibility would involve the number of things you can do with a computer. While some are best used for simple business tasks, and simple categorizing and filing sort of tasks,.
Reliability
The term reliability refers to the ability of a computer-related hardware or software component to consistently perform according to its specifications.
what are the advantages of computer
1. It is the fastest medium of communication rendering postal and telegraphic communication almost worthless.
2. Through computer your message or anything written or photograph can reach any part of the world using internet facilities.
3. You can download any amount of material through computer.
4. All your arithmetical problemscan be easily sorted out through computer,
5. Through video conferencing you can not only see each otherbut alsotalk with any body living in any part of the world.
Explain briefly the functional units of a computer
A computer consist of 5 functional units
A. Input unit
B. Output unit
C. Memory unit
D. Arithmetic logic unit
E. Control unit
A. Input unit: Computer accepts coded information through the input unitex: keyboard, mouse, joystick etc
B. Memory unit: The function of the memory is to store the program or data.
C.Arithmetic logic unit: This performs all the arithmetic and logic operations.The arithmetic operations like add, subtract, multiply, divide etc Ex: logic operations OR, AND, NOT etc
D. Output unit: This unit gives the result to the outside world.
E. Control unit: This unit controls all the functions of the unit in the computer.
Explain hardware and software briefly with example.
Hard ware: All the physical electronic components of a computer system including peripherals and other components which are visible to naked eyes is called hardware. Hardware can be seen, touched and felt.Example: printer, mouse, monitors, keyboard, etc
Software:It is a collection of program which can be executed on the computer. It provide services to the users of the system.Example: application software, system language, utilities software, etc
Classification of software
Application software:It satisfies user. All the software’s designed to work in the system is called as application software. It is also a program/ group of programs designed for end users
Example: word processor(word pad, ms office word etc). Database program (ms access, excel) visual basic, java programs software etc
System software:It is a collection of programs designed to operate ,control, and extend processing capabilities
Example: OS, Compiler, Interpreter, Assembler etc
Features of application software and system software
Application s/w System s/w
Close to user / Close to systemEasy to design / Difficult to design
Easily understandable / Difficult to understand
Can manipulate and use / Difficult to manipulate
More interactive / Less interactive
Slow in speed / Fast in speed
High level language / Low level language
Large storage space / Small storage space
What is program
Set of instructions to solve problem
Define operating system with example.
It is a software that manages the computer hardware and software resources, provides services for computer programs. It is also called as resource manager. Its important and first software that runs in the system by the boot program and remains in the memory at all the time. Ex: windows7/8, redhat, MS Dos etc
Functions of OS
3 functions
Manages the computer resources(CPU, Memory, Diskdrives, Printers)
Establishes user interfaces
Executes and provides services for application software
What is windows
The rectangular portion of your screen that displays an open program or the contents of disk. We can open multiple windows at same time
Define the following:
1. WORD: a most powerful windows word processor.
2. EXCEL: a powerful and easy to use spread sheet application.
3. ACCESS: a true ROBMS[relation data base management system] for windows platforms.
4. POWER POINT: it is used for presentation. A presentation that allows anyone to create shows.
5. I.E.L: the latest of the popular internet browser.
6. OFFICE ART: a line drawing an art manipulation program.
7. CHART: a charting program.
8. CLIP GALLERY: program that helps you to organize all the clip art and other media objects such as audio and video clip.
9. SCROLL BARS: to move the display.
10. STATUS BARS: to keep your information of a operations progress on the current and the document.
11. COMMAND BAR: at both top and bottom of the screen the command bars are available to access all the program features.
12. MENU BAR: organizes the features into categories like file, edit, help etc
13. TOOL BAR: draws the graphical buttons located below the menu bar that is immediately at the bottom of the document window.
14. OFFICE ASSISTANT: it is the Microsoft of “social help interplax” of office 2000.
Types of computer
Desktop/Personal computer(PC)
Laptop
Mainframe
Workstations
Server
Wearable computers
Tablet
Super
What is booting
It’s the initial step as we turn on the system. It is a process or set of operations that loads and starts the OS
What is booting sequence
The booting process/ loading process which is done in sequence/ step by step/ one after the other is called as booting sequence
What is security
A protection given to files, data, resources etc. Only authorized users can gain access to these data.
Examples of i/o devices
Input devices
A) Graphics Tablets
B) Cameras
C) Video Capture Hardware
D) Trackballs
E) Barcode reader
F) Digital camera
G) Gamepad
H) Joystick
I) Keyboard
J) Microphone
K) MIDI keyboard
L)Mouse (pointing device)
Output devices
1)Monitor (LED, LCD, CRT etc)
2)Printers (all types)
3)Plotters
4)Projector
5)LCD Projection Panels
6)Computer Output Microfilm (COM)
7)Speaker(s)
8)Head Phone
Explain internal and external commands
External commands
MORE:-Using TYPE command we can see the content of any file. But if length of file is greater than 25 lines then remaining lines will scroll up. To overcome through this problem we uses MORE command. Using this command we can pause the display after each 25 lines.
MEM:-This command displays free and used amount of memory in the computer
SYS:-This command is used for copy system files to any disk. The disk having system files are known as Bootable Disk, which are used for booting the computer.
SYS:-This command is used for copy system files to any disk. The disk having system files are known as Bootable Disk, which are used for booting the computer.
XCOPY:-When we need to copy a directory instant of a file from one location to another the we uses xcopy command. This command is much faster than copy command.
MOVE:-Move command is used for moving one file or multiple files from one location to another location or from one disk to another disk.
FC:-(File Compare)This command is capable for comparing two set of files and display difference between two files.
CHKDSK:-(Check disk) -This command is used to check the status of a disk and show the report of result status.
Internalcommands
CLS:- (Clear the screen) This command is used to clear the screen or wipe out every thing written on the screen.
DIR:-(Directory) Dir command is used for listing files and directories present in the current disk.
VER:-(Version)Version numbers indicates that which edition of DOS we are working on.
VOL:-(Volume) Displays the disk volume label and serial number, if it exist.
DATE:-Display the current Date
TIME:-Display current time
What is internet
Internet is a massive network of networks, a networking infrastructure. It connects millions of computers together globally, forming a network in which any computer can communicate with any other computer as long as they are both connected to the Internet.
what do you mean by search engine
It enable users to search for documents on theWorld Wide Web. ex:Google, Bing and Yahoo!
What is browser
A browser is asoftware applicationused to locate, retrieve and display content on theWorld Wide Web, includingWeb pages, images, video and other files. It’s the interface between user and server.
What is memory and mention its types
The place where we store our data is memory. Ex: disks, files, folders, hard disk etc
Types of memory
Primary Memory / Volatile Memory:
Primary Memory also called as volatile memory because the memory can’t store the data permanently. Random Access Memory (RAM):The primary storage is referred to as random access memory (RAM) due to the random selection of memory locations. It performs both read and write operations on memory. If power failures happened in systems during memory access then you will lose your data permanently. So, RAM is volatile memory.
RAM categorized into following types.
DRAM
SRAM
DRDRAM
Secondary Memory / Non Volatile Memory:
Secondary memory is external and permanent memory that is useful to store the external storage media such as floppy disk, magnetic disks, magnetic tapes and etc cache devices. Secondary memory deals with following types of components.
Read Only Memory (ROM) :
ROM is permanent memory location that offer huge types of standards to save data. But it work with read only operation. No data lose happen whenever power failure occur during the ROM memory work in computers.
ROM memory has several models such names are following.
1.PROM:Programmable Read Only Memory (PROM)
2.EPROM :Erasable Programmable Read Only Memory
3.EEPROM:Electrically Erasable Programmable Read Only
4.Cache Memory:Main memory less than the access time of CPU(temporary storage area)
Basic physical components of computer
Monitor: which displays information
Mouse : pointing device, which places the cursor on the screen n points the data.
Keyboard: input is given from keyboard
Cpu: central processing unit, performs all functionalities and task of the system
What are the input and output devices
Printer - output.
Mouse - input.
Keyboard - input.
Monitor - output.
Web cam - input.
Scanner - input.
Graphics tablet - input or output (if there is a screen on it)
Joypad - input (output as well )
How to save a file
To save a copy of your file, do the following:
Click the Microsoft Office Button, and then click Save As, or press CTRL+S.
Important: If you don't see the Microsoft Office Button , click Save As on the File menu.
In the File name box, enter a new name for the file.
Click Save.
How to Create a folder
Type a name for the newfolder, and then press ENTER. To open My Documents, click Start, and then click My Documents. You can alsocreatea newfolderby right-clicking a blank area in afolderwindow or on the desktop, pointing to New, and then clickingFolder.
How many sheets in excel book
The default setting isthree sheets.
Excel 2010 does not have a specific maximum number of worksheets
what is e-mail?
Electronic mailis a method of exchanging digital messages between computer users
how many columns and rows in excel cell?
Max. Rows ColumnsExcel 2010 / 1,048,576 / 16,384
Excel 2007 / 1,048,576 / 16,384
Excel 2003 / 65,536 / 256
Excel 2002 (XP) / 65,536 / 256
/ 16,384
Xz cdc / 16,384
256
256