ROLL No. 4 WAPDA Examination Cell (Power Wing candidates) Departmental Promotion Examination Form Assistant Director (Computer) BPS-17 to Deputy Director (Computer) BPS-18 for the Year January 2012 ‘Total Marks: - 100 Pass Mairks: - 50 PAPER - B (TECHNICAL) PART- 1 (Objective) ‘Time allowed: - 30 Min, Attempt all Questions. Max. Marks:- 50 question carries one mark. Please encirele (Q) the True or False. 1) Domestic consumers having consumption up J from Equalization Surcharge, (True/Fatse) 2) Equalization Surcharge is calculated on Variab: (TruefPalse) 3) In ease of Industrial TOU meter, 2 meter reco: (True/False) & 4) 14 digit Reference key is consist of 2 digit Batch No, 4 digit sub division code , 7 digit consumers No. and 1 digit as check digit (True/Falsey 3) Batch No. 26 and Batch No.36 consist of Dead! Defauiter Consin CreiFalse) 6 6) Neclum Jhelum Surcharge is not being levied io Psivs (True/Faise). 7) Monthly Fuel Price Adjustment is not applicable to Lite Line Domestic Cousunie (CrueFalse) 8) As per NEPRA Tariff no fix charges are being charged i D-1(a) Agricultural Consumers. (True/False) 9) Tari! Code 41,42,43,44 is used for Searp irs 10) Neclus Jacium Surcharge is not being levied vo Priv ¢ 11) MS Access is a relational database management system (True / False) . va 12) A relation may have multiple primary keys, (True / False) _ 13) Dbase, FoxPro, Oracle and Recital are word processors. (nue / False) 14) Mainframe is less advanced than Personal Computer (True /Faise) ) User password is changeable, (tie False) 10} Database design plays an important role in achieving the goals of vl consiste ney. 17) In can be defined as network of networks. ee rue / False) 18). Email cannot be prepared / writen without logyin (True / False) to RemotePART- I (Objective) 19) DIR statement shows all the contents ofthe file ina folder rue FalSe) (lte / False) 20) MS EXCEL is basically used to creating cflicient spread s! ircle (0) the correct option in multiple choice. 21) In MS Word Autocorrect Feature can be used for correct ie ®Spelling only ¢. spelling & grammar b. formatting & spelling d. grammar only 22) Ia MS Exeel if we copy a cell(having formula) id then paste to other cell, which thing will be copied there: a. Value @Formuta c.cell address 4, value and formula both 23) In MS Excel “Sgt” function can be used f calevlating: a, Subtract b. Cube EPader root d, None of the given 24) In Windows Control Panel, Add Remove Programs feature cannot used for a, Uninsta Software ©Jastall Hardware 25) MS Word cannot used for preparing, 4, Set Program Defaults @Slideshow b. Resume ¢. Faxes Reports 26) leon is a @mage File b, Short Cut ©. Software é, Hardware 27) A computer does not run if it don't have a. Printer b. Hard Disk ©. Mouse @ram 28) System Restore Feature is used to weover a. Data Base b. MS Wor E\Windows d, Hardware 29) Which application is not typically itieluded in the MS Office suite? a, Word Processor b. Spreadsheet © Antivirus 4. PowerPoint 30) Key information in MIS-STAT-FILE is based on a, Reference No. b.— Bateh e ©. Sub Division 4. Allofabove 31) In MIS-STAT-FILE information can be extracted for a, Current Month Only b. 12 months 24 month 4. AllofaboveWAPDA Examination Cell (Power Wing candidates) Departmental Promotion Examination Form Assistant Director (Computer) BPS-17 to Deputy Director (Computer) BPS-18 for the Year January 2012 ‘Total Marks: - 100 : Pass Marks: - $0 PAPER - Bi (TECHNICAL) PART-II (Descriptive) ‘Time allowed: -2 Hrs. Attempt all Questions. Max. Marks: - 50 QL. Describe of the following. (13) a. Whatis the use of Find and Replace in MS Word? b. What is Active Cell in MS Excel? ¢. What is the difference betwecl} LAN and WAN? 4d. What is Search Feature of MS Windows? e. Why is the formula error “#D|V/0!” oceurs in MS E: £. Describe the control panel in MS Windows? g. What is the difference betweeji System Software and Application Software? h, Whats the requirement to pul PC on network? i. Whatis the use of Hub or Swifch in networking of PCs, j. What is the difference betwee)t Portrait and Landscupe printing? Q2. Describe in detail of any five of the following (10) i, What are ED Code and its use? List down all codes being used under field with description. ii, Please define normal meter and TOD meter. What is t normal meter billing and TOL) meter billing? Under wh is allowed for agriculture tube wells. iii, For name and address, how inany lines are reserved in CP-136? For which purpose 2™ line is used, Also tell the No. of characters in each line, iv. Please define CP-126 and (P-127. What is the difference between both reports? Explain. v. For what purpose CP-102 and CP-102-A are processed and what are their outputs vi, Write the number and names of « posted through CP-139. vii, What the difference between, JOT and Reverse IOT? Give examples. Also tell under which condition, Reverse IOT is generated. & QB. Describe the preparation steps of the following reports in detail with the numeric code and contents, (15) ‘A. Daily Billing Reports B. Daily Cash Reports C. Weekly Cash Reports D. Monthly Cash Reports E. Monthly Billing Reports ED code difference between tariff TOD billing ®% ch type of transaction which are being Qu. fy describe the following. (10) 1. Write the detail steps for installation of Window and to make all devices operational on a brand new PC. Can we protect our computer from viruses? Also describe at least wo major -viruses with their specification. 3. Is the File Organization Method on Personnel, Min and Main Fr Computers same? Describe it la detail 4, Deseribe the COBOL Division in d END OF PART- Il (Descriptive)aor 32) 33) PART- 1 (Objective) Input Source for creation of MIS-STAT-FILE is a CP-41 b. CP-110 8 c Total File d. Master Files On MIS-FILE & MIS-DEF-FILE (Regular MIS), information of current month is posted from a cP-41 b. CP-110 gq c Total-File d. Master Files. Please fill in the blanks. 34) 35) 36) 37) PEP Stand fore Yoda Out On ROM stands for Ren OS wrens PM stands for _Gwsur_Wannggvee HHU stands forlQoms¥A Woh GSM Stands for C.\d\oe) Soh Ru an Swi edo GPRS stands for {cower YaSeah _Yobam __ Semscs LED stands for Ast) = wrmadtinn Sel DNS stands for “Dow Wows Seow a BPI stands for SoN8 e— we VMS stands for Me Waa werner ef Asse DSL stands for 5 4 - COBOL stands for {Seca Neusners Sued Jaw HITT stands for Sega Noh Dau wi PDF stands for UML stands for _\ A Ss sudShoues Dowyuot¢ END OF PART- I (Objective)Roll No. PAKISTAN WATER AND POWER DEVELOPMENT AUTHORITY Departmental Promotion Examination of AD (P/SA) / Junior Computer Programmer to Deputy Director (P/SA) BPS-17 to 18 PAPER ~ A (CURRENT AFFAIRS, RULES & REGULATIONS} PART ~ 1 (OBJECTIVE) Time Allowed - One hour Total Marks (Part-1): 33 Passing Marks: 40% (13 Marks) Note: (i) Attempt all questions in Part-I (ii) Books and typed / hand written notes are not allowed. urrent Affairs Lin Afghanishtan the Armed Forces of _ and are fightin 1 GAZAis located in . Prime Minister of Palestine is 4 Party of Egypt has won the General Elections. 1. Khalid Mishal is the Chief of and living in _ i Dr___is the World Famous Muslim Scholar of india The President of Turkey is Mr. ___and is the Prime Minister of Turkey. is the Richest American in the World WTO stands for | IAEA stands for \dlecpatio rey Dmic Ener j Aiciaage 0. Uranium is found aaa ae in pSkstan baenan 1. The following got Nishan-i-Haider during the last 19 years:- a) Capt Col, Sheena b) awaldor Latare _is the National Flower of Pakistan * J Fimoc 3, Mega Projects in Baluchistan are; P1of2wu, 15. 16. Wonders of the World are; a) b) qd Ashra Mubashra are (a) {b), (c) (a). The names of the Sons of the Holy Prophet Muhammad (PBUH) are; a) b) - d RULES & REGULATIONS 1 a The competent authority is the as __according to E&D Rules, Appeal is preferred to Appellate Authority within Q days according to £&D Rules. Rule-11 of E&D Rules deals with OQeo) - TT . Rule-12 of E&D Rules deals with AQOn \S_marks are deducted on account of Minor Penalty of “Censure” for promotions Difference between Charge Sheet Procedure and Letter of Explanation under E&D Rules is that Incase Charge Sheet or Letter of Explanation is received back undelivered from accused, the Charge Sheet / Letter of Explanation will be got published in If a BPS 17 officer intends to sell his plot of Rs.2 Lacs, the procedure would be Incase a BPS 17 officer wants to get admission in evening classes of a University, the procedure for getting permission would be An officer of BPS 17 can get married with an indian Muslim Girl (True or Flase). Only 12.0 days leave on full pay can be granted to an employee without medical certificate. Only!) _days leave on full pay can be granted to an employee with medical certificate. An employee can be granted maximum leave of k___years, if due. ve due) will be allowed to his family. Fapgriployee is died during service,_\Q 0 days encashment (if | 242. days EOL can be granted to an employee, if his service is more than 10 years. BS days EOL can be granted to an employee, if his service is less than 10 years. 34S _ days Encashment of leave is admissible to any employee on attaining the age of Superannuation P2 OF 2 |ROLL No’ WAPDA Examination Cell (Power Wing / PEPCO) Departmental Promotion Examination of Assistant Director (Computer) BPS-17 to Deputy Director (Computer) BPS-18 for the Year January 2011 Total Marks: 100 Pass Marks — : 50(50%) PAPER — B (Professional / Technical) PART-I (Objective) Attempt all Question: | Do not use erasable pen Every question car Time allowed + Max. Marks 60 Min. es one mark. Complete the following: 1 . ANS Ke S___ software helps you carry out tasks, sue! PPA stands for_ GSA stands for_ MICR stands for Wabnebc we chase chur Sacrpyalans v ‘The capacity of 3.5 inch floppy disk is__\: WA ARR, What is the Rate of Domestic Consumer in Minimum Slab Rs 3 What is the Rate of Domestic Consumer faximum Slab Rs: hk & TV License Fee per Annum to Domestic Consumer is Rs: z Minimum Charges of single phase Domestic Consumer is Rs: The including 1 is the program that 1 PU, memory, storage d e hardware of U 1 input/output d computer system, 2 document or creating a spreadsheet When you connect to the wR your Internet service provider (ISP). your computer is communicati with a server at KL is the science that atter thought process. pis to create machines that will emulate the human 1ofsERD SP RE RE EA ET RE Encircle (0) the correct answer: 13. 14. 15. 16. 17. 18, 20. 2 The name for the way that computers manipulate data into information is called (A).programming (@)processing (C) storing. (D) organizing A string of eight Os and 1s is called a: (A) megabyte (B) byt © Kflobyte. — (D) Which of the following bar is not available in MS-Word? (A) Toolbar ((B)) Formula Bar (C) Status Bar (D) Menu Bar You can quickly change the appearance of your work by choo: Auto Format from the ___ Menu. (A) Edit (B) View (©Oormat (D) Tools To copy cell contents using drag and drop, press the bove (A)Endkey (B)Shiftkey — (C) Ese key Ore What is an expression that tells how the nu calculated? ina determined set of cells are to be @Yormula (8) Field (©) Data (D) Query Correct Answer The cell reference for a range of cells that starts in cell BI an down to row 10 is goes over to column G and (A)GI-GIO (B)B1.GIO.— (C)B1;Gi0.~—- (©) B1-Gio A is approximately one billion by (A) kilobyte (B) bit byte (D) me is any part of the computer that you can physically touch \ plication CA)Hlardware (B) A device (C)A peripheral (D) A All of the following are examples of input devices EXCEPT: (A)scanner — (B)mouse —_(C) key board oy er 2of5anna ee 23. 4. 25, 26. 27. 28. 30. 31. 3. PART-1 (Objective) Which of the following is an example of an input device? scanner (B) speaker (C) CD (D) printer All of the following are examples of storage devices EXCEPT: (A) hard disk drives @) printers (C) floppy disk drives (D) CD drives The CPU and memory are located on the: (A) expansion board ((B))motherboard (C) storage device (D) output device bits equal one byte @® ight (B)Two ° — (C)Sixteen —_(D) One thousand The binary language consists of ____digités). (ays @ (C) 1.000 (D1 A byte can hold one of data (A) bit (B) binary Ei Ops (D) kilobyte The metal or plastic se that holds all the phy’sieal parts of the computer is the: (A) system unit ((B) cpu (C) mainframe (D) pla form A computer program that converts an entire program into machine language is called a/an (A) Interpreter (B) Simulator ((C) Compiler (D) Commander A computer program that translates one program instructions at a time into machine language is called aan (@)interpreter_ (B) CPU (C) Compiler In the binary language each letter of the made up of a unique combination of (A) cight bytes eight kilob / (C) eight characters oye bits ° Excel is a ach special character is (A) Graphic program (B) A spreadsheet (C) Word processor ) None of theseMM. 35, 36, 38. 39. 40. 41 42. PART-I (Objective) Which command brings you to the first slide in your presentation? ‘A) Next slide button (B) Page up trl + home (D) Curl + end Which of the following should you do to bri g a bullet back to a previous level? (A) Press the shift + tab keys (B) Press the shift key (©) Press the enter key (D) Press the tab key Presentation designs regulate the formatting and layout for the slide and are commonly called (A) Design templates (B) Templates ) Placeholders (D) Blueprints ord processing spreadsheet. and photo-edit (A) application software (B) system software ) operating system software (D) platform software Personal computers use a number of chips mounted on a main circuit board. What is the common name for such boards? (A) Daughter board (B)Motherboard (C) Father board ) Breadboard An integrated circuit is (A) A complicated circuit (B) An integ ing device (C) Much costlier than a single transistor Fabricated on a tiny silicon chip Most important advantage of an IC is its (A) Easy replacement in case of circuit failure (B) Extremely high reliability (C) Reduced cost (D) Low powers consumption Menu Item in dim colour (gray) indicate that the menu is? AYUnavailable for current context (B) Not much required menu ') Toggle Menu (D) Over Used Menu Which of the following is the correct order of the four major functions of a computer? (A) Process, Output, Input, Storage Input, Output, Process, Storage (©) Process, Storage, Input, Output D)) Input, Process, Output, Storage dof544, 45. PART-I (Objective) (A) Dot per inch (B) Dot per sq. inch (C) Dots printed per unit time (D) Alll of above Macros are? (A) Small add-on programs that are installed afterwards (B) Programming language that you can us (C) Large tools in Word such as Mail Merge C() Small programs created in MS-Word to automat: f you need them to customize MS-Word repetitive tasks by using VBA A user wishes to remove a spreadsheet ft events that will do this? 5 the correct sequence of (A) Go to File, Save As, Save As Type, Excel worksheet (By Right click on the spreadsheet tab and select DELE” (C) Right click on the spreadsheet and select Insert, Entire Column (D) None of above Encircle (O) the correct option True or False: 46. 41. 48. 49, 50. — WordStar, Word Perfect and Professional Write all are Word Processors run in True / False DOS mode? A computer ean be assig ed more than one IP address? True / False i Writing rule of program is called syntax True / False Clicking on an icon with the mouse is a form of giving an instruction to the computer. True / False Two different IP packets destined to router B and orig’ may take two different routes to reach at B ing from router A. True / False END OF PART-1 (Objective) SofsROLL No: y_ 1 WAPDA Examination Cell (Power Wing / PEPCO) Departmental Promotion Examination of Assistant Director (Computer) BPS-17 to Deputy Director (Computer) BPS-18 for the Year January 2011 Total Marks: 100 Pass Marks PAPER - B (Professional / Technical) PART-II (Descriptive) Attempt all Questions. Do not use erasable pencil. 0%) Time allowed : 2 Hrs Max. Marks: 50 Q. Describe the difference in following in brief (any Five) (5x2=10) a Internet and Intranet b, LAN and WAN °, Sort and Merge Commands 4. Backup and Restore Commands e, t g h. Copy and Cut Commands kWh and kW m Source and Object Program High Level and Low Level La @. How can we protect Personal Computer fi iruses? Also name at least three anti-viruses.(5) @. a Describe the COBOL Divisions and ns in detail R (6+4=10) b. Describe in detail “Type of Files” in COBOL, z Q4. Discuss in Detail any three of the follow these: also give comments for i Payroll System Inventory Control WAPDA Employee Billing Machine Readable Bill Bill Adjustments (CP-52) % QS. Explain MIS Reports of Billing and give sug tions for its improvement. (10) pee EES ERTS TRS ponge loflPAKISTAN t WATER AND POWER DEVELOPMENT AUTHORITY Departmental Promotion Examination / (s) of AD (P/SA) / Jr. Engineer ‘Civil)/(Mech) And Doctors (BPS-17 to 18) PAPER ~ A (Current Affairs, Rules & Requlations’ PART -1 (OBJECTIVE) ‘Time Allowed - One hour Total Marks (Part-I) : 33 Passing Marks: 40% (13 Marks) Note: (i) Attempt all questions in Part-|. (i Part-l to be handed over to the examiner after one hour. (ii) Books and typed / hand written notes are not allowed. ) Current Affairs a4 Fill in the blanks. (15 Marks) i) President of Pakistan performed Ground Breaking Ceremonies of two small & medium dams during January 2010 in the Provinces o and i) The 7" NFC Award was signed on at ii) The first elections for the Gilgit Baltistan Legislative Assembly were held on iv) IRSA stands for yo Mr is the present Secretary General of UNO. wi) The Ground Breaking Ceremonies of two small & medium dams i.e Winder & Darwat were performed by the President of Pakistan on and vi) MDRP stands for vii) The Kachhi Canal Project is being constructed in the Province of ix) Mr. was the first Pakistani Nobel Prize Winner. x) Scurvy (bleeding gums) is a disease caused by the deficiency of x) The Stock Exchange of New York is called , | | | | |xii) The boundary line between Pakistan and Afghanistan is xiii) Diamer Basha Dam is being constructed on the River xiv) Musaad is the Intelligence Agency of | Ww xv) The Supreme Court of Pakistan declared NRO as . De Q.2. Tick True or False (18 Marks) - an Tre sas Time Allov [ay The Removal from Service (Special Powers) Ordinance was promulgated in True TF the year 2002 Note: (i) (ii) (ii True | False | “Tue /§388 Q.No.4 (vii) | The English movie known as the ‘Messa; True | False Islam. (| Dr. Shamim Akhtar was the first Woman ¢ True | False EPCO stands for Pakistan Electric Power Company a True False Q.No.2 Under the WAPDA Depulation Policy, the maximum period of deputation | abroad can be extended upto 10 years (xi) | According to WAPDA Empioyees Conduct Rules, an employee in BPS-1 to BPS-15 is required to get permission of the competent authority for acquisition, Q.No.3 sale and disposal of movable and immovable property and construction of - | \ | accommodation for residential or commercial purpose j (xii) | AWAPDA employee is not required to True | False | holiday except with the approval of his immeciate superior officer. fe (xiv) | A Medical Officer may accept any gift True | False person in recognition of his professional a t hay | The Tosal deputation period or enPoleyis upto [Tale FBR Q.No.A | maximum of five years. > | io a een - 1 (vi) | No WAPDA employee shall express views detrmenta! to _ True | False ef or ideology of Pakistan - ~ QNo.2 (wil) | No WAPDA employee shall directly or approach any Member ofthe | True | False National Assembly or Government or any non-official person to intervene on | | his part on any matter. j be Q.No.3 Galil) | A WAPDA employee who has been granted leave on medical grounds may ‘(| True | False retum to join without producing certificate of fitness. jeROLL No. WAPDA Examination Cell (Power Wing candidates) Departmental Promotion Examination Form Assistant Director (Computer) BPS-17 to Deputy Director (Computer) BPS-18 for the Year January 2010 Total Marks: - 100 Marks: - 50 PAPER — B (TECHNICAL) PART- I (Objective) Time allowed: - 30 Min. Attempt all Questions. Max. Marks: 50 Every question carries one mark. Please Encirele (0) the correet option. 1) An 8-bit address bus can address a memory of a1 Byte —_b. 8 Bytes c. 265 Bits (4256 Bytes 2) Which of the followings is not a semi-conductor memory? a. ROM b. RAM c. PROM @ None of these 3) How many types of busses are there in computer architecture a, One b. Two @three 4) Parallel port is used for connecting a.Modem b)Printer c. Keyboar d, Mouse 5) Which of the followings is not a semiconductor memory a, RAM b. ROM c. PROM @Hard Disk 6) Which of the following buses is used for specifying memory location a, Control Bus()Address Bus, Data Bus 4. All of above 7) A temporary storage device, Which holds data as long as it is being interpreted is called as aCPU Register. c. ROM d. Memory 8) A port, Which provides a connection for transmitting data one bit at a time is called a. Parallel Port(b) Serial Port c. Mouse Port d. Special Portere 12) 13) 14) 16) 17) 18) 19) PART- I (Objective) Main memory of computer is @pPrimary Memory b. Connected with CPU c, Internal Memory d. All of the above D)plecttical Signals c. Computer Files d. Software The microphone converts the sound waves into a, Mechanical Signals The devices, Which receives information from outside, converts it into a form that is easily understandable by the computer are called as a. Floppy Drives and Hard Disks b, Output Devices (©Imput Devices d. Image Scanners As compared to main memory, Secondary storage of a computer a. Has faster access b. Has smaller capacity c. Res in CPU lone of above SIMM stands for a. secondary In-Line memory Module ¢. System In-Line memory Module ingle In-Line memory Module d. None of the above Computer designers, to increase the computer system though put use a, Direct Access Memory b. Flash Memory @©Cache Memory Elements of Boolean Algebra are d, Sequential Access memory a, Boolean Constants b, Boolean Variables @Both a. and b. d. None of the above Whie’ ** ———12) 13) 16) i) 18) 19) 20) PART- I (Objective) Main memory of computer is a. Primary Memory b. Connected with CPU ¢. Internal Memory d. All of the above The microphone converts the sound waves into a, Mechanical Signals b, Electrical Signals c. Computer Files d. Software The devices, Which receives information from outside, converts it into a form that is easily understandable by the computer are called as, a. Floppy Drives and Hard Disks b. Output Devices Input Devices d. Image Scanners As compared to main memory, Secondary storage of a computer a. Has faster access b. Has smaller capacity c. Resides in CPU d, None of above SIMM stands for a. secondary In-Line memory Module b, Single In-Line memory Module ¢. System In-Line memory Module d. None of the above Computer designers, to increase the computer system though put use a. Direct Access Memory b. Flash Memory c. Cache Memory d. Sequential Access memory Elements of Boolean Algebra are a. Boolean Constants b. Boolean Variables ©, Both a, and b, d. None of the above Which of the followings are the functions of an Operating System? a. Control Basie Input /output Devices b. Allocate system Resources c. Managing Storage space d. All of the above System Software includes a. Cimeesiinn Sennen b Comnilersand data resources are called as 21) The programs, which help the user to be’ | a. Service Software Software c. Library Programs d. Device Drivers | 22) _ Pixel is an abbreviation of a. Point Element b. Poi é 23) A line can be drawn with the following statement Picture Element d. None of these a. Line b. Draw k Botha & b d, None of the above 24) ‘Name the error, Which you think to exist in the fc c DIC | a. Logical b. Syntax c. Execution @None | | 25) In MS-Word, Which of the followings present alternate words’ \ a. Spell Check b. Find @Fhesaurus 4. Rename | 26) Monthly Minimum charges for B-3 Industrial Consumers are?” \ i a. Rs. 2,000 b. 5,000, c. $0,000 d. None of above 8 | 27) Monthly Minimum charges for B-4 Industrial Consumers are? | a. Rs. 50,000 b. 100,000 c. Rs.500,000 d. None of above R \ Numeric Tariff Code 06 is used for TOU Consumers of category? | a. Domestic b. Commercial cc. Industrial d. Tube well R ' Sometimes Payment made by a consumer is wrongly posted to other consumer due to data entry error. To rectify this error which Input CP's form is being used? a. CP-52 b. CP-138, c. CP-136, d. CP-139 8 As per NEPRA Tariff an industrial connection having load 15 KW will b led under Tariff category? oo g a. Bel b. B-2 c. B-3 d. B-4 Input source of MIS-STAT file is? re) a. CP41-FILE b.TOTAL-FILE —c. CP110-FILE d.None of above ~~ How many type of information (Sections) are included in MIS-STAT=13F Report? as b.6 ‘. a8 ‘S How many types of transactions are posted through CP-139?PART- I (Objective) 34) Meter Replacement activity is being fed through? a. CP-136 b. CP-137 c. CP-138 d.CP-139, 38) In CP-052 (Bill Adjustment Input Form), which card type is being used to adjust only amount without units, aA b.B ec aF 8 Please encircle (O) the True or False, 36) Numeric Tariff Code 50 is used for Agricultural Flat Rate Consumers , (True / False) s 37) Neelum Jhelum Surcharge is not being levied to Private Agricultural Consumers. g (True/ False) —S 38) Monthly Fuel Price Adjustment is not applicable to Life Line Domestic Consumers. (True / False) e 39) As per NEPRA Tariff no fix charges are being charged to D-1(a) Agricultural Cons. (True! F: 40) Tariff Code 41,42,43,44 is used for Scarp tion Tube well Consumers. (True / False) & 41) An append query adds a group of records from one or more tables to the end of a table. (Priel False) . a 42) MS Access is a relational database management system (True / False) 43) Database design plays an important role in achieving the goals of efficiency, L speed and consistency. (True / False) (True False) = 48) Dbase, FoxPro, Oracle and Recital are word processors. (True / False) 44) Arelation may have multiple primary k 46) USBstands for_nwew oud bus 47) PDF stands for Sa wer Sours 48) UMLstands for___\QxSied wrdssois 49) XML stands for_Uvrewsi\o woh 50) In ERP Systems, ERP stands for {os Pe END OF PART- I (Objective)ROLL No. WAPDA EXAMINATION CE Departmental Promotion Exami From AD(Computer)iJr. Programmer to DD(P/SA) (PROFESSIONAL) ation PART-I (Objective) Fime allowed: 1 Hrs Max, Marks: 50 Attempt all Questions. Clearly encirele (O) to the correet option in multiple che Yes/No and True) Questions below carry one mark. 1. The process of starting the computer is called Working @)_ Booting Preparing d. Initiating 2 Microwave transmission, coaxial cables and fiber optics are example of a. Modem c. Gateway b. Routers @)_ Communication Media 3. Flash Drive is used for a. Input c. Output @ vo d Calculation 4 Which of the followings is not a semi-conductor memory? a. ROM c -RAM b. PROM @)__ None of these 5. Which of the following is the most common protocol used for receiving E-Mails a FTP. ©) PoP b, SMPT d. JPEG 6 How many types of busses are there in computer architecture a. One c. Two @) Three dour 7. Which of the following buses is used for specifying memory location a. Control Bus c. Data Bus | @) Address Bus d All of above | Which of the followings is used to produce soft copy? @. Laser Printer (Q) b. Plotter d i 8 SIMM stands for a. secondary In-Line memory Module Single In-Line memory Module b. System In-Line memory Module None of the above10 1. 12. B. 14, 15. 16. cA 18. 19. 20. You plugged a new laser printer to a computer having windows2000 installed. What is true? a. The printer will work © Youwill be required to install the printer driver ». You will be required to rebool the Computer 4 None of above What is the name of inbuilt feature in windows that allows you to browse through files and Folders? a. Internet explorer © _ Windows Explorer b. Windows Navigator d. Windows Map per If you are using Windows, Which 3 keys should you press to restart the computer? ) Ctrl, Alt, Del ©. Caps Lock, Alt, De! ». TAB, Alt, Del d. SHIFT, Alt, Del Which of the followings is a 16-bit code a BCD @ Unicode ©) Ascii di) EDCDIC What is the full form of ASCII? a. All Standard Code For Information ©. American Secure Code For Interchange Information Interchange ». American standard code for information @) American standard code for interlinking information interchange Ifyou have multiple windows open at the same time, which key combination allows you to switch between windows? a Press Ctrl and V / c. Press Ctrl and Tab b. Press Ctrl and K Sg. Press Alt and Pause The four main functions of a computer are @) Input, Processing, Output and Storage c Learning, Thinking intelligence and Virtuosity b. Data, Information, Bits and Bytes d. Hardware, Software, Modeling and Operations Name the error, Which you think to exist in the formula C=C*DIC a. Logical Syntax ». Execution @ None XVGA resolution is 5 a. 640 X 480 c ay b. 800 X 600 @) 24+3*4eD = 2? a 80 G50 b. 400 6 26 Agigabyte is equal to: a. One Thousand Kilobytes © 1024 megabytes24 22. 23. 24. 25. 26. 21. 28, 29, 30, a b. 1024 X 1024 megabytes 4. None of the above Why does software have bugs? a. Miscommunication or no communication c. Programming errors b. Changing requirements d. Time pressure All of Above Which of the following is the entering point in Windows? a, My Computer Q Desktop b. My Document 4 dows Explorer Which of the following formula is equal to 6: a. 9-2°344/2 c -142°3-8/2 b. 8-2°3+8/2 gd. #2°3-4)2 Which of the following is not a feature of simple word processor or text editor: a. Insert Text Word Wrap €@ > Macros d. Search and Replace Font size is measured in: (@) Points c Pixels b. Dots a, Inches One who provides the analytic functions needed to design and maintain applications requiring a database. a. database administrator ©, database analyst b. database designer @ None of above Which of the following menu contains “Picture” command used to insert a picture stored ina file on disk? a. File c. Format b. Table @ insert Which of the followings is not true about normalization? a, It Increases the number of tables ©. It slows data retrieval b. It Minimizes the Null Values a. rinating repeating attributes from ase Laser beam technology is used in a. Monitors c. Magnetic tapes (©) Optical disks d Ram In Excel, in order to copy the values of a column having formula which options of the Edit menu are used ) Copy and Paste Special c Cut and Paste Special b. Cutand Paste d. Copy and Paste Ina TCP/IP network, which of the following must be unique for each computer in the network? @® 1P Appress & SUBNET MASK b. DEFAULT GATEWAY a. None of'above oe24 22. 23. 24. 25. 26. 28. 29. 20. u b. 1024 X 1024 megabytes 4 None of the above Why does software have bugs? a. Miscommunication orno communication <.-—-Programming errors b. Changing requirements d. Time pressure Allof Above | Which of the following is the entering point in Windows? a. My Computer Qg Desktop b. My Document d Windows Explorer Which of the following formula is equal to 6: a 9-213+4/2 c. 1#2°3-8/2 b. 8-2°3+8/2 gd +2°3-4/2 Which of the following is not a feature of simple word processor or text editor: a Insert Text c. Word Wrap © Macros d Search and Replace Font size is measured in: (2) Points c Pixels b. Dots a inches One who provides the analytic functions needed to design and maintain applications requiring a database. a, database administrator c. database analyst b. database designer © None of above Which of the following menu contains “Picture” command used to insert a picture stored in a file on disk? a. File c. Format b. Table @ insert Which of the followings is not true about normalization? a. It Increases the number of tables ©. Itslows data retrieval b. It Minimizes the Null Values a. It eliminating repeating attributes from database Laser beam technology is used in a. Monitors c (&) Optical disks In Excel, in order to copy the values of a column having formula which options of the Edit menu are used @) Copy and Paste Special c Cut and Paste Special b. Cut and Paste d.° Copy and Paste Ina ‘CP/IP network, which of the following must be unique for each computer in the networ @&) |P AppRESS SUBNET MASK b. DEFAULT GATEWAY d None ofabove32. 33. 34, 35. 36. 37. 38, 39, 40. 4 What is the function of a Hub? @ Mt allows the computer to connect to ott ©. It allows the computer to connect to the ~~ computers nternet b. It allows color display to function with a d. It helps attach a printing device to the VGA display card computer Which Visual Basic debugging(any debugger) to monitor a particular variable or expression? a, Watch window €. ——_Breakpoint @ Immediate window d. Call Stack dialog box We can protect personal computer by applying password at a. Mother board Level. b) User login Level. c. @ Screen Saver Level All of above It is device that translates a computer's digital signals into analog form for transmission over telephone wires. Which of the following device(s) fits this description? a Sound card Modem What is a header in a document? a. Text at the bottom of every page (b; Text which appear at the top of every page. What does a document contain? @) Data about a set of similar things b. Asset of different graphics What can you NOT do with a spreadsheet? a. Analyse data QD Create forms What is a report? a. a.) Reports allow users to extracts information as hard copy (printed output) b. A tool which allows text and graphics to. be placed in documents lephone set Scanner Numbers which appear on every page None of above Mainly text None of above ? Calculate data None of above Reports provide a very flexible way of creating and editing documents None of above Which one of the following is not a wireless communications device? a. Satellite dishes b. Paging devices e Remote control c, @) Cellular telephone Modems. Which of the following component(s) belongs to a graphical user interface? a Windows © Dialog box @® Allof the above b 6 Icons Menus42, Hardware failures like a hard disk crash may result in losing an important data. Which of the following utility programs is a best preventive measure against'such disasters? a Data recovery Disk repair ¢ Data compression @ Backup e None of the above Questions below carry half mark. : - 43. In MS Word Thesaurus is bullt-in option that allows auto comection, ‘True ‘| False 44. Drawing tool of Power Point are not available in MS Word True | False 45. Can we install MS Office XP and Windows98 at same CPU Yes / No simultaneously? 2 : 46. Cache memory are provided to increase the capabilities of the Troe / False computer = 47. We can easily insert a new worksheet in excel fle but its default True / False name could not be changed _ 48. A link isa physical or conceptual connection between object instances True / False 49. Normalization is converting the tables into a standard form true / False 50. Optical cable is made of fine quality alloy of copper. True | False 51. We cannot install two LAN card on same computer simultaneously True / False 52. MS Access is a relational database management system True / False 53. Arrelation between table may have multiple primary keys. True / False 54. An append query adds a group of records from one or more True / False tables to at the cursor point of the table _ 58. Earth(Ground) is essential in the computer installation to avoid True / False passing of power surge to the earth L 56. We can easily insert a new worksheet in excel file but its default True / False name could not be changed. — 57. Scanning of quality picture does not effect on size of file by scanning True | False at different resolution __ 58. Mouse is also known as pointing device True | False 59. Ethernet card is use for dial up connectivity with ISP. True | Féise 60. PDA Stand for Rewer SAK cmd 61. PPSis file format of _Cousen wa 62. SMTP stand for Ssym@hs Word Ssarndroy guhels . 63. HTTP is the abbreviation of SNR Sse Ne Seay g our 64. Open Ended rectangle in flow chart is used for _ 2 §5. If the primary key is, grade de up af a group of two or more fics, it is called? gis , $8, The formula lo find oul moan score of (E9:E16)is _7 §7. FAQ stand for Sax} oh 68. WYSIWYG stands for \ eh La dud Wen GohROLL No. Departmental Promotion Examination From AD(Computer)/Jr. Programmer to DD(P/SA) January -2010 (PROFESSIONAL) PART-II (Descriptive) Time allowed: 2 Hrs Max. Marks : 50 Attempt all Questions. Identified the area from one of the functions of your office , which you think 20 should be automated. Put up a workable proposal to your head of department _ for the same. The feasibility submitted by you should be economically viable our source development. OR Write note in brief five of the following: ‘+ Main features/advantages of Power Point + List any five functions performed through control panel. % Major groups of viruses Identify file format of *.docx, *.pdf , *.ccr ‘png, ‘avi, *.rar Machine name and IP number Write short note on the Six of the following % SIP ~ Comparison of RAM and cache memory Main Difference between ASP and PHP * Mail merge Secure websites and must be covered all aspects required for a complete proposal, Also, | fl express with justification that weather this will be in-house development or |A comprehensive note on GIS. (Hints: definition, scope of the works, software, hardware, application in different fields, Advantages, etc) 5x4=(20) and high level formatting System restore utility Major Function of operating system ntage of "F1” key Ad + Data archiving 5x3=(15) Roaty Gienpe Sy eciente device and Bluetooth Open source vs licensed software + Virtual Machine * Bio Metric Scanning[A WAPDA employee can become a Guarantor of the borrowexs in more No maternity leave can be granted to a female WAPDA employee under the Pakistan WAPDA Employees Leave Rules. } No Wapda employee shail encourage meetings to be held in his/her honour or presentation of addresses to praise him or her | The recipients of cash medical allowance are not entitled for X-rays / pathology tests and dental treatment free of cost from Wapda Hospital than one case. ¢ | An advance may be made to an employee equal to 36 months pay for ‘All leaves count as qualifying service for the purpose of pension except Daily allowance is not admissible to a WAPDA employee on an official visit between the twin’s cities of Islamabad and Rawalpindi 4 extraordinary leave. 5 ‘A WAPDA employee in Grade-18 is not entitled to travel by air even on (b) Rules & Requlations 1. Tick True or False 07 a a Dispensary. ‘() wv) purchase of plot for construction of house wi) (wii) (viii) transfer from one station to another. jw &) KWAPDA employee on retirement from service is entitled for traveling allowance upto his home town under the WAPDA Employees TA Rules. The officers and Members of the Executive Committees of WAPDA Sports Board shall be treated as on duty and will be entitled to TAIDA | when attending such meetings | Under the Removal From Service (Special Powers) Or Ordinary pension means pension other than extraordinary pension. K deficiency of six months or less in the qualifying service for pension of a Wapda employee shall be deemed to have been condoned automatically. nance, 2000 competent the accused is not required for personal he: authority. ing by ‘The revised rate of community service of Wapda for Gr-18 officers is Rs.100/- P.M. | days leave on medical “AWAPDA employee can be allowed 365 grounds during entire service. qt - f False e ei - € False | c tw i e fi False |W 1c False |Tv) TR | n False ivy TA ° _| d False [ (wil) [A —_| pr Faise2 Complete the following: () | AWAPDA employee who intends to transact any purchase. sale or disposal by other means of movable or immovable property exceeding in value of Rs_ in case of officers in BPS-16 and above No WAPDA employee shall construct a ____ whether intended to be used for residential or except wi authority. the prior permission of the competent [As per Pakistan Wapda Traveling Allowance Rules 1982, the category-I employees are entitled for for the purpose of railway accommodation while on official duty within country. | The maximum limit upto which personal effects can be transported at Authority's expenses, in case of category-I employees will be ___ if possessing a family and if not possessing a One dajly allowance at special rate shall be payable to a WAPDA employee for every kilometer of road aistance. | Re-imbursement of medicine to a WAPDA employee is restricted to__Slne months pay in a financial year for patients. Afemale WAPDA employee, on the deaih of her husband, may be granted special leave on full pay, when applied for not exceeding _| 3° days. This leave shall not be debited to her _leowe scours |[AWAPDA employee may be granted lezve preparatory tor period of "3 6S" days, ement upto @ maximumROLL No. \ i? WAPDA Examination Cell / (Power Wing candidates) \7 Departmental Promotion Examination Form Assistant Director (Computer) BPS-17 to Deputy Director (Computer) BPS-18 for the Yea -y 2009 100 Pass Marks: - 50 PAPER - B (TECHNI ‘Total Marks: PART- I (Objective ime allowed: - 30 Min. Attempt all Questions. Max. Mal 50 Every question carries one mark. Please Encirele (0) the correct option. » I is device that translates a computer's digital signals into analog form for wonsmission over telephone wires. Which of the following deviee(s) fits this description? a. Sound card b. ‘Telephone set ©) Modem E Scanner e. Answers band ¢ 2 Which one of the following is not a wireless communications device? a. Cellular telephones b. Paging device: Satellite dishes @® Modems Remote control 3) Which of the following terms most precisely refers to the process of loading an Operating system into a computer's main memory from disk? a. Diagnostic routines b. BIOS & Loading @® Booting ©. POST 4) In an operating environment, if you have to type in all you are commands then which of the following best describes that environment? Command-line interlace Bb. Menu-driven interlace €. Graphical User Interiee (GUD) d. Network user interface © Online interface. 5) Which of the following component(s) belon a. Windows b. — Teons Dialog box Menus ¢ d @B _ Allof the above toa graphical user interface”? lors6) v 8) %” 10) 1) 12) PART- I (Objective) Which one of the following falls under the category of applications software? a. Medical reference software b. Phone books c. Integrated software d. Desktop publishing All the above Columns, rows. cells and labels are which soliware’s principle features? a, Presentation software b. Word processing soliware © __ Spreadsheet soltware % Database soltware ©. Communications softw: Fields, record: and files are which sofiware’s principle features? a. Presentation soliware b. Word processing software ¢. Spreadsheet sofware © _ Database software € Communications software Which part of a computer system assists the CPU in processing data and is used as a “work space” for the processor? Hard disk Floppy disk a b. © RAM BIOS wi Monitor hich one of the following memory types is not a permanent Floppy disk / @) kaw Hard disk 4. CD-ROM ©. DVD-ROM Which one of the Following devices is not an input device? a. Mouse b. Microphone CG) Headphone d.—— Scanner e. Keyboard Which one of the following device is not an output device? a. Printer b. Monitor ©. Modem Speakers Microphone ors14a) 15) 16) 17) 18) PARE PeOhpotiy Hardware failures like a hard disk crash may result in losing an important data Which of the following utility programs is a best preventive measure such disasters? inst a. Data recovery b. Disk repair Data compression Backup None of the above Which one of the following does not belong to systems sofiware cat a. Operating system b. A language translator Utility programs Database Management System © Defragmenter Which one’of the following is not opera a. Format disk b. Provide an imterface c.—_ Rename files d. Managing tasks Providing comput Flow many maximum number Windows 3.11 ora DOS Ti @® BS characters plus three extension characters 2 system's basic funetion? 1 capability aracters can be used in naming b. 16 characters plus three extension characters ¢. 64 characters plus three extension characters d. 128 characters plus three extension charac ©. 256 characters plus three estension el How many maximum numbers of charact be used in nam Window95 file? a acters ® sears € eters d. 128 characters ©. 256 characters Which one of the following is a 32-bit operating system? a DOS Windows 3.0 Windows 3.11 Window 95 Answer ¢ and d19) 20) 2) 22) 3n) 32) 33) 34) 35) 36) 37) 38) 39) 40) ¢ encircle (O) the True or PART- 1 (Objective) ‘alse. Income Tax is collected from all the Commercial consumers, (rue / False) 8. ED code and “1” indicate domestic consumers. (True / False) & User password is changeable (Lfae / False) ‘There are devices which can be used as Input & Output simultancously pee (True / False) fuses UPS is a physical part of computer (True / False) Adjustment is not part of Assessment (True /Falsey Modem is used for communication between two computers through telephone tee line. (True / False) ya Internet can be defined as network of neworks. (rue / False) Email cannot be prepared / written without logging to Remote computer. (Prue / False) : a DIR statement shows all the contents of the file in a folder (True / False} CUT and PASTE are same command as COPY and PASTE in PC — (True / False) A spread sheet ereated in MS EXCEL cannot easily be exported in any other por package of MS office (True ! False) MS EXCEL is basically used to crest efficient spread sheet (1 Fie / False) KEY is required in sequential file (1rie / False) ADD is reserved word in COBOL Lan: (True | False) — ams (Tue / False) Falsey R An EDITOR is the sofiware to create and edit source pr Currently our MDI master file record is 1090 character long (1 CP-110 is weekly cash report (Prue / Falsey R CP-4L is cash report (Prue / False) CP-106 is weekly cash report (True / False) CP-108 is weekly cash report (True / False) GST is not applicable to all Commercial consumers (True / False)41) 42) 43) 44) 45) 46) 47) 48) 49) 50) PART- 1 (Objective) tt Flow charts provide guideline to user for eoding the program — (True / False) Mi jum charges of three phase domestic consumer is R8A5/- (True! False), Govt. department code composes of six alphanumeric (Prue / False) ry Write Open VMS mands to copy a file FEF.COB to FFE.BAK Write a Open VMS command to mount a tape on device DUAO Write a command to check the file creation date and time in Open VMS. Write a command to check when the file was last modified in Open VMS Write a command to show all files including sub directory files in Open VMS oe Stand for woede ws \ydaash. F VMS stands for_ Was) Nenana Syn END OF PART. 1 (Obj(b) a (iv) () (i) ‘No maternity | (i) | No Wai Rules & Requlations Tick True or False ‘can be granted to a female WAPDA employee under the Pakistan WAPDA Employees Leave Rules. ai allowance are not entitled for X-rays / pathology tests and dental treatment free of cost from Wapda Hospital! Dispensary AWAPDA employee can become a Guarantor of the borrowers in more | True than one case. ‘An advance may be made to an employee equal to 36 months pay for purchase of plot for construction of house. (vi) (vii) ) (vil) | All leaves count as qualifying service for the purpose of pension except extraordinary leave. > j (xy Daily allowance is not admissible to a WAPDA employee on an official visit between the twin's cities of Islamabad and Rawalpindi 3 is entitled for traveling | True. The officers and Members of the Executive Committees of Sports Board shall be treated as on duty and will be entitled to TWDA when attending such meetings Ordinary pension means pension other than extraordinary pension. A deficiency of six months or less in the qualifying service for pension of | True aWapda employee shall be deemed to have been condoned | automatically. > (xiii) | True the accused is not required for personal hearing by the competent Le authority | (xiv) | The revised rate of community service of Wapda for Gr-18 officers is True Rs.100/- P.M. | Gu) | AWAPDA employee can be allowed 365-days leave on medical + grounds during entire service | FalseComplete the following: = WAPDA employee who intends to transact any purchase, sale or disposal by other means of movable or immovable property exceeding in value of Rs._\’Ss7me2,\ in case of officers in BPS-16 and above No WAPDA employee shail construct a Noun Ayia whether intended to be used for residential or Crwrney zac, excapt with the prior permission of the competent authority. | As per Pakis Pakigtan Wapda Wapda Tyavating Al Allowance Rules 1982, the category-I employees are entitled for Sw for the purpose of railway accommodation while on official duty within ay iy_| The maximum limit upto which personal effects can be transported at Authority's expenses, in case of category-! employees will be Gye wowlt.s if possessing a family and Kae witht 9 if not possessing a family. i) | One ely allowance at special rate shall be payable to a WAPDA employee for every ;__\h kilometer of road distance. |i) | A WAPDA employ is restricted to_GWe Re-imbursement of medicine to a WAPDA employ months pay in a financial year for patients. | Afemale WAPDA employee, on the death of her husband, may be granted special leav on full pay, when applied f for not exceeding Van days. This leave shall not be debited ther Leas Seosre GC coe | period of AG¢ days.wer” ROLL No WAPDA EXAMINATION CELL Departmental Promotion Examination Assistant Director (Computer) BPS-17 To Dy, Director (Computer) BPS-18 January -200@ PAPER — B (TECHNICAL) PART-I (Objective) Time allowed: 1 Hrs Max. Marks: 50 Attempt all Questions. Every question carries one mark. (early encircle (0) the correct option in multiple choices. {. AVMS user having same group is identified by a. Password c. System Privileges b. UIC GD None of the above J. Which of the following is the most common protocol used for receiving E-Mails a. FTP © ~~ pop b. SMPT d JPEG 4. Which of the following is not hypertext language a. HTML «. XNIGL b. WML @® — coson 4, Which of the following is not an application package a. Excel c MS Word @) Unix d Corel Draw Default parameter with Sort command in OPENVMS is a. Descending c Equal () Ascending d None of the above Which of the media type you will chose as widely supported media for readily available network a. Air © Copper b, Glass d Radio What kind of client office network you proposed for 80 computers extendable by 50 % computer with ensuring highly security working environment. a. Internet & Mainframe terminal b. Peer to peer CG) Server based - Page 1/4Identify the proper word for a hardware or software problem that causes the information to be lost or malfunctioning of the computer or sometimes can , causes permanent damages to a computer is @) Crash c. Dump b. Disaster d None of above. |). The SIP can be defined as @) Session Initiation Protocol c. Session Initiation Procedure b. Signal Initiation Protocol d Signal Identification Procedure f}0. Which is of the following is used by Microsoft to describe a server based network. jomain c Session b. Workgroup d LAN 2. Testing that attempt to discover the defects of the entire system rather than of its individual components. a. System Testing & Software Testing b. Structure Testing @ _ None of Above (2. The Internet is a, ALAN © AWAN b. AMAN d None of Above. {2 Which of the following RAID level provide the faster read and best fault tolerance @® RAID Level X c RAID Level 5 b RAID Level 0 d RAID Level 1 Which of the following component is unique for each network card A Frame type CRC Address © IRQ D) MAC Address {§ Which of the following cables types is for the highest band width A Coaxial Fiber Optical c sTP DUTP (1. This topology is highly fault tolerant. As the every computer has multiple possible connection paths to the other computers on the network, so a single cable break will not stop network communications between any two computers Ring c. Mesh Star d Bus Page 2/4Ii, Nodem is usually installed on a. Power-Socket Cc. Parallel Port b. Serial Port @) —_ None of the above a. Universal Parcel Services _d. Uninterruptible Power System b. Uniform Power System @) _None of the above Ht), Which of the ollowing is no true for normalization. a. In increase the number of (c) It slow data retrieval tables. b. Itminimize the null valued It eliminates the repeating attributes from the table SPSS has capability to accept false hypothesis by applying statistic method on accurate frequency distribution, The session layer provides enhanced services useful in some application, eg remote login, remote file transfer The presentation layer aécept data from the s yer and pass these to the network layer and ensure that the pieces all arrive correctly at the other side, ssion | ‘There is no risk by maintaining database control at one device as the oracle has powerful database structure We can maintain two domains simultaneously with same name connected with cach other at same network. Arouter is a relay device that is used to connect two or more networks through WAN only. It fault tolerance capacity failed if the primary link broken or busy, Excel spread sheet allows calculation of depreciation(accounting calculation for asset management) like by using double-declining balance method Writing rule of program called syntax Computer cannot be used as Fax machine WIN32 format provide more security feature from NTFS format at file folder level. More /O intensive the database the least subsystem bandwidth you need. Since the tablespace belongs to database so it can switched between read wite and read only status, In SQL truncate statement is equal to delete statement. > Use of WHERE Clause is advisable in production based queries. True/False = TruelFalse i True/Faise a True/False _ True/False True/False True/False TelFalse Tere True/False we True/False True/False Ken False True/False Le True/False Page 3/4leges of use: butnobal Tuell alse 6 group of users te Scanning of combined image of passport size photo of 17 different person at True/False atime disallow to separate photo of each person at later stage - 0) file at one device as the True/False There is no risk by mainta oracle has powerful database structure. Bluetooth may define as a short-range radio technology aimed at True/False simplifying communications among Internet devices and between devices and the Internet. It also aims to simplify data synchronization between Internet devices and other computers Le Cable Cat 5 Data grade up to 16 Mbps, four twisted pairs. True/False ee Performance of RSS proven less effective in widespread usage of news True/Faise distribution on the Web. be Ahub is basically a signal splitter; A eight port hub would re: packet on one of its oorts and - Free ware software are copy protected software and its license need to True/False te acquired _ Aselected file can be restored from the backup cartridge (index True/False sequential) containing the full disk backup _ We cannot draw drawing objects (shapes) in Excel like power point, c. Using queries - d. None of above 12) What are the stages in the development of a Database? Store, select and analyses information a b. Enter, search and find specif @) Data investigation and data modeling d. None of above questions 13) Software can be divided into two areas Network software and security software Systems softy are and application software Business software and games software None of above = ° © 14) What is the function of systems software? a To collect data @) Toexceue programs To maintain security d, None of above 15) Systems software can be categorized into: ‘ G __ Operating systems and system servicesPART- I (Objective) 16) Key information in MIS-STAT-FILE is based on a. Reference No. b. Batch & ©. Sub Division - d. All of above 17) InMIS-STAT-FILE information can be extracted for a. Current Month Only b, 12 months 24 month d All of above 18) Input Source for creation of MIS-STAT-FILE is a cP-41 b. CP-110 c Total File 4. Master Files 19) On MIS-FILE & MIS-DEF. S), information of current month is posted from a CP-41 b. cP-110 «2 c. Total-File d. Master Files 20) This technology consists of electromagnetic devices and systems for communicating over long distances, Which of the following terms best represents the above mentioned description? a. Computer technology GB) Telecommunications technology «, Information technolo; d All of the above e, Answers a and b 21) Which one of the following does not belong to systems software cat a. Operating system b. A language translator S) Utility programs Database Management System e Defragmenter Which one of the following falls under the category of applications software? a Medical reference software b, Phone books & Integrated software24) 28) 26) ™ 28) 2) 30) 30 The Data Division of a COBOL program. a b. «, Identifies the program Deseribes records to be used in a program. (7 None of above. You can infer that a WRITE instruction would cause: a, b, ¢, ‘An OPEN statement must be en a, b. ©, A record to be written, or placed, in an output file. A record to be accessed from an input file. A record to be displayed on console. ecuted before the use of: A file on the printer The console typewriter Reading a file. Go to statement is used to @ b. ©, Go to a specific paragraph. Go to and back to the statement next to the GO TO statement. Go to the end of file statement. Batch processing refer to consumers of a, b. ©, d. One subdivision only Usually consumers who belongs to same area All consumers whose reading is same None of the these WWW the internet is abbreviation of b, World Wed Web Word Won Web S Web Wide World None of the above In VMS having same group is identified by a b, & Password uIc System Privileges None of the above Netscape and Internet Explorer are popular Search engines Word processors Both spread sheet and word processor None of above Any Personnel Computer can communicate to VAX using a b. ©, Kermit Smarterm Window Terminala ) 34) Ple 36) 41) 2) 4) 44) 45) 46) 47) 48) Printer is usually installed on a, SVGA Port b. Mouse Port ©. Power Socket @ None of the above Which of the following is a low level language a, COBOL. b, FORTRAN cH d. Machine Language Operating system for mini computers installed at circle is known as a VMS, b. DOS 7 c. Open VMS S d Windows Which of the following is not opera tems basic function a. Format disk b. Providing interface Rename file Managing tasks ¢ fill in the blanks with suitable words. ‘The file name extension is of_“{ chi VER shows the VERS{6Wor the DOS currently in use Wend RENAME or REN command gives a name to a Commonly used spreadsheets are E: and Sofiware is a collection of _U tux ills - are written by the users themselves to solve their specific problems. BNW _ is the langu COBOL was specially designed for _ WAN Stand for yo ota wehisol SVGA Stand for aged Sv \Neo ie sey LCD Stand for hor — —Asigch Condo raglan > TCP/IP stands for S us | Wbeyasd we of Os and Is. ? 56 __ purposes in PM ae for See a 4) VMS stds for _\)v' jus) MARU wa st 50) FDL stands fort ‘VR Aw Qos | Awul |