04 March 2010
Multiple Choices: 1) The capability to process multiple programs concurrently for multiple users is…………………… a) Multiprocessing b) Multiprogramming c) Multitasking d) Multithreading 2) Small files that r deposited on a user’s hard drive when they visit a web site, r called……………….. a) Cookies b) Codes c) Profiles d) Trackers 3) What is a function of a database management system (DBMS)? a) Identify what a user needs b) Deciding what to do with legacy systems c) Guaranteeing the integrity & consistency of the data in the database d) All of the above 4) Data dictionary is a database, which consists…………………… a) Definition of the data elements & their relationships b) All English words c) Both A & B d) Neither A & B 5) An attempt to slow down or stop a computer system or network by flooding the system with requests for information is called a……………. a) Virus b) Worm c) Denial-of-service attack d) Trojan horse 6) MS-Power Point is used to create……………….. a) Documents b) Presentations c) Images d) Movies 7) ……………….allow you to set actions that will be performed automatically after a message that meets the set criteria. a) Rules b) Filters c) Folders d) None of the above 8) In Visual Basic 6.0, which control is used to receive input from the user? a) Text box b) Label c) Caption d) Drawing 9) Which of the following is not true for a variable name in Visual Basic? a) It must be less 255 characters b) Period & underscore r allowed c) No spacing is allowed 10) Which of these CAAT uses software to compare the executable version of program with a secure master copy? a) Audit s/w b) Embedded code c) Program code analysis d) Core image comparison 11) Which of these is not a functional capacity of generalized audit s/w? a) File access b) Selection c) Filtering d) Arithmetic operations 12) In Excel, a cell reference A$2 is absolute as to……………………… a) Absolute cell reference b) Name cell reference c) Relative cell reference d) Effective cell reference 13) The basic cell reference that adjusts & change when copied or when using auto fill is…….. a) Absolute cell reference b) Name cell reference c) Relative cell reference d) Effective cell reference 14) The analysis tool used to summarize data based on columns & rows of a database is…………… a) Subtotal b) Advance filter c) Sort data d) Pivot table 15) Which of the following is not considered a pointing device? a) Stylus b) Keyboard c) Touch pad d) Mouse 16) Electronic Data Interchange is used to………. a) Exchange E-mail b) Send databases back and forth c) Make correction in other databases d) Exchange business documents in standard format 17) In a relational DBMS……………. a) Data is independent on program b) Program & data r independent c) Program is dependent on data d) None of the above 18) Referential integrity ensures that…………………. a) No two records in the table have the same value in the field that defines the primary key b) The relationships between records in related tables remain valid c) Both A & B d) Neither A or B 19) Voucher entry screen can be customized using……………………shortcut key a) F3 b) F6 c) F11 d) F12 20) A………………………….is a method of electronic mail transfer where e-mail is distributed to a set list of recipients from a central point. a) E-mail b) Mailing list c) Fax d) Attachment 21) In visual basic 6.0, picture box is a control that is used to handle……………… a) Input b) Images c) Lists d) Graphics 22) Verification of a digital signature is done using……………………….. a) Hash function b) Public key of the sender c) Both A & B d) Neither A & B 23) Which of these is not a system development phase in CAAT? a) Management of the change process b) Organizational & job design c) Information processing systems design d) System testing 24) IDEA stands for…………….. a) Interactive Data Extraction & Analysis b) Integrated Data Extraction & Analysis c) Interactive tool for Data & Analysis d) Interactive Data Innumerable Analysis 25) In MS-Excel, the function that is used to add together all values that meet specific criteria is known as……………. a) Average b) Sum c) Sum if d) Count if Fill in the Blanks 1) A 32-bit bus allows access to a memory of capacity of……………MB/GB. 2) …………..memory is known as non-volatile. 3) …………….in the OSI reference model, handles terminal emulation. 4) The…….technology relies on a personal area network (PAN)? 5) A DBMS that supports a database located at a single site is called a …………… 6) In MS Access …………………form displays fields in a single horizontal row. 7) A …………………….acts as a security buffer between a company’s private network & all external networks. 8) The…………….master layout of printed presentation in MS-Power Point. 9) …………………key is known only to the sender & use to create the digital signature. 10) Shortcut key ………..is used to save MS-Word document/ 11) The……….feature in word helps to correct spelling mistakes & grammatical errors. 12) Ensuring that information is not altered by unauthorized person in a way that is not detectable by authorized users, is termed as……………………. 13) The last column in Excel worksheet is…………… 14) …………….is used to apply a format automatically. 15) ……………….key encryption requires that the receiver obtain the key before the message can be decoded. 16) An assembly language program is translated to machine code by………………… 17) Sending Acknowledgement is a kind of ……………..technique. 18) Routers operate in ………………………of OSI reference model. 19) The command…………………is used to display IP address. 20) The ………………………database structure consists of a set of two or more related tables with a minimum of one shared field between them. 21) The degree of a relationship in Entity-Relationship models called…………… 22) In MS-Access, a ……………………..is an action or a set of actions that carry out task in response to an event. 23) In windows……………. is used to check for errors that may be using up disk space? 24) …………………..is short cut key for slide show view in MS-Power Point. 25) In tally, the group company must contain at least ………………… member/members. 26) ……………….is an algorithm which creates a digital representation in the form of a “hash result”. 27) Range check in CAAT, is a type of…………………… 28) ……………………….is used for CAAT as database. 29) ……………………is a rectangular group of cells in Excel.
Plez help to solve it my E-mail ID is"mynamemoin@gamil.com"
CAclubindia
