CIS 1000 Practice Questions for Exam.docx

52 Pages
Unlock Document

University of Guelph
Computing and Information Science
CIS 1000
Jing Yu Zhu

1. A(n) __________ is found in one of two states, off or on. a) integrated circuit b) binary switch c) electrical switch d) vacuum tube 2. The __________ consists of just two numbers: 0 and 1. a) binary language b) ASCII code c) Unicode system d) hexadecimal numbering system 3. The earliest computers used __________ as switches. a) cathode ray tubes b) vacuum tubes c) electrically charged plates d) transistors 4. __________ was put into use in 1945 and took up 1,800 square feet of floor space. a) IBM Blue b) Apple'sAdam c) Pentium I d) ENIAC 5. A(n) __________ is material that can transmit or prohibit the flow of electricity. a) transistor b) integrated circuit c) resistor d) semiconductor 6. A__________ is an electrical switch that is built out of layers of a semiconductor material. a) transistor b) vacuum tube c) resistor d) capacitor 7. The base-10 number system is also called: a) binary notation. b) hexadecimal notation. c) decimal notation. d) unary notation. 8. The base-2 number system is also called: a) binary notation. b) hexadecimal notation. c) decimal notation. d) unary notation. 9. The base-16 number system is also called: a) binary notation. b) hexadecimal notation. c) decimal notation. d) unary notation. 10. Using 8 bits, the __________ code can represent the 26 uppercase letters and the 26 lowercase letters in the English language and punctuation symbols as well as special characters. a) EBCDIC b) unary c) ASCII d) hexadecimal 11. Most of today's personal computers use __________ to represent each letter or character as an 8-bit binary code. a) Extended Binary-Coded Decimal Interchange Code b) Unicode c) American Standard Code for Information Interchange d) Binary 12. It takes __________ bits to make a byte. a) 8 b) 16 c) 24 d) 32 13. The __________ connects all of a system's electric components: the CPU, memory, expansion slots, and electrical paths that connect these components. a) motherboard b) transistor board c) adapter board d) microprocessor board 14. The CPU is considered to be the __________ of the computer. a) liver b) heart c) lungs d) brains 15. The PowerPC G5 processor was originally designed for the? a) Xbox. b) Apple computer. c) Nintendo Wii. d) Windows operating system. 16. __________ is measured in hertz and refers to how quickly a processor can work. a) Clock speed b) Akernel cycle c) Register speed d) ROM speed 17. MRAM stands for? a) Magnetic Read Access Memory. b) Mega RandomAccess Memory. c) Metallic RandomAccess Memory. d) Magnorestorative RandomAccess Memory. 18. MRAM uses __________ to store data. a) electrical charges b) titanium plates c) magnetic plates d) carbon nanotubes 19. NRAM uses __________ to store data. a) neutron platelettes b) carbon nanotubes c) electrical charges d) magnetic plates 20. Hyperthreading __________ than multi-core technology. a) is slower b) is faster c) uses a smaller chip d) is better at multitasking 21. Agraphics processing unit is specialized to handle? a) 3D graphics. b) more intensive calculations than a CPU. c) only processes for gaming consoles. d) processes when the CPU is overworked. 22. Which of the following statements is concerning multi-core technology? a) It uses two or more processors on the same chip. b) It is slower than hyperthreading. c) It uses its own resources. d) Is is an improvement on hyperthreading. 23. The multistep process that a CPU follows for each instruction it encounters is called? a) the CPU cycle. b) the instruction cycle. c) the processor cycle. d) the machine cycle. 24. All of the following are steps in the CPU machine cycle EXCEPT? a) fetch. b) decode. c) generate. d) store. 25. Asystem clock is built into the? a) hard drive. b) motherboard. c) expansion card. d) bus. 26. The proper sequence of actions in a machine cycle is: a) fetch ? decode ? execute ? store. b) fetch ? execute ? decode ? store. c) decode ? fetch ? execute ? store. d) execute ? decode ? store ? fetch. 27. The __________ of the CPU manages the on/off switches inside the CPU. a) microprocessor b) control unit c) transistors d) ALU 28. Clock speed is measured in? a) seconds. b) minutes. c) hertz. d) bits per second (bps). 29. Cache memory is all of the following EXCEPT? a) located close to the CPU. b) very fast memory. c) categorized by levels 1, 2, and 3. d) easy to add to an existing computer system. 30. Which of the following types of memory is optional on most computers? a) level 1 cache b) level 2 cache c) level 3 cache d) RAM 31. Which programming language uses a string of 1s and 0s? a) machine language b) assembly language c) ADA d) C++ 32. Aspecific set of commands understandable by the CPU is called the? a) instruction set. b) clock cycle. c) program instructions. d) instruction code. 33. All of the commands in an instruction set are written in a language that is easier for humans to work with, called? a) machine language b) assembly language c) ADA d) C++ 34. In a CPU, the __________ refers to the commands that a CPU knows how to complete. a) rules set b) processing set c) CPU set d) instruction set 35. In a 64-bit processor, the 64 refers to the __________ size. a) RAM b) word c) processor d) letter 36. In a CPU, the purpose of theALU is to: a) calculate and perform logical operations. b) direct the flow of instructions. c) store information to the cache. d) fetch the initial instruction. 37. __________ refers to the time it takes to locate instructions and make them available to the CPU. a) Location time b) Access time c) Fetch time d) Process time 38. Access time is measured in billionths of a second, or? a) milliseconds. b) microseconds. c) seconds. d) nanoseconds. 39. The least expensive and most simplistic type of RAM is? a) DRAM. b) DDR SRAM. c) GDDR-4. d) DDR2 RAM. 40. The __________ are on the motherboard and run between the components connected to the computer via the motherboard. a) expansion buses b) local buses c) RAM buses d) ROM buses 41. The number of bits that a bus can carry at one time is referred to as the bus: a) height. b) width. c) depth. d) measurement. 42. A__________ is a group of computers that work collaboratively on complex problems using specialized software. a) computing cluster b) collaboration cluster c) computing group d) collaboration group 43. The ability to work on more than one instruction during the four stages of processing is called? a) expanding. b) stacking. c) pipelining. d) staging. 44. The most powerful type of computer is a: a) smartphone. b) notebook. c) desktop PC. d) supercomputer. 45. The use of multiple processors working together on one large problem is called: a) inline processing. b) parallel processing. c) group processing. d) expansion processing. 46. The binary number system uses the numbers: a) 0 through 9. b) 1 through 10. c) 0 and 1. d) 1 and 2. 47. The decimal number system uses the numbers: a) 0 through 9. b) 1 through 10. c) 0 and 1. d) 1 and 2. 48. The hexadecimal number system uses the numbers: a) 0 through 9. b) 1 through 10. c) 0 through 9 and letters A-F. d) 0 through 15. 49. CPU stands for? a) computer processing unit. b) computing process unit. c) central process unit. d) central processing unit. 50. ALU stands for? a) arithmetic logic unit. b) adding logic and usability. c) alter, load, and use. d) alternate load usage. 51. Many high-end server systems employ a __________ design, in which there are two completely separate CPU chips on one motherboard a) multi-core b) multiprocessor c) parallel d) dual-processor 52. __________ is the set of memory chips located on the motherboard that stores data and instructions that cannot be changed or erased. a) Level 1 cache b) Dynamic RAM c) ROM d) Level 2 cache 1. How many steps are there in the system development life cycle? % a) 4 % b) 5 % c) 6 % d) 10 2. What is the first step of the system development life cycle? % a) design % b) analysis % c) problem/opportunity identification % d) development and documentation 3. During which phase of the system development life cycle does actual programming occur? % a) design % b) analysis % c) development and documentation % d) testing and installation 4. In the __________ phase, the problem is explored in depth and program specifications are developed. % a) documentation % b) problem identification % c) analysis % d) evaluation 5. During the __________ phase, the current and proposed systems are documented using flowcharts and data-flow diagrams. % a) architecture % b) design % c) analysis % d) evaluation 6. The __________ model is an idealized view of the software development cycle. % a) top-down % b) rapid development % c) bottom-up % d) waterfall 7. __________ is the process of translating a task into a series of commands that a computer will use to perform a task. % a) SDLC % b) Programming % c) Flowcharting % d) Diagramming 8. The method of algorithm creation used when a programmer breaks down a problem into a series of high-level tasks and continues to break each task into successively more detailed subtasks is called: % a) object-oriented analysis. % b) top-down design. % c) bottom-up design. % d) coding design. 9. __________ is a text-based approach to documenting an algorithm. % a) Flowcharting % b) Pseudocode % c) Diagramming % d) Flow analysis 10. __________ is a systematic approach in which a problem is broken down into a series of high-level tasks. % a) Flowcharting % b) Coding % c) Data diagramming % d) Top-down design 11. With object-oriented analysis, programmers identify all the categories of input that are part of the problem into: % a) blocks. % b) classes. % c) units. % d) tables. 12. In object-oriented programming, inheritance allows a new class to pick up all the characteristics of the original or __________ class. % a) primary % b) modified % c) first % d) base 13. In terms of object-oriented analysis, actions can also be referred to as: % a) methods. % b) classes. % c) properties. % d) tasks. 14. The language that the CPU understands, consisting of a sequence of bits, is called: % a) assembly language. % b) machine language. % c) second-generation language. % d) basic language. 15. BASIC, FORTRAN, COBOL, C++, and Java are all __________ languages. % a) 1GL % b) 2GL % c) 3GL % d) 4GL 16. The ability of higher-level programming languages to create programs that can be moved from one type of computer to another is called: % a) portability. % b) scalability. % c) transferability. % d) inheritance. 17. __________ generation languages give the programmer direct control over hardware resources. % a) First % b) Second % c) Third % d) Fourth 18. Avariable declaration tells the operating system to allocate space: % a) on the bus. % b) in RAM. % c) in the CPU. % d) on the hard drive. 19. The process by which code is converted into machine language is called: % a) programming. % b) translation. % c) compilation. % d) execution. 20. The binary sequence that instructs the CPU to run the programming code is called a(n): % a) source file. % b) executable program. % c) base code. % d) interpreted program. 21. Violations of the strict, precise set of rules that define a programming language are called: % a) keyword errors. % b) syntax errors. % c) source code errors. % d) runtime errors. 22. Most integrated development environments (IDEs) include a debugger that: % a) helps programmers find runtime errors. % b) eliminates viruses. % c) helps programmers find syntax errors. % d) corrects errors found during beta testing. 23. Which language do programmers use if the problem requires a lot of number crunching? % a) C++ % b) HTML % c) FORTAN % d) Java 24. Which of the following is/are NOT part of a program's problem statement? % a) inputs, or the data that is expected to be provided % b) outputs, or the information that is expected to be produced % c) pseudocode, or the text-based approach to documenting the algorithm % d) processing, or the set of steps that transform input into output 25. Which of the following is a flowcharting program? % a) C++ % b) XML % c) Microsoft Visio % d) JavaScript 26. Translating an algorithm into a programming language is called: % a) interpreting. % b) compiling. % c) coding. % d) executing. 27. Structured Query Language (SQL) is an example of a: % a) second-generation language. % b) third-generation language. % c) fourth-generation language. % d) fifth-generation language. 28. Which statement does NOT describe fifth-generation languages? % a) They are the most "natural" of languages. % b) Problems are presented as a series of facts instead of a specific algorithm. % c) They use a set of short, English-based commands (such as SUB) that speak directly to the CPU. % d) Facts can be queried. 29. Some programmers include scrollbars, title bars, buttons, and menus in a program simply by adding them to a layout through a process called: % a) visual programming % b) drag and drop programming % c) layout programming % d) window programming 30. An alternative approach to systems development, called __________, makes use of a prototype at the beginning of the project. % a) the waterfall method % b) rapid application development % c) the iterative method % d) integrated development 31. Which of the following is the current version of Visual Basic used to build applications for Windows, the Web, and mobile devices? % a) Visual Basic 5.0 % b) Visual Basic 6.0 % c) Visual Basic 2008 % d) Visual Basic 2006 32. Which statement about an integrated development environment (IDE) is False? % a) All programming languages use the same IDE. % b) IDEs include an editor. % c) IDEs provide help files with examples of proper use of keywords. % d) IDEs present all syntax errors in one list. 33. Which statement about selecting the right programming language for a project is False? % a) Some programming languages may take up too much space. % b) All programming languages require the same amount of time to execute. % c) Select a language that is easy for programmers to use and maintain. % d) Certain languages are customized to support a UNIX or Windows environment. 34. Most modern operating systems have been written in: % a) Java. % b) Visual Basic. % c) C*. % d) HTML. 35. Which of the following statements about Java is False? % a) C# XXXXX XXXXX language that competes with Java. % b) Java can run only on a Windows operating system. % c) The Java program can run on many different CPUs. % d) Java needs to be compiled only once. 36. Which of the following statements about programming is False? % a) Writing lines of programming code requires careful attention to detail. % b) Amisplaced semicolon can stop an entire program from executing. % c) Beginning programmers start out by learning first-generation languages. % d) Beginning programmers are often frustrated by their first programming experience. 37. Which of the following statements describes dynamic decision making? % a) It occurs during the second phase of the SDLC. % b) It is the ability of a Web page to display itself based on choices the reader makes. % c) It is an alternative method used in system design. % d) It is part of the flowcharting phase of algorithm creation. 38. Which of the following statements about pseudocode is True? % a) It is a basic programming language. % b) It uses shapes and arrows to represent an algorithm. % c) It is a text-based approach to documenting an algorithm. % d) It is used only with the C++ programming language. 39. Small Java-based programs called: % a) Java classes. % b) JSPs. % c) JavaScript. % d) Java applets. 40. The loop decision point consists of three features: an initial value, a set of actions to be performed, and a(n): % a) class. % b) operator. % c) test condition. % d) testing plan. 41. Flowcharts and data flow diagrams are used during which step of the SDLC? % a) analysis % b) design % c) development and installation % d) testing and installation 42. The two main types of decision points are the binary decision and the: % a) circle. % b) initial value. % c) loop. % d) variable. 43. Tags such as italics are examples of which of the following languages? % a) BASIC % b) Java % c) HTML/XHTML % d) C++ 44. Which of the following is the programming language often used to build Windows applications? % a) HTML % b) Java % c) C++ % d) Visual Basic 45. Which of the following development environments enables Web sites to talk to each other easily by introducing a standard way for software to interact through Web services? % a) RAD % b) the .NET framework % c) JavaScript % d) PHP (hypertext preprocessor) 46. Which of the following would NOT be used to build Web sites with interactive capabilities? % a) Active Server Pages % b) PHP (hypertext preprocessor) % c) XHTML % d) Java Server Pages 47. Translating an algorithm into a programming language is the art of: % a) interpreting. % b) coding. % c) flowcharting. % d) compiling. 48. In object-oriented programming, each object from a given class is described by its: % a) derived class. % b) initial value. % c) data and methods. % d) input and output. 49. Which of the following is the first stage of the PDLC? % a) debugging % b) coding % c) a plan % d) the problem 50. Which of the following statements is NOT an example of a binary decision? % a) "Did you work at most 8 hours today?" % b) "Did you receive your online order?" % c) "How much was the purchase?" % d) "Do you want a catalog?" 51. Keywords in a programming language that allow the programmer to redirect the flow of the program based on a decision are called: % a) pseudocode. % b) control structures. % c) directions. % d) operators. 52. Who is responsible for writing internal documentation for software programs? % a) copy editors % b) technical writers % c) programmers % d) users 53. Which language is used for applications that need to collect information from networked computers? % a) HTML % b) Java % c) COBOL % d) FORTRAN 54. Which of these components is NOT common to all programming languages? % a) syntax % b) classes % c) operators % d) data types 55. The beta version of software is associated with which part of the PDLC? % a) development of the problem statement % b) algorithm development % c) testing and documentation % d) debugging % 1. Which of the following is a reason for creating a list instead of creating a database? % a) to organize data for simple tasks % b) to prevent data inconsistency % c) to prevent data redundancy % d) to make it easier to share data in a central location % 2. Acategory of information stored in a column of a database is called a: % a) list. % b) table. % c) record. % d) field. % 3. Each field in a database is identified by a field: % a) category. % b) name. % c) label. % d) key. % 4. __________ means that the data contained in a database is accurate and reliable. % a) Data efficiency % b) Data integrity % c) Data redundancy % d) Data consistency % 5. All of the following are advantages of using a database EXCEPT: % a) maintaining data integrity. % b) data redundancy. % c) flexible use of data. % d) information sharing. % 6. In a database, a field is a: % a) category of information. % b) label. % c) table of information. % d) group of related records. % 7. Which of the following are NOT a component of a database? % a) fields % b) lists % c) records % d) table % 8. In a database, __________ fields store numbers used to perform calculations. % a) next % b) numeric % c) key % d) alphanumeric % 9. Apicture would be stored in a(n)__________ field in a database. % a) text % b) object % c) memo % d) hyperlink % 10. To store a person's last name, use a(n) __________ field in a database. % a) text % b) object % c) name % d) memo % 11.Atext field capable of holding complete paragraphs is referred to as a __________ field. % a) memo % b) document % c) paragraph % d) hypertext % 12. __________ defines the maximum number of characters or numbers that a particular field can hold. % a) Type size % b) Max size % c) Field size % d) Text size % 13. Which of the following is NOT a possible primary key? % a) social security number % b) driver's license number % c) street address % d) student ID number % 14. Another name for the primary key is the key: % a) value. % b) number. % c) field. % d) type. % 15. Which of the following is NOT a type of database currently in use? % a) relational % b) historical % c) multidimensional % d) object-oriented. % 16. The most commonly used database in the market today is the __________ database. % a) relational % b) flat-file % c) multidimensional % d) object-oriented. % 17. In relational databases, tables are linked to each other through a: % a) first record. % b) common value. % c) common field. % d) data type. % 18. Nontraditional data such as audio clips, video clips, pictures, and large documents are called: % a) enterprise data. % b) structured data. % c) unstructured data. % d) multidimensional data. % 19. Which of the following statements about object-oriented databases is False? % a) They are more complex than relational databases. % b) They use query language to access and manage data. % c) They are good at handling unstructured data. % d) They store data in table format. % 20. Large databases accessed by many users, such as those used by eBay, are usually designed as __________ databases. % a) relational % b) multidimensional % c) object-oriented % d) structured % 21. Which of the following is a database management system? % a) SQL % b) Microsoft Excel % c) MicrosoftAccess % d) Microsoft Project % 22. All of the following are operations of a database management system EXCEPT: % a) entering data. % b) viewing data. % c) outputting data. % d) formatting data. % 23. When creating a database with a DBMS, you must create a description of the data called the: % a) data type. % b) data dictionary. % c) data documentor. % d) database styleguide. % 24. Which of the following is NOT defined in the data dictionary? % a) field name % b) data type % c) primary key % d) field size % 25. Select queries and join queries both use __________ algebra to extract data. % a) complex % b) relational % c) normalized % d) structured % 26. When you want to extract data from two or more tables, you use a(n) __________ query. % a) select % b) join % c) relational % d) object % 27. In Access, the Simple Query Wizard uses __________ to create a query. % a) SQW % b) OQL % c) SQL % d) AQW % 28. The process of reducing data redundancy by recording data only once is called: % a) consistency checking. % b) validation. % c) normalization. % d) range checking. % 29. Adatabase __________ instructs a database to search for particular pieces of data. % a) query % b) wizard % c) formula % d) function % 30. A__________ relationship indicates that for each record in a table, there is only one corresponding record in a related table. % a) single-to-one % b) one-to-many % c) one-to-one % d) one-to-many % 31. A__________ relationship indicates that for a record in one table, there are many related records in another table. % a) many-to-one % b) one-to-many % c) one-to-multiple % d) single-to-many % 32. __________ means that for each value in the foreign key of one table, there is a corresponding value in the primary key of another table. % a) Referential integrity % b) Normalization % c) Database consistency % d) Record integrity % 33. Which of the following is NOT one of the data staging steps when referring to data warehousing? % a) extraction of data from source databases % b) transformation of data % c) creation of structured data % d) storage of data in the warehouse % 34. Which of the following is NOT an information system? % a) transaction processing system % b) offic
More Less

Related notes for CIS 1000

Log In


Don't have an account?

Join OneClass

Access over 10 million pages of study
documents for 1.3 million courses.

Sign up

Join to view


By registering, I agree to the Terms and Privacy Policies
Already have an account?
Just a few more details

So we can recommend you notes for your school.

Reset Password

Please enter below the email address you registered with and we will send you a link to reset your password.

Add your courses

Get notes from the top students in your class.