Computer science important mcq | Questions & Answers 2023 Latest Update

Computer science important mcq | Questions & Answers 2023 Latest UpdateComputer science important mcq 1. how can you open a link in new tab/browser window ? a. <a href ="url"target ="new"> b. <a href ="url"target ="blank"> c. <a href ="url"new" d. none of above 2. how can you insert header and footer in ms-word document ? a. double clicking on header and footer area b. using insert >header/footer menu c. both a& b d. none of the above 3. how can you display the related records from other tables in a datasheet view? a. apply filter by command to display related record b. click on the expand indicator next to the record c. double click on the record to export it d. all of the above 4. which of the following term lists the specific information to be inserted in document? a. main document b. data source c. mail merge d. merge field 5. which of the following network topologies can be considered as multipoint topology? a. star b. bus c. mesh d. ring 6. we can makes use of the wild card entries such as…… in windows explores. a. .#.@ b. ^,* c. ?,* d. ?,# 7. A page fault occurs a. when the page is not in the memory b. when page is in the memory c. when the process enters the blocked d. when thee process is in ready state 8. in the relational models, cardinality is termed as Computer science important mcq a. number of tuples b. number of attributes c. number of tables d. number of constraints 9. the principle of locality of reference justifies the use of a. virtual memory b. interrupts c. main memory d. cache memory rs are stored and transmitted inside a computer in a. binary form b. ASCII form c. decimal form d. Alphanumeric form 11.Format command is used to a. prepare a black disk b. create a new blank disk from a used one c. both of above d. none of the above of the following options is not available to remove arrows of formula auditing ? a. remove precedent arrows b. remove dependent arrows c. remove all arrows d. remove all arrows for this cell 13. what term refers to a specific set of values saved with the workbook ? a. range b. scenario c. trend line d. what-if-analysis of the following extends a private network across public network ? a. LAN b. VPN c. EPN d. SAN 15.In a relational schema, each tuple is divided into fields called? a. relations b. domains c. queries Computer science important mcq d. all of the above is a motion path ? a. a type of animation entrance effect b. a method of advancing on a slide c. a method of moving item on a slide d. all of the above 17.…… Transforms one interface into another interface . a. program b. software c. data d. none 18. when inserting page number in footer it appeared 1 but you wish to show (a) how can you dothat? a. from format menu choose bullets and numbering and configure necessary setting b. from insert menu choose page number and specify necessary setting c. click on page number format tool and specify required setting d. all of the above of the connector is used to plug a telephone line into a modem a. com1 b. RJ-45 c. RJ-11 d. RJ-10 20.MSD.exe does not have information on: a. cache b. video c. operating system d. com or port 21.a world wide web contains web pages: a. residing in many computer linked together using html b. residing in may computer c. created using html d. with links to other web pages 22.…. Presents data in way similar to and excel spreadsheet. a. layout preview b. datasheet view c. design vies d. print preview 23. A DBMS allows you to create and maintain a database, create reports, and develop applicationprograms, select the best fit answer: Computer science important mcq a. query language b. database management approach c. DBBMS Uses d. database administrator merge is concerned with : a. to split main document b. combining main document with data file c. sending a typed letter to share holder of a company d. none of the above merge is used to a. combine two mails and create a word document b. combine static information in one document with variable information in another document c. combine mail in outlook express with word document d. combine static contents of two documents 26.Graphical representation of worksheet data a. pivot table b. Goal seek c. Graph d. Scenario 27.The formula =If(x1>y1,x1-y1,y1-x1> gives a. larger one from cell x1 and y1 b. Positive difference of x1 and y1 c. contents of a1 d. contents of y1 28. two tables can be linked with relationship so that the data integrity can be enforced. Where canyou find relationship command ? a. file menu b. view menu c. database menu d. tools menu 29.In MS windows to cycle through programs currently running. One can use a. SHIFT+TAB b. CTRL+TAB c. ALT+TAB d. Tab copy the hidden system files of DOS to another disk, you can use the command a. copy b. sys Computer science important mcq c. ren d. Diskcopy command is used to confirm before the directory before deleting the directory ? a. deltreee b. del*.*/p c. deltree/f d. erase command is used to display a list of deleted files that DOS can Undelete ? a. Undelete*.* b. Undelete/list c. undelete/all d. none of the above 33.What is the shortcut key to display field codes? a. alt+f9 b. shift+f9 c. ctrl+f9 d. space+f9 34.Chart type to visually compare values across of few categories is? a. Pie b. column c. row d. Cell 35.Electronic spreadsheet is also known as a. Data processor b. word processor c. presentation package d. none of the above 36. How do you protect your excel Sheet ? a. tool-option-password b. tool>protection>protect sheet>password c. Both A&B d. none of the above booting how many types of system files will load into RAM ? a. 2 b. 3 c. 4 d. 1 Computer science important mcq 38. what flavor of network address translation can be used to have one ip address allow many users to connect to global internet ? a. NAT b. static c. dynamic d. PAT 39. What are thee two main types of access control lists (ACLS)? ard , 2. IEEE, 3.Extended ,alized a. 1 and 2 b. 2 and 4 c. 3 and 4 d. 1 and 3 40. A ....is not attached to and edge of the word window . That is, it displays in the middle of the word window and can be moved anywhere in the window ? a. floating toolbar b. scroll bar c. status toolbar d. menu bar 41. Ram is also called as a. read/write memory b. long memory c. permanent memory d. primary memory 42. Information on a hard disk is usually backed using a a. CD-ROM b. Magnetic tape c. Floppy disk d. all of the above 43. … is the measurement of things such as fingerprints and retinal scans used for security access . a. Biometrics b. Bio measurement c. computer security d. smart weapon machinery 44. which network is a packet switching network? a. ring network b. LAN Computer science important mcq c. star network d. EuroNET 45. which of the following features should you use when typing in the notes text box? a. slide show b. insert c. slide master d. Zoom 46. which of the following contains permanent data and gets updated during the processing of transactions? a. operating system file b. transaction file c. software file d. Master file 47. It is an association established between common field is a. line b. relationship c. primary key d. record 48. the button which perform the specific task in presentation like hyperlink, open program , next slide, first slide and last slide etc . a. command button b. macro button c. slide show button d. action button 49. when creating a new table which method can be used to choose fields from standard database and tables? a. create table in design view b. create table using wizard c. create table by entering data d. none of above 50. to create relationship between two tables a. drag the primary key of a table into foreign key of another table b. do not enter a value in the primary key field of child table if that value does not exist c. do not enter a value In the foreign key field of a parent table if that value does not exist in d. all of the above 51. which of the following is not report section ? a. header and footer b. report footer c. page footer Computer science important mcq d. detail section 52. information currently stored in the database is called…. a. instance b. record c. data d. files 53. question can be raised in mas access by using….. a. queries b. form c. report d. find 54. In ms access column are technically called a. record b. attributes c. tuples d. field 55. ….. is a interface between user and the various database a. application programmer b. DB Administers c. DBMS d. all of these 56. …….. Requires that data should be made available to only authorized users. a. security b. data integrity c. privacy d. none 57. which command is used to copy file form floppy disk to hard disk? a. copy a: c: b. copy c: a: c. copy a:c: d. none of the above 58. The master list of an indexed file a. it can contain text and data b. contains only a list of keys and record c. has a number assigned to each record d. all of the above 59. the following are functions are functions of a DBMS except a. creating and processing forms b. creating database c. processing data d. administrating database Computer science important mcq 60. this task pane shows the design that is currently being used in a presentation a. slide style b. slide design c. slide format d. slide show 61. which of the following is the iso 8601 date format …..? a. yyyy/mm/dd b. dd/mm/yyyy c. mm/dd/yyyy d. yyyy/dd/mm 62. you can convert existing excel worksheet data and charts to HTML document by using the ? a. internet assistant wizard b. intranet wizard c. import wizard d. export wizard 63. DNS database contains a. name server records b. hostname-to-address record c. hostname aliases d. all of the above 64. ….. operators is used to compare a value to similar values using wildcard operator a. like b. compare c. between d. in 65. a communication pathway that transfers data from one point to another is called ? a. link b. node c. medium d. topology 66. withis a quality management technique that translates the needs of the customer into technical requirements for software? a. system requirement specification b. quality function deployment c. prototyping d. all 67. what are the two main types of indexes in SQL indexing ? a. Main, devoid b. syntax, non-syntax c. server, non-server Computer science important mcq d. clustered , non-clustered 68. the last address of IP address represent is a. unicast address b. multicast address c. broadcast address d. network address 69. which of the following is not a part of the control panel ? a. date and time b. my document c. add or remove program d. display 70. the search tool cannot be used on which major access object ? a. forms b. queries c. reports d. tables 71. the ….. is a wild card that represent one or more character . a. question mark b. asterisk c. exclamation mark d. dollar sign 72. a …. is a major database object used o display information in an attractive, easy-to-read screen format . a. form b. query c. report d. table 73. which is used to keep track of information, its location and status ? a. memory management b. device management c. storage management d. both a and b 74. while working with ms-dos which key is used to get the previous command used ? a. f1 b. f5 c. f3 d. f9 75. which is valid extension that user creates on operating system Computer science important mcq a. com b. bat c. sys d. exe 76. what is the first process lunched by the Linux kernel ? a. boot process b. init process c. batch process d. Zombie process 77. what else is a command interpreter called? a. prompt b. kernel c. shell d. command 78. the size of virtual memory is based on which of the following ? a. cpu b. RAM c. Address bus d. Data bus 79. to avoid the race condition , the number of processes that may be simultaneously inside their critical section is . a. 8 b. 1 c. 16 d. 0 80. a system program that combines the separately complied modules of a program into a from suitable for execution ? a. assembler b. linking loader c. cross complier d. load and go 81. what is the name of the operating system for the laptop computer called Maclite ? a. windows b. dos c. ms-dos d. OZ 82. what is the name given to the values that are automatically provided by software to reduce keystrokes and improve a computer user's productivity ? a. defined values b. fixed values c. default value Computer science important mcq d. special value 83. in which mode the effective address of the operand is the contents of a register specified in the instruction and after accessing the operand the contents of this register is incremented to point to point to the next item in the list ? a. index addressing b. indirect addressing c. auto increment d. auto decrement 84. Resolution of externally defined symbols is performed by a. linker b. loader c. compiler d. assembler 85. The register or main memory location which contains the effective address of the operand is knows as . a. pointer b. indexed register c. special location d. scratch pad 86. Which of the following rules out the use of Go to ? a. flowchart b. HIPO-DIAGRAM c. Nassi=Shneiderman diagram d. all of the above 87. Inter process communication a. is required for all processes b. is usually done via disk drives c. is never necessary d. allows processes to synchronize activity 88. which of the following addressing mode. facilitates access to an operand whose location is defined relative to the beginning of the data structure in which it appears ? a. ascending b. sorting c. index d. indirect 89. which of the following systems software does the job of merging the record from two files into one ? a. security software b. utility program c. networking software Computer science important mcq d. documentation system 90. fork is a. the dispatching of a task b. the creation of a new job c. the creation of the new processes d. increasing the priority of a task 91. Addressing structure a. a define the fundamental method of determining effective operand address b. are variations in the use of fundamental addressing structures. or some associated actions which are related to addressing c. performs indicated operations on two fast registers of the machine and leave the result in one of the registers. d. all of the above 92. A sequence of instructions , in a computer language to get the desired result is known as. a. algorithm b. decision table c. program d. all of the above 93. Information in a memory that is no longer valid or wanted is known as a. non volatile b. volatile c. surplus d. garbage 94. Banker's algorithm for resource allocation deals with a. deadlock prevention b. deadlock avoidance c. deadlock recovery d. mutual exclusion 95. An instruction is a programming language that is replaced by a sequence of instruction prior assembly or compiling is knows as . a. procedure name b. macro c. label d. literal 96. a teletype printer is a. teletype writer b. teletype c. TTY d. all of the above 97. which of the following malicious program do not replicate automatically ? Computer science important mcq a. Trojan horse b. virus c. worm d. zomble 98. the command allows you to create logical drive a. sort b. path c. subst d. Batch 99. the greater than sign(<> is an example of …… operator. a. arithmetic b. logical c. conditional d. greater 100. what type of chart is useful for comparing parts of a whole ? a. pie chart b. column chart c. line chart d. dot graph 101. which of the following class used 8 bits for and 24 bits for portion of the ip address ? a. class A b. Class b c. class c d. class d 102. A form can be used a. data entry b. switchboard c. custom dialog box d. all of the above 103. It is acceptable to let long text flow into adjacent cells on a worksheet when a. data will be entered in the adjacent b. no data will be entered in the adjacent c. there is no suitable abbreviation for the text d. there not time to format the text 104. If particular workbook have to open each time excel started, where that workbook should be placed ? a. autoexec folder b. AUTOSTART FOLDER c. EXCELSTART FOLDER Computer science important mcq d. XLSTART FOLDER 105. in MS-excel the following setup options can not be set in the page setup dialog box? a. printer selection b. vertical or horizontal placement c. orientation d. row and column titles 106. where is the memory controller located in a core 2 duo system a. on the cpu b. on memory c. within the chipset d. within the PCLe controller 107. which of the following contains permanent data and gets update during the processing the processing of transactions? a. operating system file b. transcription file c. software file d. master file 108. example of computer font width is a. bold b. 12 pt c. Helvetica d. italic 109. to back up an IOS, what command will you use? a. backup ios disk b. copy iostftp c. copy tftp flash d. copy flash tftp 110. which of the following allows a router to respond to on ARP request that is intended for a remote host ? a. gateway DP b. Reverse ARP(RARP) c. Proxy ARP d. Inverse ARP (IARP) 111. which command is used to remove the non-empty directory ? a. rd b. del c. erase d. deltree 112. The shortcut key ctrl+esc is used to Computer science important mcq a. cancel the windows b. open the taskbar c. open start menu d. start task manager 113. In a document with highlighted changes turned on, how does the inserted text appears :Underlined 114. number of bits in ALU IS A. 4 B. 8 C. 12 D. 16 115. which of the following is fourth generation computer ? a. pdp-8 b. mark-ii c. univia II d. dec 10 116. the first time android OS developed in a. 2005 b. 2006 c. 2008 d. 2012 117. ctrl+shift+c performs which of the following function . a. apply copied formatting to other text b. copy formatting from given block of text c. insert copyright sybol d. all of the above 118. single spacing in ms-word document causes ……. point line spacing ? a. 10 b. 12 c. 14 d. 16 119. The feature of word which enable you to navigate the long document through small picture of each page a. document map b. thumbnail c. Outline d. Bookmark 120. We can apply R1C1 reference style from Computer science important mcq a. toolbar b. from ribbon c. option from office buttion d. page layout tab 121. which of the following pane is not available in task pane ? a. slide design b. master slide c. slide layout d. slide transition 122. the size of a field with number data type can not be a. 2 b. 4 c. 8 d. 16 123. first webpage developed in a. 1981 b. 1990 c. 1991 d. 1995 124. When sharing data if office , the …… document is the document in which the data was first enter ? a. source b. destination c. original d. primary 125. Which of the following is true regarding page orientation of a document ? a. a page orientation can be changed at any time b. page orientation of document determines by printer c. page orientation must be set before start typing d. page orientation of a document cannot be change 126. ……. formatting is the process of changing the way letters, numbers, punctuation marks , and symbols appear on the screen and in print a. document b. character c. paragraph d. object 127. what is the main advantage of selecting 64-bit operating system over a 32-bit operating system ? a. the ability to use software based data execution prevention (DEP) b. the ability use unsigned drivers c. the ability to access more than 4 GB RAM Computer science important mcq d. the ability to run multiple 16-bit of programs in separate memory space 128. what should be types on pages of print window to print last 5 pages of the 15 pages document ? a. 11- b. 11,12,13,14,15 c. 11,15 d. all of the above 129. you have pasted a copied set of cells from one workbook into another using the 'No border" paste special functions. which boarders are removed ? a. top and button b. only the intermediate boarders c. all borders including the intermediate and surrounding boarders d. all except the intermediate boarders 130. what type of chart is good for single series of data ? a. column chart b. line chart c. pie chart d. cone chart 131. You have selected column D and E. you want to hide them. Which button on the Home tab in Ribbon bar of Excel 2007 will present you with the option for the same ? a. format b. Delete c. Insert d. Edit 132. Which of the following views displays the field name , description and properties of a table ? a. datasheet view b. design view c. layout view d. table view 133. what are the respective functions of the two corona wires in a printer a. clean the drum b. fuse the toner to the paper c. transfer toner from the drum to the paper d. none of the above 134. in electronic transaction , is used for transaction . a. HTTP b. SSL c. SET(Secure electronic transaction ) d. S/WAN Computer science important mcq 135. If a lot of data is flowing through a network card, what should the activity light look like ? a. Unit b. Rapid, erratic flashing c. solid green d. solid yellow 136. In both the sender and the recipient possess the same key. to encrypt and decrypt the data . a. symmetric encryption b. public key c. asymmetric encryption d. Encryption 137. the range of frequencies available for data transmission is knows as a. Baud b. Bandwidth c. Byte d. Bits 138. which of the following is not valid in ms-excel ? a. picture b. percentage c. character d. text 139. Ctrl+Q is used to a. a remove paragraph formatting (line space and paragraph space ) b. close word application without saving document c. print whole document without confirmation d. does noting 140. when word flags a possible spelling or grammar error , it also changes the mark on the spelling and grammar status icon to a …… ? a. a green X b. green check mark c. red X d. red check mark 141. In unix the status of the process may be a. running b. orphan c. sleeping d. all of the above 142. the master list of an indexed files a. it can contain text and data Computer science important mcq b. contains only a list of keys and record number c. has a number assigned to each record d. both b and c 143. which one is unique a. assign a common field b. primary key c. a and b d. none 144. when was developed microprocessor first time ? : 1971 March 145. To insert a column between d and e you would a) select column d b) select column e c) select column d) select columns d, e and f 146. …. operator is used to compare a value to a list of literals values that have been specified. a. like b. compare c. between d. in 147. program stored in rom are called are called as . a. Firmware b. formware c. firmware d. farmware 148. the…… format is used to store data . a. BCD b. Decimal c. Hexadecimal d. Octal 149. The internal components of the processor are connected by a. Processor intra connectivity circuitry b. Processor bus c. Memory bus d. Rambus 150. ….. is used to store data in register . a. D flip flop b. JK flip flop Computer science important mcq c. RS flip flop d. None of the these 151. Which software is not an file compression utility ? a. Win rar b. Win zip c. Compres d. 7-Zip 152. In which situation running application of an user account remains active ? a. When we log off b. When we switch user c. When we shut down d. When we reboot 153. A window can have …… states .. a. 1 b. 2 c. 3 d. 4 154. Moving from one website to another is called a. Downloading b. Browsing c. Uploading d. Attachment 155. Which one is the most suitable reason to use macro in ms office (word, excel, ppt, etc )? a. To record sound b. To automate repetitive tasks c. To record mouse move d. To record keystroke 156. The direction of a rectangular page for viewing and printing is called a. Orientation b. Direction c. Print layout d. Preview 157. In which group on the insert tab can you aces the hyperlink button ?(2007) a. Illustrations b. Links c. Headers and footers d. Cross reference 158. Which features is used to replace straight quotes with smart quotes as you type? a. Auto correct as you type b. Auto change as you type Computer science important mcq c. Auto ignore as you type d. Auto format as you type 159. Which function in excel tells how many numeric entries are there ? a. Num b. Count c. Sum d. CHKNUM 160. Except which of the following function , a formula with a logical function shows the word “TRUE “ or “FALSE” as a result ? a. NOT b. OR c. IF d. AND 161. 3-D reference in a formula ? a. Spans worksheet b. Can not be modified c. Only appears on summary worksheets d. Limit the formatting options 162. Which among following wildcard characters are recognized by excel ? a. + andb. ! and ^ c. * and ? d. < and > 163. Which of the following is not one of powerpoint view? a. Slide show view b. Slide view c. Presentation vies d. Outline view 164. Current it policy of Nepal ? a. 2016 b. 2017 c. 2015 d. 2020 165. Date of authentication and publication of electronic transaction publication of electronic transaction act 2008 is …. : December 8, 2006 166. Digital signature is a. Asymmetric b. Symmetric c. Both d. none Computer science important mcq 167. which of the following is not electronic computer ? a. ABC b. mark i c. eniac d. edvac 168. a combination of hardware and software that allows communication and electronic transfer of information between computer is called a. Network b. Modem c. Server d. Peripheral 169. The device that reconciles the difference between computer and phone is the a. LAN b. Wand reader c. TCP/IP d. Modem 170. What can greatly reduce TCP/IP configuration problems? a. WINS Server b. WINS proxy c. DHCP Server d. PDC 171. Which is not a select option in ms word 2007 ? a. Select all b. Select object c. Select text with similar formatting d. Select text 172. We can’t go to in ms word document? a. Page b. Title c. Section d. Line 173. Which is not a auto fit option in table? a. Autofit contents b. Autofit window c. Fixed column width d. Fixed row height 174. Which option will you choose to set all column width equally ? a. Auto fit column b. Distribute column c. By double click on the right side of the column d. None Computer science important mcq 175. Which features of ms word enables to print same title of a table on each page? a. Print title b. Print heading c. Repeat header rows d. Repeat headings 176. Not a text direction option in a table (MS word 2007 ) a. Top to bottom b. Bottom to top e. Right to left c. Left to right 177. Default spacing after paragraph is ? : 10 pt 178. Which function will you use to calculate the square root of any number? a. =SQRTPI b. =SQRT c. SQUAREROOT d. SQUARE 179. A green color triangle on the left top corner of a cell indicates a. Error in cell b. Empty cell c. There is formula applied cell d. Comment in cell 180. Which function counts the non empty cells of selected range of data a. COUNT b. COUNTA c. COUNTBLANK d. COUNTIF 181. Which of the following is a communication network that is devoted to carrying computer information ? a. Data point b. Data module c. Data network d. Data pack 182. The code that should be adequate for present and anticipated data processing both for machine and human use is a. Conciseness b. uniqueness c. operability d. all of the above 183. All inputs must be in on position to have on output is knows as Computer science important mcq a. NOT gate b. AND gate c. OR gate d. XOR gate 184. A sizeable geographical area with communication based on the telephone system is though as a. Local area network b. Wide area network c. Modulator –demodulator d. All of the above 185. A machine associated with card-based data processing is ? a. Codomain b. Collator c. Cartridge d. Digitizer 186. The limitation of one device or system by another is a. Simulation b. Emulation c. Resilience d. Compaction 187. A type of semiconductor memory that usually has small capacity but very fast access is ? a. PROM b. RAM c. Scratchpad d. ROM 188. A vertically aligned set of tracks on a disk pack is knows as a. Cluster b. Surface c. Cylinder d. Panel 189. To set a register or counter to the all zero-state is a. Return b. Reset c. Remote d. Release 190. A computer is a box full of electronic ? a. Switching device b. Chips c. Circuits d. Registers Computer science important mcq 191. A mechanism of arranging controlled access to a shared resource is a. Sorting b. Retrieving c. Balleting d. Lock-out 192. Any method for controlling access to or use of memory is knows as a. Memory map b. Memory protection c. Memory management d. Memory instruction 193. Which hole is used to mark the location of the first sector in a soft –sectored disk a. Address b. Location c. Index d. Label 194. Which of the following is the default port for HTTPS ? A. Port 2 B. Port 80 C. Port 143 D. Port 443 195. Upgrading the BIOS is also knows as a. UROMING b. Smoothing c. Flashing d. Updating 196. Any data or instruction entered into the hard disk memory of a computer is considered as a. Storage b. Output c. Input d. Information 197. Conversion method in which users , being used to an old system , continue to use the old system alongside the new system ? a. Parallel run b. Multitasking c. Multiprogramming d. All of the above 198. Which of the following item is not unique on a network ? a. Ip address b. Computer name Computer science important mcq c. Workgroup name d. All of the above 199. The Function is used to replace existing text with new text ? a. Replace b. Substitute c. Substring d. String 200. The function extract data stored in a pivot table ? a. Get data b. Get pivot data c. Pivotdata value d. Datavaule 201. To remove a relation from an SQL database, we use the command ? a. Delete b. Purge c. Remove d. Drop table 202. Using only HTML we can create a. Dynamic web page b. Static web page c. Both a and b d. None of the above 203. The main function of the command interpreter is : a. To get and execute the next user specified command b. To provide the interface between the API and application program c. To handle thee files in operating system d. None of the above 204. What is the shortcut key to open dialog box ? a. F12 b. Shift+f12 c. Alt+f12 d. Ctrl+f12 205. Which of the following statement is false ? a. You can set different header and footer for last page of a section b. You can set different header footer for even and odd pages c. you can set different page number formats for different functions d. You can set different header footer for first page of a section 206. In gool seek the "by changing cell" refers to the cell a. Containing the outcome formula b. Containing the constraints Computer science important mcq c. That you are attempting to calculate d. Containing the target value 207. what would you choose to crate a pre-formatted style in ms PowerPoint ? a. slide sorter view b. slide layout c. slide transition d. slide design 208. which of the following is responsible for coordinating various operations using timing signals ? a. arithmetic logic unit b. control unit c. input output unit d. none of the above 209. the average time necessary for the correct sector of a disk to arrive at the read write head is . a. down time b. seek time c. rotational delay d. access time 210. Hand held scanners a. are used to scan large amount of data b. are more versatile than the normal scanning device c. input data when they are brushed over the matter to be read d. input data when they are passed near the scanning area 211. when computer is turned on k which of the following is first executed ? a. Bootstrap loader b. operating system c. system software d. application software 212. which of the following is not a paragraph formatting ? a. alignment b. line spacing c. indenting d. margin 213. where are the upper memory blocks located ? a. conventional memory b. extended memory c. expanded memory d. reserved memory 214. which printer cannot print more than one character at a time ? Computer science important mcq a. laser printer b. dot-matrix printer c. line-printer d. daisy-wheel printer 215. A computer can operate without which of the following component , if designed according ? a. processer b. memory c. hard disk d. input/output 216. View and edit the timeline of animation of the slide can be performed using ? a. Preview b. Animation pane c. slide show d. all of the above 217. What is the name of the form used to input chart value ? a. Datasheet b. Microsoft excel c. Microsoft graph d. auto form 218. Which action will optimize your database performance ? a. set the record set type to snapshot b. use the compact and repair database tool c. create a replica of the database d. all of the above 219. we can choose data types for attributes of a table in ? a. normal view b. datasheet view c. designer view d. all of the above 220. the person who had credit idea of punch card? a. Hollerith b. jacquard c. Allen Turing d. Charles babbage 221. Which of the following printer used the vector technology ? a. dot matrix b. daisy wheel c. laser d. plotter Computer science important mcq 222. Which of the following topology work on loop back technology ? a. bus b. star c. Ring d. Mesh 223. Which command is used to display the contents of the text file on DOS ? a. copy con b. copy c. type d. dir 224. What do you call a primary key field included in another table ? a. foreign key b. parent key c. child key d. index 225. The background of the word file ? a. is always white in color b. depends upon the setting done under options menu c. can have any color you choose d. none of the above 226. What is the output of the text function +MID("regression",4,3)? a. res b. egr c. re d. gr 227. Which of the following is used for Magnitudinal comparison value ? a. Stacked bar b. Area bar c. XY bar d. Bar or column chart 228. Status Indicators are located on the a. vertical scroll bar b. Horizontal scroll bar c. formula bar d. standard toolbar 229. Tab scrolling buttons a. allow you to view a different worksheet b. allow you to view additional worksheet rows down c. allows you to view additional worksheet columns to the right d. allow you to view additional sheet tabs Computer science important mcq 230. Which of the following is not a worksheet design criterion ? a. efficiency b. Auditibility c. description d. Clarity 231. Weight refers to a. the print density of characters b. the height of the printed characters c. upright or slanted range d. the design and appearance of characters 132. Which of the following setup options cannot be set in the page setup dialog box ? a. printer selection b. vertical or horizontal placement c. orientation d. row and column titles 232. Graphic objects on a chart are used to a. add emphasis to chart data b. add interest to a chart c. help explain the chart data d. all of the above 233. using the f11 shortcut key to create a chart on a chart sheet creates a. a default chart b. 2-dimensional column chart c. a 2-dimensional bar chart d. 3-dimensional line chart 234. you can group non contiguous worksheet with a. the group button on the standard toolbar b. the shift key and the mouse c. the ctrl key and the mouse d. the alt+Enter keys 235. the chart wizard term data categories refers to a. a chart plot area b. a horizontal axis c. the organization of individuals values with a chart's data series d. the data range that supplies chart data 236. The chart wizard term data series refers to a. a chart legend b. a collection of chart data marker c. set of values you plot in a chart d. a data label 237. the number of pin out for serial data port on a pc ? Computer science important mcq a. 5 b. 7 c. 9 d. 10 238. The diagnostic testing sequence to determine if the computer keyboard, random access memory, disk drivers and other hardware are working correctly is ? a. safe mode b. POST c. NetBIOS d. Power Up 239. in windows os, what should be the extension of executable files ? a. .exe b. com c. Bin d. all of the above 240. Which of the following Is not function of the operating system? a. Editing files b. opening files c. printing files d. copying files 241. What is the shortcut key to create a registered trade –mark symbol in MSword ? a. alt+ctrl+r b. Alt+r c. ctrl+r d. none of the above 242. which of the following statement is true ? a. indentation applies to a paragraph b. tab applies to a paragraph c. indentation and tab are same d. none oft the above 243. In order to generate data series in excel, we need to specify the following a. start value b. step value c. stop value d. all of the above 244. which function allows user to repeat certain rows and column on each page ? a. PRINT ROW & COLUMN b. PRINT REPEAT c. PRINT HEADER Computer science important mcq d. PRINT TITILE 245. sorting data in more than one column in excel, we use a. sort A-z b. sort z to A c. custom sort d. none of the above 246. In access , SQL or oracle , which command is used to add, delete or modify columns in a table ? a. CHANGE TABLE b. MODIFY TABLE c. ALTER TABLE d. All of the above 247. which of the following is not a body tag properties ? a. bgcolor b. text c. background d. image 248. Which of the following statement is true in case of IP ? a. IP is an internet path b. Every computer must have an IP address c. IP is an unique address of computer connected to the network d. all of the above 249. Internet protocol (IP) address ? a. DNS server b. DHCP Server c. web server d. database server 250. Which address is the loopback address ? a. 0.0.0.1 b. 127.0.0.1 c. 255.255.255.255 d. 127.0.0.0 251. which of the following order is correct to form URLs ? a. Protocol name , file name , DNS name b. DNS name , Protocol name , file name c. Protocol name , DNS name , file name d. Protocol name , file name , dns name 252. How long is an IpV6 address ? a. 32 bits b. 64 bits c. 128 bits Computer science important mcq d. 128 bytes 253. Which of the wireless standard is widely used to connect computers to each other and to the internet ? a. 802.11 b. RJ45 c. blue band d. broadband 254. location where the 1st computer instruction available on boot up is ? a. BIOS b. CPU c. d. CONFIG.SYS 255. In electronic transaction Act of Nepal. The method of digital signature is ? a. Private-private key b. Private –public key c. Symmetric public key d. all of the above 256. Maximum number of hosts on a local subnet that used 255.255.255.224 subnet mask. a. 14 b. 15 c. 16 d. 30 257. RS-232 is a standard that applies to a. parallel ports b. game ports c. networks d. serial ports 258. Hexadecimal value of 20 is equivalent to decimal number ? a. 16 b. 20 c. 32 d. 64 259. the ….folder is the default place that most application want to store data files in. a. start menu b. Recycle bin c. program files d. My document 260. What would be result if you type=A1=b1 in cell C1 a. yes/no b. true/false Computer science important mcq c. invalid value d. value of b1 261. ……. is a tool to automate tasks and add functionality to your forms, reports and controls a. List b. validation c. automation d. macros 262. Unlike filters queries can be saved as in a database . a. database b. Filters c. objects d. any of the above 263. In a large DBMS A. each user can access every sub schema B. each sub schema contain every field in the logical schema C. each user can "see" only a small part of the entire database D. all of the these 264. In a database , a network structure a. allows many to many relationship b. is a physical representation of the data c. allows only one-to-one relationship d. none of these 265. Which of the following is at the highest levelin the hierarchy of data organization ? a. database b. option 4 c. data file d. data record 266. which of the used by most of DBMS for helping their users to access data ? a. HLL b. Query language c. SQL d. 4 GL 267. The physical location of a record is determined by a mathematical formula that transforms a file key into a record location is a/ an a. sequential file b. hashed file c. indexed file d. B-tree file 268. the distinguishable parts of a record are called a. fields Computer science important mcq b. files c. data d. all of these 269. The command to convert a numeric number to character is a. STR( ) b. CHR ( ) c. ASC ( ) d. all of the above 270. The command that add a new filed to an active database is a. MODIFY STRUCTURE b. MODIY COMMAND c. MODIFY REPORT d. MODIFY LABEL 271. A collection of conceptual tools for describing data, relationships, semantics and constraints in referred to as a. DBMS b. Data model c. Database d. ER Model 272. …….Search methods is conducted for a specific title, domain , URL , or host . a. Logical b. Keyword c. field d. Boolean 273. In SQL , which command is used to change a table's Storage characteristics ? a. ALTER TABLE b. MODIFY TABLE c. CHANGE TABLE d. None of these 274. In SQL, which of the following is not a data definition language commands? a. REVOKE b. RENAME c. UPDATE d. GRANT 275. Which operator performs pattern Matching ? a. BETWEEN Operator b. LIKE Operator c. EXISTS Operator d. None of these 276. Which of the following SQL commands is used to retrieve data ? a. DELETE b. INSERT Computer science important mcq c. SELECT d. JOIN 277. Which of the following command makes the updates performed by the transaction permanent in the database ? a. ROLLABACK b. COMMIT c. TRUNCAE d. DELETE 278. Which of the following SQL commands can be used to add data to a database table ? a. ADD b. UPDATE c. APPEND d. INSERT 279. Which of the following join is also called as an 'inner-join' ? a. Non-Equijoin b. self-join c. Equijoin d. none of these 280. the SQL keyword(s) ………is used with wildcards . a. NOT IN only b. LIKE only c. IN only d. IN and NOT in 281. A Sub query in an SQL select statement is enclosed in : a. Parenthesis-(…) b. Brackets-[…] c. CAPITAL LETTERS d. braces – {..} 282. The result of a SQL SELECT statement is a …… ? a. file b. report c. table d. form 283. What is an SQL virtual table that is constructed from other tables? a. View b. relation c. Just another table Computer science important mcq d. Query result 284. The SQL statement SELECT SUBSTR('abcdefghij', INSTR ('','2',3,2),2)from DUAL: prints a. gh b. 23 c. bc d. ab 285. The SQL statement SELECT ROUND(45.926,-1)FROM DUAL: A. is illegal B. prints garbage C. prints 045.926 D. prints 50 286. The SQL statement SELECT SUBSTR ('',INSTR('abcabcabc','b'),4)FROM DUAL : A. 6789 B. 2345 C. 1234 D. 287. Which SQL Keyword is used to sort the result-set ? a. SORT BY b. ORDER c. ORDER BY d. SORT 288. Which SQL statement is used to delete data FROM a database ? a. COLLAPSE b. REMOVE c. ALTER d. DELETE 289. Which SQL statement is used to update data in database ? a. SAVE b. UPDATE c. SAVE AS d. MODIFY 290. which of the following are table tags ? a. table, thead, tr, td b. colspan, table , tr c. table, tt,tr td d. none of the mentioned 291. the open source software version of netscape is a. chrome b. Mozilla c. Internet Explorer Computer science important mcq d. Erwise 292. IDE stands for a. Internet development environment b. Integrated development environment c. intelligent development environment d. none of the mentioned 293. Which of the following are automatically loaded and operates as a part of browser ? a. add-ons b. Plug-ins c. utilities d. Widgets 294. …………….Is an open source javascript library that allows support for different levels of experiences based on the capabilities of each browser . a. Navigator b. modernizr c. Geolocation d. Google API 295. In which part of the HTML metadata is contained ? a. body tag b. html tag c. head tag d. title tag 296. Which of the following is not a function of robots meta tag ? a. noindex b. nofollow c. norepeat d. noarchive 297. The Body tag is usually used after a. HTML tag b. EM tag c. TITLE tag d. HEAD tag 298. Adding a border to your image helps the visitor to recognize it as what ? a. frame b. a link c. a picture d. none of the above 299. A much better approach to establish the base URL is to use the ……….element ? a. HEAD b. BODY Computer science important mcq c. BASE d. none of the above 300. Which image file format is not supported in Firefox ? a. ICO b. PNG c. SVG d. APNG 301. ……………..is an HTML specification used to add more information to HTML tags. a. Macrodata b. microdata c. minidata d. modifydata 302. ………….Prevents the page from being indexed altogether ? a. noarchive b. nofollow c. noindex d. novalue 303. Firefox used ……………rendering engine . a. Webkit b. Gecko c. Trident d. Presto 304. What will be the added by using <td> and </td> tag ? a. Rows b. steps c. cell d. columns 305. If the background image is smaller than the screen, what will happen ? a. it will be streteched b. it will be repeated c. it will leave a blank space at the bottom of your page d. none of the above 306. Which section is used for text and tags that are shown directly on your web page ? a. Head b. Metatags c. Body d. title 307. The attribute used to create the actual section within the current HTML documents ? a. LINK Computer science important mcq b. HERF c. BASE d. NAME 308. the default value of BORDER ATTRIBUTE is a. 1 pixel b. 2 pixel c. 4 pixel d. none of the above 309. the most basic element of any HTML page is a. ASCII Text b. Text c. BCD text d. none the the above 310. HTML tags are used to describe document ………….. a. definition b. language c. content d. none of the above 311. in order to upload a HTML file to a web server, you use a. HTTP b. SMTP c. SIP d. FTP 312. …………..is the incoming e-mail server ? a. POP b. SMTP c. SMIP d. PPP 313. Unmodulated signal coming from a transmitter is knows as a. carrier signal b. baseband signal c. primary signal d. none of these 314. Error detection at the data link level is achieved by a. Bit stuffing b. cyclic redundancy code c. hamming code d. equalization 315. A high speed communication equipment typically would not be needed for a. E-mail b. transferring large volume of data c. supporting communication between nodes in a LAN Computer science important mcq d. all of these 316. 00 represents a pixel that pixel is knows as: a. black pixel b. light pixel c. white pixel d. dark pixel 317. a distributed network configuration in which all data/information pas through a central computer is a. bus topology b. star network c. ring network d. point-to-point network 318. Number of unguided media is a. 6 b. 5 c. 4 d. 3 319. a machine that connects to two or more electronic mail systems and transfers mail messages among them is known as a. gateways b. mail gateway c. bridges d. user agent 320. To connect a computer with a device in the same room , you might be likely to use a. a coaxial cable b. a dedicated line c. ground station d. all of the above 321. Which network has connectivity range up to 10 meters ? a. LAN b. PAN c. MAN d. WAN 322. the network topology that supports bi-directional links between each possible node is a. Ring b. star c. tree d. mesh 323. Which of the following is not a filed in the Ethernet message packet ? Computer science important mcq a. Type b. data c. pin-code d. address 324. Distributed Queue Dual Bus is a standard for a. LAN b. MAN c. WAN d. LAN and MAN 325. What protocol is used between E-mail server ? a. FTP b. SMTP c. SNMP d. POP3 326. communication between computers is almost always a. serial b. parallel c. series parallel d. direct 327. What IP address class has few hosts per network ? a. D b. C c. B d. A 328. The size or magnitude of a voltage or current waveform is a. Amplitude b. Aloha c. Angle Modulation d. Attenuation 329. A network that requires human intervention of route signals is called a. bus network b. ring network c. star network d. T-switched network 330. If communication software can be called the 'traffic cop" of a micro communication system, then what should the modem be called ? a. Park b. Bridge c. Interface d. Link 331. The are of coverage of a satellite radio beam is know as a. Footprint Computer science important mcq b. circular polarization c. Beam width d. identity 332. The ………layer is the layer closest to the transmission medium . a. transport b. network c. data link d. physical 333. What of the following is an example of a client-server model ? a. TELNET b. FTP c. DNS d. all of the above 334. The amount of uncertainty in a system of symbol is called a. bandwidth b. Entropy c. loss d. Quantum 335. The birthplace of the World wide web is considered to be a. The department of defense b. CERN c. ARPA d. Netscape 336. How many pairs of stations can simultaneously communicate on Ethernet LAN ? A. 1 B. 2 C. 3 D. multiple 337. In which language is source program written ? a. Temporary b. English c. Symbolic d. High level 338. the PID of kernel process is a. undefined b. 0 c. 1 d. 2 339. How do you insert a graphic of your company's logo on a report ? a. select tools>insert picture from the menu Computer science important mcq b. click the image button on the toolbox and drag on the report to draw a place holder for the graphics c. you can't ms access won't let you insert graphics files d. select insert>picture from the menu 340. To print current page of a document only a. press ctrl+p and select current page b. click ms office button>print>print preview>>select current page and print c. click ms office button>>print>>quick print d. both a and b 341. Electronic spreadsheet is also known as a. data processor b. word processor c. presentation package d. none of above 342. when writing a document , you can use the ………..feature to find an appropriate word or an alternative word if you find yourself yourself stuck for the right word . a. dictionary b. thesaurus c. encyclopedia d. word finder 343. Which of the following is not the part of standard office suite ? a. Image editor b. database c. file manager d. file presentation 344. Editing a document consists of reading through the document you've created. then ……… * a. correcting your errors b. saving it c. printing it d. deleting it 345. A template stores a. Graphics , text , styles , macros b. customized word command setting c. auto text entries d. all of above 346. ………..is the process of finding errors in software code ? a. compiling b. testing c. running Computer science important mcq d. debugging 347. The most frequently used instructions of a computer program are likely to be fetched from ………….. a. cache memory b. RAM c. the hard disk d. registers 348. where from you can insert shapes in your slides ? a. animation menu b. insert menu c. design menu d. all 349. software programs that allow you to legally copy files and give them away at no cost are called which of the following ? a. probe ware b. timeshare c. shareware d. public domain 350. in ms-excel how many character can be typed in a single cell a. 25600 b. 10240 c. 32000 d. 65536 351. Human beings are referred to as homo sapinens, which device is called silico sapiens ? a. monitor b. hardware c. robot d. computer 352. What is the other name for programmed chip ? a. RAM b. ROM c. LSIC d. PROM 353. ASCII is a coding system that provides a. 256 different character b. 512 different character c. 1024 different character d. 128 different character 354. What is bootstrapping called ? a. cold boot Computer science important mcq b. cold hot boot c. bold hot strap d. hot boot 355. which technology has the fastest data transfer rate ? a. 802.11a b. 802.11b c. 802.11g d. 802.11n 356. which of the following options is not located in the page set up box ? a. header and footer b. page orientation c. page break preview d. margins 357. the ability to recover and read deleted damaged files from a criminal's computer is an example of an enforcement specially called ? a. Robotics b. simulation c. computer forensics d. animation 358. database is generally a. system-centered b. user-centered c. company-centered d. data-center 359. in ms-word, word is knows as a. a string of letters or numbers b. 16 or 32 bits c. any language word d. none of the above 360. Regarding a web link to a different address is a form of : a. phishing b. snooping c. spoofing d. sniffing 361. the function extract data stored in a pivot table ? a. getdata b. get pivot data c. pivot data value d. data value 362. What is the most common tool used to restrict access to a computer system ? a. user logins b. passwords Computer science important mcq c. computer keys d. access control software 363. which of the following is system software ? a. Microsoft windows b. disk defragmenter c. Microsoft word d. both a & b 364. a systems has two IDE hard drives that are each divided into primary and extended partitions; which drives letter is assigned to the primary partitions of the second drive ? a. C b. D c. E d. F 365. thee database is said to be ……..if the same information is duplicate in several places. a. consistent b. redundant c. secure d. all of the above 366. your company has a LAN in its main office and has now set up a LAN in the manufacturing plant in the sub office. to enable everyone in the sub office. to enable everyone in share data and resource between the two LANs . What type of devices(s) are needed to connect them? choose the most correct answer . a. modem b. cable c. hub d. router 367. which command of ms-access is used to copy only files that have been modified on or after the data you specify ? a. XCOPY Ad:date b. copy/d:date c. copy/m d. xcopy/v 368. Who was the founder of Bluetooth ? a. nils Rydbeck b. martin cooper c. steve jobs d. apple 369. where BIOS is stored ? a. Hard disk b. RAM Computer science important mcq c. Flash memory chip d. any of above 370. …are used for solving complex application such as global weather forecasting a. super computer b. public computer c. mobile computers d. hybrid computer 371. if a process fails, most operating system writes the error information to a ? a. log file b. new file c. another running process d. none of the mentioned 372. An …. is a set of processes and procedure that transform data into information and knowledge ? a. knowledge system b. computer system c. database system d. information system 373. in ms word , you can convert the documents file format by applying the command . a. convert b. save c. permission d. save as