Fundamentals of Computer Systems

 

End Semester Examination
Title of the subject:  Fundamentals of Computer Systems BCA/B.Sc(IT)                                                                Subject code:
Duration: 3.00hrs			Max Marks: 100
Note: All questions are compulsory. Draw Figures wherever necessary. Write legibly on both sides of answer book.
	Section A[1 Marks Each]
1	Where as a computer mouse moves over the table surface, the trackball is       a. Stationary   b. Difficult to move     c. Dragged  d. Moved in small stems Ans:        a. Stationary
2	Which one of the following input device is user-programmable? a. Dumb terminal                      b. Smart terminal          c. VDT             d. intelligent terminal Ans:  d. intelligent terminal
3	How many options does a BINARY choice offer a. One            b. Two       c. it depends on the amount of memory on the computer d. It depends on the speed of the computer’s processor Ans:      b. Two
4	CD-ROM a. Is a semiconductor memory   b. Memory register        c. Magnetic memory     d. None of the above Ans: d. None of the above
5	Which of the following is not a primary storage device? a. Magnetic tape            b. Magnetic disk                        c. Optical disk     d. None of the above Ans: d. None of the above
6	1. With which of the following all formulas in excel starts? a.   /                    b.  *                   c.   $                           d.   = Ans: d
7	A floppy disk contains a. Circular tracks only   b. Sectors only  c. Both circular tracks and sectors          d. All of the above Ans:      c. Both circular tracks and sectors
8	Which of the following registers is loaded with the contents of the memory location pointed by the PC? a. Memory address register                    b. Memory data register             c. Instruction registers   d. Program counter       Ans: c. Instruction registers
9	The binary system, 1+1 =  _______ a.      2            b.   0           c.   1                 d.  none of these Ans: c
10.	The 2’s complement of 10002 is a.   0111         b.   0101       c.  1000              d. 0001 Ans:  c
	Section B[2 Marks Each]
1	What are the difference between hardware ,Software and Firmware? Ans: Hardware:-are the physical tangible components of a computer system. Software are the computer program that govern the operation of computers. Firmware :are the prewritten programs permanently stored in read only memeory.
2	Why analytical Engine often called the pioneer Computer? Ans:The analytical Engines was that first deign to introduce the basic architecture of modern computer. i.e. CPU,storage Area, memory and input output devices. Thus it is called the pioneer computer.
3	Give two major innovation in first generation computer . Ans: (1) Computer programs Stored in the computer memory (2) Vacuume tubes for internal operation.
4	Give two major advances of third generation Computers? Ans: (1)Integrated Circuitary (2) Faster input –output devices.
5	St ate the basic unit of computer .Name the subunits that make up the CPU ,and give the function of each of the units. Ans:1. Input Unit ,2.CPU,3.Output Unit ,4.Memory
	Section C[6 Marks Each]
1.	Explain  System  Bus . Ans: A system bus is a single computer bus that connects the major components of a computer system. The technique was developed to reduce costs and improve modularity.
2.	What are Secondary Storage devices? Draw the following diagram for classification of commonly used Secondary storage Device? Ans: Alternatively referred to as external memory and auxiliary storage, secondary storage is a storage medium that holds information until it is deleted or overwritten regardless if the computer has power. For example, a floppy disk drive and hard drive are both good examples of secondary storage devices. As can be seen by the picture below there are three different storage on a computer, although primary storage is accessed much faster than secondary storage because of the price and size limitations secondary storage is used with today's computers to store all your programs and your personal data.   Finally, although off-line storage could be considered secondary storage, we've separated these into their own category because this media can be removed from the computer and stored elsewhere.   Storage Device is a device for recording (storing) information (data). Recording can be done using virtually any form of energy.Storage device is a hardware device capable of storing information. There are two storage devices used in computers; a primary storage device such as computer RAM and a secondary storage device such as a computer hard disk drive. Primary Storage: - Primary storage is a storage location that holdsmemory for short periods of times while the computer is on. For example, computer RAM (random-access memory) and cache are both examples of a primary storage device. This type of storage is the fastest type of memory in your computer and is used to store data while it’s being used. For example, when you open a program data is moved from the secondary storage into the primary storage. It is also known as internal memory and main memory. Secondary Storage: - Secondary storage is a storage medium that holds information until it is deleted or overwritten regardless if the computer has power. For example, a floppy disk drive and hard disk drive are both good examples of secondary storage devices. As can be seen by the below picture there are three different types of storage on a computer, although primary storage is accessed much faster than secondary storage because of the price and size limitations secondary storage is used with today’s computers to store all your programs and your personal data.  It is also known as external memory and auxiliary storage.
3.	Differentiate between Program Control Register /Program Counter and Memory address Register. Ans:- The difference is that the program counter points to the next instruction to be fetched / executed , whereas the memory address register points to a memory location where the program being run will fetch some data (not an instruction).
4.	Write three difference between interpreter and compilers Ans:           Interpreter       Compiler Translates program one statement at a time. Scans the entire program and translates it as a whole into machine code. It takes less amount of time to analyze the source code but the overall execution time is slower. It takes large amount of time to analyze the source code but the overall execution time is comparatively faster. No intermediate object code is generated, hence are memory efficient. Generates intermediate object code which further requires linking, hence requires more memory. Continues translating the program until the first error is met, in which case it stops. Hence debugging is easy. It generates the error message only after scanning the whole program. Hence debugging is comparatively hard. Programming language like Python, Ruby uses interpreters. Programming language like C, C++ uses compilers.
5.	What is the use of following short cut keys a.      Ctrl + x             b. Alt +f          c. Ctrl+m             d. Ctrl+v     e.  Ctrl+A  Ans: a.      Ctrl +X: cut a text b.      Ctrl + m: insert new new slide c.      Alt+f: open file menu d.      Ctrl+v: Paste copied text e.      Ctrl+A: Select all page
	Section D[10 Marks Each]
