Sunday, May 26, 2013

Practice Questions for BCA D-I Examination Part-1

 Computer Basics
1. What is computer?
2. What is the main function of computer?
3. What is ENIAC?
4. What is meant by generation of computers?
5. Which generation of computers used vacuum tubes?
6. Which generation of computers made use of transistors?
7. What is IC?
8. How IC is different from transistor?
9. Which generation of computer made use of ICs?
10. What is SSI?
11. What is MSI?
12. What is LSI?
13. What is VLSI?
14. Which generation of computers made use of VLSI chips?
15. Modern computers belong to which generation?
16. In what way fifth generation computers will be different from fourth generation computers?
17. Which type of computer is called analog computer?
18. Which type of computer is called digital computer?
19. Which type of computer is called hybrid computer?
20. Give two examples of analog computers.
21. Give an example of digital computer.
22. Name any two hybrid computers.
23. Which types of computers are called microcomputers?
24. Personal computers fall into which category of computers?
25. Name any two computers, which fall into the category of microcomputers.
26. What is the difference between laptop computer and tablet PC?
27. What is mainframe?
28. What is the typical characteristic of supercomputer?
29. What makes supercomputer so fast?
30. Name any two supercomputers.
31. Name any three applications, which can only be performed on supercomputers.
32. What is computer hardware?
33. What is software?
34. Is floppy, hardware or software?
35. Hard disk that contains programs on it, is hardware or software?
36. Program on CD is hardware or software?
37. Rail reservation application is hardware or software?
38. What is firmware?
39. Give an example of firmware.
40. Differentiate between system software and application software.
41. Give two examples of system software.
42. Give two examples of application software.
43. What are device drivers?
44. Device drivers fall in which category of software?
45. What is the role of boot strap program in computer?
46. Define the term, data.
47. What is information?
48. Differentiate between data and information.
49. What is computer program?
50. Give example of data and information.
51. What role does software play in computer?
52. What is operating system?
53. Can computer work without software?
COMPUTER ORGANIZATION
54. Name 5 input devices of computer.
55. Name 4 output devices of computer.
56. Name 3 input-output devices.
57. What is the role of scanner in computer?
58. Which type of device is barcode reader?
59. What is MICR? What it is used for?
60. What type of device is mouse?
61. Mouse and keyboard, both are input devices, but what is the basic difference between them?
62. What is the difference between plotter and printer?
63. What is the basic difference between input units and input/output units of computer?
64. What is the basic difference between output units and input/output units of computer?
65. Among floppy, hard disk and CD, which medium possesses largest storage capacity?
66. What is the basic difference between floppy drive and hard disk?
67. What is the basic difference between CD and CD-R?
68. What is the basic difference between CD-R and CD-R/W?
69. Which type of devices are called sequential access devices?
70. Which type of devices are called random access devices?
71. Give an example of sequential access device.
72. Give an example of random access device.
73. Differentiate between the functioning of tension arm and vacuum column tape drives.
74. In which form, magnetic tape drive records data on tape drives.
75. Name all those units, which put together constitute Central Processing Unit (CPU).
76. What is the main role of memory in computer?
77. What is ROM?
78. How data is written in ROM?
79. Differentiate between PROM and EPROM.
80. Describe the role of RAM in computer?
81. Describe the role of cache memory in computer?
82. Why can't complete RAM be replaced by cache memory in computer?
83. Name the two units between which cache memory is placed within the computer.
84. Which unit in computer performs calculations?
85. What is ALU? What is its role in computer?
86. Give example of logical operations.
87. Which unit in computer performs logical operations?
88. Describe the role of Control Unit in computer.
89. Describe at least three characteristic of computer.
90. Which memory in computer is called temporary memory?
91. Which memory in computer is called permanent memory?
92. Differentiate between dot matrix printers and inkjet printers.
93. Which 4 colors are used in inkjet printers to generate other colors?
94. What is cartridge tape drive? What is its role?
95. Which unit controls data traffic within the computer?
96. Is CD drive an input unit or output unit?
OPERATING SYSTEM
97. What is operating system?
98. What is the role of operating system in computer?
99. Is operating system, computer hardware or software?
100. What is booting?
101. What is process management function? Which software performs this function in computer?
102. What is memory management function? Which software performs this function in computer?
103. What is information management function? Which software performs this function in computer?
104. What is device management function? Which software performs this function?
105. What is user interface? Which software provides user interface in computers?
106. What is Command Line Interface (CLI)?
107. What is Graphic User Interface (GUI)?
108. Name at least two operating systems, which provide command line interface, for working on computer.
109. Name at least two operating systems, which provide graphic user interface for working on computer.
110. Differentiate between object icons and program icons.
111. Differentiate between check boxes and radio buttons.
112. Describe any three essential features of operating system.
113. What is distributed computing?
114. Which type of operating system is called single user operating system?
115. Name any two operating systems that are single user operating system.
116. Which type of operating system is called multi user operating system?
117. Name any two operating systems, which are multi user operating systems.
118. Describe, time sharing feature.
119. Which type of operating systems support time sharing feature?
120. Name an operating system, which supports time sharing feature.
121. Describe multitasking feature?
122. Name at least two operating systems, which support multitasking feature.
123. Name an operating system, which doesn't support multitasking feature.
124. Name an operating system that doesn't support time sharing feature.
125. Describe at least 2 characteristics of single user operating system.
126. Which type of operating system is called network operating system?
127. Name two operating systems, which are network operating systems.
128. Name three essential files of MS-DOS operating system.
129. What is the role of IO.SYS file in MS-DOS operating system?
130. Which organization designed and developed MS-DOS operating system?
131. What is the role of MSDOS.SYS file in MS-DOS operating system?
132. What is the role of COMMAND.COM file in MS-DOS operating system?
133. Which types of commands are called internal commands of MS-DOS?
134. Which file of MS-DOS contains internal commands?
135. Name any three internal commands of MS-DOS.
136. What are external commands of MS-DOS? Where do they reside?
137. Name any two external commands of MS-DOS.
138. Out of internal command and external command, which will execute faster and why?
139. How long can a file name be in MS-DOS?
140. What is directory? How it is different from file?
141. You can always have a directory within a directory. How deep can you go in this way?
142. Can a file have a directory stored in it?
143. What is root directory? Which symbol is used for denoting root directory in MSDOS?
144. What is parent directory? Which symbol is used for denoting parent directory in MSDOS?
145. Name any three directory related MS-DOS commands.
146. Name a command of MS-DOS, which creates a blank directory on the disk.
147. Name a command of MS-DOS, using which name of the directory could be changed.
148. Name a command, using which the name of current directory could be displayed on monitor.
149. Explain the concept of path in MS-DOS.
150. Which command will you use to display the contents of a file?
151. Which command will you execute in MS-DOS to find the presence of ABC.DAT file on disk?
152. Can you rename the files across the drivers in MS-DOS? If yes then what command will you execute?
153. What is the basic difference between SYS command and FORMAT A: /S command?
154. What are the similarities between SYS command and FORMAT A: /S command?
155. How will you delete a directory, which is not blank?
156. What are wild characters? Name any two wild card characters that are used in MSDOS.
157. Explain drag and drop feature of Windows.
158. Explain cut, copy and paste feature of Windows.
159. Explain object embedding feature of Windows.
160. Explain object linking feature of Windows.
161. Differentiate between object embedding and object linking.
162. What are the advantages of object linking over object embedding?
163. Describe the feature plug and play of Windows.
164. What does command prompt feature do in Windows?
165. What is the use of Notepad program in Windows?
166. What is the use of WordPad program in Windows?
167. What is the use of Paint program in Windows?
168. What is the use of Windows Explorer program?
169. Which version of Windows is network operating system?
170. What is Linux? Who designed it?
171. Which command is used for viewing the names of files, present on the disk?
172. What activity is performed by who command in Linux?
173. What do you call the process of loading the operating system in computer's memory?
174. Can a computer work, without operating system?
175. Where will you find operating system in computer?
176. What is Windows NT?
177. Differentiate between Windows NT and Windows XP.
178. Differentiate between Notepad and WordPad programs of Windows.
179. How Windows file naming convention is different from MS-DOS file naming convention?
180. Can you have blank in MS-DOS file name?
181. Can you have blank in Windows file name?
182. What is folder?
183. What is folder equivalent in MS-DOS?
COMPUTER NETWORKING
184. Define the term computer network?
185. What is the basic objective of computer network?
186. State any three reasons for computer networking.
187. Describe any three applications, which make use of computer network.
188. Describe two advantages of computer networking.
189. Describe an application, which is only possible through computer network and cannot be performed by stand-alone computer.
190. What is LAN?
191. Which types of networks are called local area networks?
192. Which types of networks are called wide area networks?
193. State any two characteristics of local area network.
194. State any two characteristics of wide area network.
195. What is the basic deference between LAN and WAN?
196. What is CAN? Is it LAN or WAN?
197. What is MAN? Is it LAN or WAN?
198. What is HAN? Is it LAN or WAN?
199. What is network topology?
200. How many types of network topologies are commonly used?
201. What is the basic characteristic of Bus topology?
202. What are the advantages of Bus topology?
203. What are the disadvantages of Bus topology?
204. What is the basic characteristic of Ring topology?
205. What are the advantages of Ring topology?
206. What are the disadvantages of Ring topology?
207. What is the basic characteristic of Star topology?
208. What are the advantages of Star topology?
209. What are the disadvantages of Star topology?
210. What is the basic characteristic of Mesh topology?
211. What are the advantages of Mesh topology?
212. What are the disadvantages of Mesh topology?
213. Which topology makes use of hub for connecting the computers of the network?
214. Ten computers are to be networked together. In which topology, maximum length of wire will be used for connecting the computers?
215. Ten computers are to be networked together. In which topology, minimum length of wire will be used for connecting the computers?
216. In which topology, network expansion will be the easiest?
217. Which factor will govern the maximum number of computers that can be connected in Star topology?
218. Which topology makes use of the device called terminator?
219. Which topology makes use of the device called repeater?
220. What is the role of sender in computer network?
221. What is the role of receiver in computer network?
222. What is the role of medium in computer network?
223. What is non-wired medium? Give example of it.
224. Name 3 wired medium that are used in computer networks.
225. In which wired medium data is transmitted through light?
226. Which wired medium support fastest data transfer rates?
227. What is protocol? Name any two protocols of computer network.
228. What is per-to-per network?
229. What is client server mode?
230. What system is used for identifying the computers of network?
231. What is IP address? What is it used for?
232. What is domain name? What it is used for?
233. What is DNS server? What it deals with?
234. What is SMTP? What is its use?
235. What is Telnet? What is it used for?
236. What is FTP? What is it used for?
237. What is NFS? What it deals with?
238. What is web service? How it is related with computer network?
239. Explain the role of Finger service in computer network.
240. What does Ping service do?
241. What is SAMBA? What it deals with?
242. What is OSI model? How many layers of services constitute OSI model?
243. Name the first layer of OSI model. What it deals with?
244. Name the second layer of OSI model. What it deals with?
245. Name the third layer of OSI model. What it deals with?
246. Name the fourth layer of OSI model. What it deals with?
247. Name the fifth layer of OSI model. What it deals with?
248. Name the sixth layer of OSI model. What it deals with?
249. Name the seventh layer of OSI model. What it deals with?
250. Which type of signals are called analog signals?
251. Which type of signals are called digital signals?
252. Define the term amplitude, frequency and phase for analog signal.
253. How is analog signal different from digital signal?
254. What function is performed by A to D converter?
255. What function is performed by D to A converter?
256. Explain the term damping.
257. Out of analog and digital, which signal gets damped earlier?
258. Explain the role of modem in computer network?
259. Explain the basic theory behind analog to digital conversion process.
260. What activity is performed in sampling process that is performed at the time of converting analog signal into digital signal?
261. What activity is performed in quantization process that is performed at the time of converting analog signal into digital signal?
262. What is the basic characteristic of asynchronous transmission?
263. What is the basic characteristic of synchronous transmission?
264. What is the basic characteristic of simplex mode of transmission?
265. What is the basic characteristic of half duplex mode of transmission?
266. What is the basic characteristic of full duplex mode of transmission?
267. Out of serial transmission and parallel transmission, which transmission will be faster and why?
268. Out of serial transmission and parallel transmission, which transmission suits well for long distances and why?
269. What are the advantages of transmitting data in digital from?
270. What is Internet?
271. Differentiate between Internet and World Wide Web.
272. What are web servers and web clients?
273. How computers are identified in Internet?
274. What is ARPANET?
275. Explain domain naming convention that is followed in Internet.
276. What is web page?
277. What is web site?
278. What is hyper link? How are they generally identified in web pages?
279. What is hypermedia?
280. What is TCP/IP?
281. What types of actives are performed by TCP in TCP/IP software?
282. What types of actives are performed by IP in TCP/IP software?
283. What is HTTP?
284. Which protocol is used in World Wide Web to support multimedia activities?
285. Name any two applications of Internet.
286. What is web surfing or web browsing?
287. Name any three web sites, which provide search engines.
288. State two advantages of e-mail over normal mail.
289. What is Internet shopping?
290. What mechanism is adopted for making payments over Internet?
291. How is video conferencing different from Internet telephony?
292. Why protocols are required in network communication?
293. What is search term?
294. What is hit list?
295. What is IPX/SPX? Where it is used?
296. What is NetBIOS/NetBEUI, where it is used?
297. What is HTTP? Where it is used?
298. Which types of computers generally remain connected to Internet all the 24 hours a day?
299. In which process, sampling and quantization activities are performed?
300. In which from, i.e. analog or digital, voice signal is transmitted over telephone line?
301. In which from, i.e. analog or digital, data is generated and stored within the computer?
302. In which from i.e. analog or digital, data is transmitted over telephone lines?
WINDOWS
303. What is Windows?
304. Who designed and developed Windows?
305. How is Windows different from MS-DOS?
306. How will you minimize a window?
307. What happens when you minimize a window?
308. How will you restore a minimized window?
309. How will you maximize a window?
310. What happens when you maximize a window?
311. How will you restore a maximized window?
312. How will you move a window?
313. How will you increase the length of a window?
314. How will you increase the width of a window?
315. How will you increase/decrease the size of the window in proportion?
316. Using which program of Windows, will you make drawings?
317. Which program of Windows will you use for file maintenance purpose?
318. What is desktop?
319. Where on desktop, will you find system tray?
320. How do you execute a program by its name in Windows?
321. State different methods of executing programs in Windows.
322. What is task bar, where it is situated?
323. What is screen saver? Why it is used?
324. How will you create a new folder on desktop?
MS-WORD
325. What is word processor?
326. What is data processing?
327. How is word processing different from data processing?
328. Name any two word processors.
329. Which type of activity is performed using word processor?
330. How do you set left margin in MS-Word?
331. What function is performed, using hanging indent marker of MS-Word?
332. What function is performed, using first line indent marker in MS-Word?
333. How will you set tab position in MS-Word?
334. Where will you find left margin and right margin indicators in MS-Word window?
335. How do you start a new paragraph in MS-Word?
336. How will you save the current document in file?
337. What happens if you left align a paragraph?
338. What happens if you right align a paragraph?
339. What happens if you centre align a paragraph?
340. What happens if you justify align a paragraph?
341. How will you copy first three lines of the current document to some other place?
342. How will you move first three lines of the current document to some another place?
343. What is the basic difference between copy and move operation?
344. Which two options will you select from Edit submenu to perform copy operation?
345. Which two options will you select from Edit submenu to perform move operation?
346. What is the basic difference between number list and bullet list?
347. Define the term header and footer for the document.
348. Differentiate between hard page breaks and soft page breaks.
349. What is on-line spell checker? What function is performed by it?
350. How will you correct a wrong spelling, using on-line spell checker?
351. In what from does spell checker indicate that this spelling in wrong?
352. In what form does, grammar check indicate that this sentence is grammatically wrong?
353. What is Mail Merge?
354. Which type of activity is performed, using mail merge facility of MS-Word?
355. Name any three activities, which can be easily performed, using mail merge facility of MS-Word.
356. Explain the basic principle of Mail Merge operation.
357. Describe the term, main document in relation to mail merge operation.
358. Describe the term data source, in relation to mail merge operation.
359. How field names are differentiated from text in main document?
360. How is mail merge operation different from normal letter generation?
361. What extension name is assigned to MS-Word files?
MS-EXCEL
362. What is worksheet?
363. What is workbook?
364. Differentiate between worksheet and workbook?
365. Name any two worksheet softwares.
366. What is MS-Excel?
367. Who designed and developed MS-Excel?
368. Which type of activities are performed using MS-Excel?
369. Name any two activities that can be performed, using MS-Excel.
370. Describe any two features of MS-Excel.
371. What is cell?
372. How are rows named in MS-Excel?
373. How are columns named in MS-Excel?
374. What does cell address E7 state?
375. How do you move from one cell to another in MS-Excel worksheet?
376. How do you move from one worksheet to another in MS-Excel?
377. How are formulae differentiated from normal text in MS-Excel?
378. How do you enter data and time values in same cell?
379. Give an example of numeric formula.
380. Give an example of logical formula.
381. Give an example of text formula.
382. What is the advantage of using formulae in workbook?
383. Which symbol is used for Range operator in MS-Excel?
384. Which symbol is used for Union operator in MS-Excel?
385. Which symbol is used for Intersection operator in MS-Excel?
386. What is the function of Range operator?
387. What is the function of Union operator?
388. What is the function of Intersection operator?
389. What is meant by cell referencing?
390. How is relative referencing done in MS-Excel?
391. Write a formula that makes use of relative referencing?
392. How absolute referencing is done in MS-Excel?
393. Write a formula that makes use of absolute referencing?
394. What is meant by mixed referencing?
395. How mixed referencing is done in MS-Excel?
396. Write a formula that makes use of mixed referencing.
397. How will you generate the series 10, 11, 12, 13, -----------25 in MS-Excel?
398. How do you select cells in MS-Excel?
399. How do you modify the contents of a cell, in cell itself, not in formula bar?
400. How will you copy the contents of a cell to another cell, using drag and drop method?
401. How will you copy the contents of a cell to another cell, using cut, copy, and paste method?
402. How will you move the contents of a cell to another cell, using drag and drop method?
403. How will you move the contents of a cell to another cell, using cut, copy and paste method?
404. Cell E5 contains a formula =SUM (E1:E4). What will be the contents of cell E6, when you copy the formula from E5 to E6?
405. Cell E5 contains a formula =SUM ($E1:$E4). What will be the contents of cell E6, when you copy the formula from E5 to E6?
406. Cell E5 contains a formula =SUM ($E1:$E4). What will be the contents of cell E7, when you copy the formula from E5 to E7?
407. Cell E5 contains a formula =SUM ($E$1:$E$4). What will be the contents of cell E6, when you copy the formula from E5 to E6?
408. Cell E5 contains a formula =SUM ($E$1:$E$4). What will the contents of cell E7, when you copy the formula from E5 to E7?
409. If you do not set alignment for cells, how will numbers, labels and formulae get aligned, when you enter them in the cells?
410. What is function in reference to MS-Excel? How it is different from the formula that we define?
411. What will you get in cell C5, if you enter the formula =LEN ("DELHI") in it?
412. What will you get in cell C5, if you enter the formula =LEFT ("LUCKNOW",4) in it?
413. What will you get in cell C5, if you enter the formula =UPPER ("How Are You") in it?
414. What will you get in cell C5, if you enter the formula =REPT ("*",10) in it?
415. Which option will you select from bar menu to print the worksheet?
416. What is chart? What are its advantages?
417. Name any 5 charts that can be made in MS-Excel.
418. Name any 2 charts of MS-Excel that are circular in shapes.
419. What is the basic difference between Pie chart and Doughnut chart?
420. What is the basic difference between Column chart and Bar chart?
421. What is the basic difference between Line chart and XY chart?
422. What will happen to the data in worksheet, if you select a column of the column chart and drag it upwards?
423. How will you select the legend of the chart?
424. Which chart will you plot, to illustrate and compare the sales figures of three companies for three quarters of the year?
425. Which chart will you plot to illustrate the percentage wise contribution of five religions in the total population of the city?
426. How will you delete a chart?
427. How will you copy a chart from one worksheet to other worksheet of the same workbook?
428. Which chart will you plot to illustrate the rainfall that took place in last 12 months in Chennai?
429. What is data series? Give an example.
430. What is legend? What is its role in chart?
POWER POINT
431. What is PowerPoint?
432. Who designed and developed PowerPoint?
433. What is presentation?
434. For which type of activities PowerPoint suits well?
435. What is PowerPoint slide?
436. Differentiate between manual presentation and PowerPoint presentation.
437. Name any four elements that can be included in PowerPoint slides.
438. What is slide show?
439. Differentiate between manual slide show and automatic slide show.
440. What is the purpose of including notes in the slides of the presentation?
441. What is slide timing?
442. In which type of slide show, slide timings become effective?
443. How the slides of the presentation advance, in automatic slide shows?
444. How the slides of the presentation advance, in manual slide shows?
445. What happens when you switchover from current view mode to slide sorter view mode?
446. What happens, when you switchover from slide sorter view mode to normal view mode?
447. How do you switchover from one view mode to another in PowerPoint?
448. What is WordArt? What type of activities are performed using WordArt?
449. Differentiate between video and animation?
450. What is transition effect?
INTERNET
451. What is Internet?
452. How Internet is different from computer network?
453. What is the basic objective of Internet?
454. Which types of computers remain connected to Internet all the 24 hours a day?
455. What do you call those computers, which only acquire services from web servers?
456. What is the basic function of web server in Internet?
457. What is basic function of web client in Internet?
458. How are web servers different from web clients?
459. What is www? How it is related to Internet?
460. What is e-mail?
461. Is it necessary that person to whom e-mail is being sent should have an e-mail account?
462. What does ".com" in website name indicate?
463. What does ".in" in website name indicate?
464. What is yahoo.com?
465. What is google.com?
466. What is search engine?
467. Name any three websites, which provide search facility.
468. Why two search engines produce two different results for same search term?
469. What is web browsing? Is if different from web surfing?
470. What is web browser?
471. Name any three famous web browsers.
472. When does "Forward" button of your web browser become activated?
473. What is the use of "Back" button, present in browser window?
474. Which software is required for web surfing?
475. What is the use of Draft folder that you have in your e-mail account?
476. What is the use of Inbox folder that you have in your e-mail account?
477. What is the use of Trash folder that you have in your e-mail account?
478. What is the use of Sent folder that you have in your e-mail account?
479. How is Chat service different from Internet telephony?
480. Name any two websites, which provide e-mail facility.
481. Describe two advantages of Internet.
482. Name any five services of Internet.
483. What is the basic difference between IP address and domain name?
484. How many groups of numbers constitute IP address?
485. Why domain name is preferred over IP address in most of the Internet operations?
486. Name the service, which transforms domain name into corresponding IP address.
487. Is Internet LAN, WAN or MAN?
488. Name any two protocols that are closely associated with Internet or World Wide
Web
489. What is the relationship between web page and website?
490. What is HTML?
491. What is HTTP?
492. Describe the advantages of hyperlink.
493. What is the basic advantage of Internet telephony?
494. Differentiate between hyperlink and hypermedia?
495. Name two Indian web sites.
496. What is ISP?
497. What is gateway?
498. Explain the term, backbone in reference to Internet.
499. What is Internet2?
500. Which additional device would be required to connect your computer to Internet?