1.	A .What is a Cache memory? How is it different from a primary memory? Explain how a Cache memory helps in improving the overall processing speed of a Computer System. Ans: Cache memory, also called CPU memory, is random access memory (RAM) that a computer microprocessor can access more quickly than it can access regular RAM. As the microprocessor processes data, it looks first in the cache memory and if it finds the data there (from a previous reading of data), it does not have to do the more time-consuming reading of data from larger memory.
2.	Explain Filter option in MS-EXCEL. Ans: For medium-to-large quantities of data, using Microsoft Excel’s AutoFilter is a quick and simple way to filter through that information and find what you need. Starting with inputting data, you'll then need to select and sort it, customizing the autofilter however you like. This 5-step process can be mastered in minutes, ultimately increasing your Excel efficacy and speed. 1.Input all of your data, or open the spreadsheet that contains all of your data.It is best that your data have column heading such as categories to specify the data below it. If you don’t already have these, input them before you filter. 2. Select all Data you wish to filter.: Because the AutoFilter option is an automatic process that does not receive any specific inputs on how to filter, it is recommended that you choose ‘’all’’ of the data you have. This will avoid the possibility that you lose data associations across rows and/or columns. 3. Click “Data” ,Then Select “Filter”. 4. You will immediately notice that the categories have drop-down buttons.Using these buttons, you can set your filter options. 5. You will immediately notice that the categories have drop-down buttons.Using these buttons, you can set your filter options.
3.	Write a short note on Number System. Ans:     When we type some letters or words, the computer translates them in numbers as computers can understand only numbers. A computer can understand positional number system where there are only a few symbols called digits and these symbols represent different values depending on the position they occupy in the number. A value of each digit in a number can be determined using ·      The digit ·      The position of the digit in the number ·      The base of the number system (where base is defined as the total number of digits available in the number system). Decimal Number System The number system that we use in our day-to-day life is the decimal number system. Decimal number system has base 10 as it uses 10 digits from 0 to 9. In decimal number system, the successive positions to the left of the decimal point represent units, tens, hundreds, thousands and so on.
4.	a. What is MS Excel? Write four features of Excel with its limit.  b. What are presentation tools? Give two examples. Write about three types of movements provides by power point. Ans: a.      MS Excel: Microsoft Excel is a spreadsheet application developed by Microsoft for Microsoft Windows and Mac OS. Features: Features Maximum Limits Column width 255 characters Row height 409 points Page breaks 1,026 horizontal and vertical Total number of characters that a cell can contain 32,767 characters Characters in a header or footer 255 Sheets in a workbook Limited by available memory (default is 1 sheet) Colors in a workbook 16 million colors (32 bit with full access to 24 bit color spectrum) Named views in a workbook Limited by available memory Unique cell formats/cell styles 64,000 Fill styles 256 Line weight and styles 256
	Presentation tools:  Presentation tools:  Presentation tools are used to enhance lectures, seminars, or other presentations. Some presentation tools, such as PowerPoint, Smart boards and Mind Maps may be used to add visual content to a presentation. Other tools, such as Clickers, allows for engagement between the audience and presenter during presentation. The three types of movements provides by power point are Entrance, emphasis, and exit of elements on a slide itself are controlled by what PowerPoint calls Custom Animations. Transitions, on the other hand, are movements between slides. These can be animated in a variety of ways. Custom animation can be used to create small story boards by animating pictures to enter, exit or move.
5.	Types of printers Below is a list of all the different computer printers. Today, the most common printers used with a computer are Inkjet and Laser printers. All-in-one (AIO) printer Dot Matrix printer Inkjet printer Laser printer Multifunction printer (MFP) Thermal printer LED printer    What is a Printer ? Differentiate between impact and non  -Impact Printers. Give their relative advantages and disadvantages. Name few printers of both types. Ans: A printer is an external hardware device responsible for taking computer data and generating a hard copy of that data. Printers are one of the most used peripherals on computers and are commonly used to print text, images, and photos. The picture is the Lexmark Z605 Inkjet printer and an example of a computer printer.