ITE 100 FINAL EXAM REVIEW (Chapters 10 & 13) DC2011

Multiple Choice

Identify the letter of the choice that best completes the statement or answers the question.

____ 1. All of the following are strengths of the database approach except_______.

a.	improved data integrity
b.	easier access
c.	less complexity
d.	reduced development time

____ 2. __________ backup is a database backup plan in which all data is backed up whenever a change is made to the database. It provides recovery of damaged data in a matter of seconds. (Chapter 10, page 532)

a.	Continuous
b.	Immediate

____ 3. Verifiable information ____.

a.	gives more value than it costs to produce
b.	is arranged to suit the needs and requirements of a decision maker
c.	has meaning to the person who receives it
d.	can be proven as correct or incorrect

____ 4. For database recovery, complex DBMSs maintain a log which is a listing of activities that have changed the contents of the database. The database log contains______________

a.	the before image and the after image
b.	the before image, the actual change, and the after image

____ 5. In a __________ recovery, the DBMS uses the database log to reenter changes made to the database since the last save or backup.

a.	rollbackward
b.	rollforward
c.	rollaround
d.	rollup

____ 6. In a _________ recovery, the DBMS uses the database log to undo any changes made to the database during a certain period of time.

a.	rollforward
b.	rollaround
c.	rollback
d.	rollup

____ 7. Most DBMSs include ______, a feature which has a graphical user interface (GUI) that assists users with retrieving data from the database.

a.	A query language
b.	A database form
c.	A report generator
d.	Query By Example (QBE)

____ 8. Because the _____ contains details about data in a database, some call it metadata (meta means more comprehensive and metadata really means data about data)

a.	data dictionary
b.	data mart
c.	data model
d.	data warehouse

____ 9. Concerning the hierarchy of data, a database contains files and a file contains ____.

a.	characters, a character contains fields, and a field is made up of records
b.	fields, a field contains characters, and a character is made up of records
c.	records, a record contains characters, and a character is made up of fields
d.	records, a record contains fields, and a field is made up of characters

____ 10. A ____ is the smallest unit of data a computer can process.

a.	bit	c.	field
b.	character	d.	record

____ 11. ____ is a common data type that consists of dollar and cent amounts or numbers containing decimal values.

a.	Memo	c.	Currency
b.	Text	d.	Object

____ 12. ____ is a common data type that consists of lengthy text entries.

a.	Numeric	c.	Currency
b.	Memo	d.	Object

____ 13. ____ is a common data type that consists of Web addresses that connect to a document or Web page.

a.	Hyperlink or links	c.	Yes/No or Boolean
b.	AutoNumber	d.	Currency

____ 14. Users usually add new records to a database ____.

a.	when a record no longer is needed	c.	when they obtain new data
b.	to correct inaccurate data	d.	to update old data with new data

____ 15. Generally, users change the content of existing records in a file ____.

a.	when they obtain new data records
b.	to correct inaccurate data or to update old data with new data
c.	when a record is no longer needed
d.	whenever they feel like it

____ 16. ____________ a user deletes (the data or the record) from a file.

a.	To correct inaccurate data,	c.	To update old data with new data,
b.	When new data record is obtained,	d.	When a record no longer is needed,

____ 17. When a program flags a deleted record, the record ____ process it.

a.	is deleted physically from the disk and is deleted logically because the program will NOT
b.	is deleted physically from the disk but remains logically because the program will
c.	remains physically on the disk but is deleted logically because the program will NOT
d.	remains physically on the disk and remains logically because the program will

____ 18. Deleting unneeded files on a hard drive ____ storage space.

a.	increases the size of individual files and frees up
b.	increases the size of individual files and increases
c.	reduces the number of files and reduces available
d.	increases the amount of available

____ 19. If the lowest monthly fee at a Gold’s Gym fitness center is $49.95 and the highest is $79.95, a(n) ____ on the Monthly Fee field ensures it is a value between $49.95 and $79.95.

a.	range check	c.	consistency check
b.	completeness check	d.	alphabetic/numeric check

____ 20. A(n) ____ tests the data in two or more associated fields to ensure that the relationship is logical and reasonable. (For example, your graduation date cannot be before your birth date)

a.	range check	c.	consistency check
b.	completeness check	d.	alphabetic/numeric check

____ 21. A(n) ____ verifies that a required field contains data such as a credit card number.

a.	range check	c.	consistency check
b.	completeness check	d.	alphabetic/numeric check

____ 22. A check digit is a number or character that is appended to a primary key value. If the primary key is 913457 the two check digits would be _____ and the new primary key would be ________ (Page 523 of textbook)

a.	10 91345710	c.	12 91345712
b.	11 91345711	d.	13 91345713

____ 23. A major weakness of older file processing systems is that ____.

a.	they have redundant data and they isolate data
b.	they are much more complex than a database
c.	data is more vulnerable to corruption or loss than data in a relational database
d.	all of the above

____ 24. A(n) ____ program interacts with a DBMS, which in turn interacts with the database.

a.	before image	c.	after image
b.	front-end	d.	back-end

____ 25. When compared with a file processing system, a database offers all of the following except ____.

a.	reduced data redundancy
b.	easier access and shared data
c.	reduced development time
d.	less required memory, storage, and processing power

____ 26. A DBMS uses the ____ to perform validation checks.

a.	data server	c.	data warehouse
b.	data mart	d.	data dictionary

____ 27. Commonly used methods to retrieve and maintain data include all of the following except ____.

a.	report generators and forms	c.	validation rules
b.	query languages	d.	query by example

____ 28. Although a query language can be used for other purposes, most users usually ____ data from the database.

a.	retrieve	c.	change
b.	add	d.	delete

____ 29. A personal trainer with ____ privileges to the e-mail addresses in a fitness club database could view the customer addresses but could not change them.

a.	read-only	c.	full-update
b.	write-only	d.	no access

____ 30. A manager at Gold’s Gym would have ____ privileges to member data in the fitness club database.

a.	read-only	c.	full-update (read, modify, write)
b.	write-only	d.	no access

____ 31. To ensure complete privacy, Gold’s Gym club members would have ____ privileges to the data in a fitness center database.

a.	read-only	c.	full-update
b.	write-only	d.	no access

____ 32. In a database log file, a DBMS(data base management system) places ____.

a.	a copy of a record prior to a change	c.	a copy of a record after a change
b.	the actual change to a record	d.	all of the above

____ 33. Popular data models in use today include all of the following except ____.

a.	relational	c.	object-oriented
b.	hierarchical	d.	multidimensional

____ 34. In a relational database (such as Microsoft Access), each row ____.

a.	and each column has a primary key
b.	has a unique name and each column has a primary key
c.	has a primary key and each column has a unique name
d.	and each column has a unique name

____ 35. A user of a relational database, such as that pictured in the accompanying figure, refers to a file as a ____.

a.	table	c.	row
b.	column	d.	relationship

____ 36. A user of a relational database, such as that pictured in the accompanying figure, refers to a record as a ____.

a.	table	c.	row
b.	column	d.	relationship

____ 37. A user of a relational database, such as that pictured in the accompanying figure, refers to a field as a ____.

a.	table	c.	row
b.	column	d.	relationship

____ 38. In a relational database, such as that pictured in the accompanying figure, a ____ is a connection within the data.

a.	table	c.	row
b.	column	d.	relationship

____ 39. ____ is a process designed to ensure the data within the relations (tables) in a relational database contains the least amount of data duplication.

a.	Normalization	c.	Validation
b.	Modeling	d.	Querying

____ 40. Most ____ database products for midrange servers and mainframes include SQL (Structured Query Language). Hint: Microsoft Access creates ________ databases & has an SQL View

a.	relational	c.	multidimensional
b.	object-oriented	d.	all of the above

____ 41. Compared with relational databases, object-oriented databases ____.

a.	can store more types of data	c.	allow programmers to reuse objects
b.	access data faster	d.	all of the above

____ 42. A ____ stores images, audio clips, and/or video clips such as YouTube.com or Hulu.com

a.	multimedia database
b.	groupware database
c.	computer-aided design (CAD) database
d.	hypertext database

____ 43. ________ is a high-performance, embeddable open source object database for Java and.NET database developers. (Chapter 10 PowerPoint lecture)

a.	Microsoft Access 2007
b.	db4o (database for objects)
c.	Oracle 10g database
d.	SQL (Structured Query Language)

____ 44. A disadvantage to the MOLAP (Multidimensional Online Analytical Processing) database software is that: (Chapter 10 PowerPoint lecture)

a.	it has fast performance
b.	it provides natural indexng of data
c.	it has difficulty with more than 10 dimensions
d.	it has a smaller size on the hard disk(s)

____ 45. The primary advantage of a multidimensional database is that ____.

a.	it can use SQL and any other query language for any multidimensional database
b.	it never includes the dimension of time
c.	it can consolidate data much faster than a relational database
d.	it is object oriented

____ 46. _________ is the search for relationships and patterns in data held in large databases such as buying patterns for people who shop online using the Internet.

a.	Data indexing	c.	Data sorting
b.	Data mining	d.	Data normalization

____ 47. To access data in a ____, users fill in a form on a Web page.

a.	hypertext database	c.	Web database
b.	multimedia database	d.	groupware database

____ 48. Many search engines use databases to store Web site descriptions; thus, the search engine’s home page (Google.com, for example) is the ____ to the database.

a.	front end	c.	back end
b.	before image	d.	after image

____ 49. The DA (Data Analyst) or Data Modeler does all of the following except ____.

a.	decide on the proper placement of fields
b.	define the relationships among data
c.	identify users’ access privileges
d.	create and maintain the data dictionary

____ 50. The DBA (Data Base Administrator) does all of the following except ____.

a.	manage security of the database
b.	monitor the performance of the database
c.	check backup and recovery procedures
d.	decide on the proper placement of fields

____ 51. In computer programming, a(n) _________ allows the programmer to examine the values of data variables at various places in the program and to find and correct logic errors.

a.	error fixer	c.	variable analyzer
b.	debugger	d.	syntax analyzer

____ 52. ____ language instructions use a series of binary digits (1s and 0s) or a combination of numbers and letters that represent binary digits. This type of language is tedious and difficult to program. It is low-level or close to the computer’s hardware.

a.	Machine	c.	Procedural
b.	Assembly	d.	Visual C++

____ 53. To develop a properly structured computer program, the programmer must ensure that the program and each of its modules and its control structures have the following features:

a.	No dead code, no loops, infinite loops	c.	Infinite loops, multiple entry points
b.	No dead code, no infinite loops, single entry & single exit to and from a software module	d.	No loops, multiple exit points

____ 54. The _________ Markup Language separates the Web page content from its format, allowing your browser to display Web page content in a form appropriate for your computer display device. For example, a handheld computer, a notebook computer, and a desktop computer could all display the same Web page.

a.	HTML	c.	XML
b.	DHTML	d.	XHTML

____ 55. Borland’s _______ is a powerful visual programming tool that is ideal for large-scale enterprise and Web application development. Programmers can use it to develop programs quickly for Windows, Linux, and .NET platforms.

a.	C++	c.	Delphi
b.	Visual Basic	d.	COBOL

____ 56. The machine language code that results from compiling a 3rd Generation Language (3GL) program such as C is called ____.

a.	dead code	c.	dynamic code
b.	source code	d.	object code

____ 57. An advantage of an computer software interpreter such as that in Java is that ____.

a.	when it finds errors, it displays feedback immediately
b.	interpreted programs run faster than compiled programs
c.	an interpreter produces an object program
d.	None of the above

____ 58. All of the following are widely used computer programming languages (non-scripting) that the software development industry recognizes as standards except ____.

a.	Visual Basic .NET	c.	C++
b.	Java	d.	HTML / XHTML / XML

____ 59. In object-oriented software development, an object may be part of a larger category of objects called a(n) ___________. (a Ford is an instance of the _______Automobile)

a.	class	c.	event
b.	instance	d.	message

____ 60. A(n) ____ is an action to which an object oriented programming (OOP) language program such as Java, C++ or Visual Basic.NET responds.

a.	wake-up call	c.	jolt
b.	event	d.	mouse-over

____ 61. ____ is a set of technologies by Sun Microsystems that allows programmers to develop and deploy Web services for a large business.

a.	JIT (Just In Time compiler for Java)
b.	JavaScript scripting language
c.	J2EE (Java 2 Platform Enterprise Edition)
d.	JBuilder, JCreator, and JGrasp

____ 62. ____ is a set of technologies from Microsoft that allows almost any type of program to run on the Internet or an internal business network.

a.	.JIT	c.	.NET
b.	Java	d.	.ALL

____ 63. Because it is supposedly easy to learn and use, ____ is an introductory language for beginning programmers.

a.	Visual Basic .NET	c.	C++
b.	Assembly Language (MicroAssembler)	d.	Java

____ 64. ____ is a visual programming language built on the Microsoft .NET platform that takes the complexity out of C++.

a.	Visual C++	c.	Visual COBOL
b.	Visual C#	d.	Visual Java

____ 65. ______ was developed by IBM as a procedural interpreted scripting language for both the professional programmer and the nontechnical user. In addition to all IBM operating systems, ______ works with Windows, Mac OS X, and most UNIX operating systems.

a.	Ruby on Rails	c.	Raptor
b.	Rexx	d.	Rapper

____ 66. ________ is a subset of the Visual Basic language that allows programmers to add intelligence and interactivity to Web pages. As with JavaScript, Web developers embed code from this language directly into an HTML document. The latest version of the Internet Explorer browser includes this language.

a.	Basic	c.	VBScript
b.	Perl	d.	PHP

____ 67. _______is a free, open source scripting language. It is similar to C and Java and is used primarily on Linux Web servers. Web developers may create dynamic Web pages by inserting scripts from this language along with HTML in a Web page.

a.	VBScript	c.	Perl
b.	DHTML	d.	PHP

____ 68. _______, which stands for Asynchronous Javascript and XML, is a method for creating interactive Web applications designed to provide immediate response to user requests. It works with the Web browser to update only changes to the Web page. Web sites that use this are Google Maps and Flickr.

a.	ASynchJava	c.	AJXML
b.	AJava	d.	Ajax

____ 69. _________ is a strategy that proposes that programmers shold immediately begin coding and testing solutions as soon as requirements are defined. The code continually is tested and refined until it works, (Page 695, Chapter 13 of textbook)

a.	Extreme programming (XP)	c.	Quick programming (QP)
b.	Brief programming (BP)	d.	Rapid programmng (RP)

____ 70. Examples of HTML ____ are <b> to bold text, <p> to indicate a new paragraph, and </hr> to display a horizontal line across the page or a scrolling marquee <marquee> Start at NOVA </marquee>

a.	angle brackets	c.	widgets
b.	wickets	d.	tags

____ 71. A(n) ____ is an interpreted program that runs on the client computer.

a.	JavaScript script	c.	applet
b.	servlet	d.	image map

____ 72. A(n) ____ is a compiled program that runs on the client computer.

a.	script	c.	Java applet
b.	servlet	d.	image map

____ 73. A(n) ____ is an interpreted program that runs on the server computer.

a.	script	c.	applet
b.	servlet	d.	image map

____ 74. The ____ is the communications standard that defines how a Web server communicates with outside sources.

a.	RPG (report program generator)
b.	VPE (visual programming environment)
c.	SQL (structured query language)
d.	CGI (Common Gateway Interface) script

____ 75. All of the following are server-side programming languages except ______

a.	Javascript	c.	ASP.NET
b.	ASP	d.	PHP

____ 76. Typically, dynamic Web pages created with DHTML are ____ to user interaction.

a.	less animated and responsive	c.	more animated but less responsive
b.	less animated but more responsive	d.	more animated and more responsive

____ 77. ____ contain the formats for how a particular object should display in a Web browser.

a.	Cascading Style Sheets (CSS)	c.	Document object models (DOM)
b.	Report program generators (RPG)	d.	Common Gateway Interfaces (CGI)

____ 78. XML works with ______ which is a language for creating a stylesheet that describes how to present the data described in the XML document in a Web page. Using _____, you could tell a Web browser to display any data in the element <name> as left-aligned text.

a.	PSL (Programmable Stylesheet)	c.	CSL (Combined Stylesheet)
b.	XSL (Extensible Stylesheet)	d.	DSL (Displayable Stylesheet)

____ 79. _______ is an extension of (the answer in Question 78) above which is used to create stylesheets that describe how to transform XML documents into other type of documents.

When a device requests a page from a Web site built with XML, a CGI script can detect what device has requested the page from the server. The server then uses the format described in the _____ document to transform the XML into the proper format for a cellphone microbrowser or an HTML Web page. (p. 698 of book)

a.	PSL Programmable Stylesheet Language	c.	CSL Combined Stylesheet Language
b.	DSL Document Stylesheet Language	d.	XSLT (Extensible Style Language Tranformations)

____ 80. ________ by Microsoft, is a Web page authoring program that also enables Web developers to combine interactive content with text, graphics, audio, and video. Based on the .NET Framework, this program works with a variety of languages such as JavaScript, Ruby, C#, and Visual Basic.

a.	Web Page Author	c.	Silverlight
b.	Web Site Designer .NET	d.	Web Page Publisher

____ 81. In the proper sequence, the program development cycle consists of six (6) steps:

a.	validate design, test solution, design solution, implement design, analyze requirements, and document solution
b.	implement design, document solution, test solution, validate design, design solution, and analyze requirements
c.	analyze requirements, design solution, validate design, implement design, test solution, and document solution
d.	test solution, analyze requirements, document solution, implement design, validate design, and design solution

____ 82. When computer programmers correct errors or add enhancements to existing programs they are ____ the software.

a.	executing	c.	coding
b.	maintaining and modifying	d.	validating

____ 83. ____ is an object-oriented programming language that has been accepted as a standard for Web applications and XML-based Web services. This language uses a JIT compiler like Java but its resulting code is called MSIL.

a.	C# (Cee-sharp)	c.	F# (EFF-sharp)
b.	B# (Bee-sharp!)	d.	D# (Dee-sharp)

____ 84. A(n) ____, also called program logic, is a graphical or written description of the step-by-step procedures to solve the problem.

a.	object model	c.	solution algorithm
b.	cascading style sheet	d.	source code

____ 85. In structured design, a section of a computer program that performs a single function is a ____.

a.	main routine	c.	hunk of code
b.	chunk of code	d.	module

____ 86. In object-oriented design (OOD), the concept of packaging data and procedures(methods) into a single object is called ____.

a.	covering	c.	blanketing
b.	encapsulation	d.	consolidation

____ 87. A ____ shows one or more actions following each other in order.

a.	sequence control structure	c.	repetition control structure
b.	selection control structure	d.	compliance control structure

____ 88. A ____, which is illustrated in the above figure, tells the program which action to take, based on a certain condition.

a.	sequence control structure	c.	repetition control structure
b.	selection control structure	d.	compliance control structure

____ 89. When a program evaluates a condition in a(n) ____, which is illustrated in the accompanying figure, it yields one of two possibilities: true or false.

a.	if-then-else control structure	c.	do-while control structure
b.	case control structure	d.	do-until control structure

____ 90. Unlike the control structure illustrated in the figure above, with the ____ a condition can yield one of three or more possibilities. It handles a variety of conditions.

a.	if-then-else control structure	c.	do-while control structure
b.	case control structure	d.	do-until control structure

____ 91.

Given the following pseudocode fragment of a computer program,

what are the values of COUNTER and SUM when

they are printed in the PRINT statement?

COUNTER = 0

SUM = 0

WHILE (COUNTER < 11)

COUNTER = COUNTER + 1

SUM = SUM + COUNTER

END WHILE

PRINT COUNTER, SUM

a.	COUNT = 10 SUM = 47	c.	COUNT = 11 SUM = 66
b.	COUNT = 11 SUM = 56	d.	COUNT = 12 SUM = 77

____ 92. A(n) ____ tests a condition at the beginning of the loop and repeats one or more times as long as the condition is true.

a.	for loop	c.	do-while control structure
b.	case control structure	d.	do-until control structure

____ 93. The ____ tests a condition at the end of the loop and continues looping until the condition is true — and then stops. This main actions in the structure are always done at least one time.

a.	if-then-else control structure	c.	do-while control structure
b.	case control structure	d.	do-until control structure

____ 94. With _______, the beginning and end of a software module start at the left margin, and actions within the module are indented. This type of code has often been called a combination of English and your favorite programming language. It cannot be run (executed).

a.	Perl	c.	Python
b.	PHP	d.	pseudocode

____ 95. Give the following computer program logic, which statement is displayed on the computer’s monitor ?

int A = 200; int B = 100; int C = 400; // Variables A,B & C are integer numbers (no decimals)

if (( A >= B) AND (C > 300) )

PRINT “Geeks like Gateway computers”

else

PRINT “Dweebs prefer Dell computers”

a.	Dweebs prefer Dell computers	c.	Geeks like Gateway computers
b.	nothing is displayed on the monitor	d.	both statements are displayed

____ 96. Given the following count-controlled loop in the logic of a computer program, what is the value of the computed SUM that is printed after the loop terminates ?

Hint: You could use the sequential series summation formula: SUM = N x (N + 1) / 2

Note: This was discussed during a lecture on Chapter 13 concerning loops

SUM = 0 // Set accumulator variable, SUM, to zero

FOR I = 1 TO 20

SUM = SUM + I // Add up the numbers: 1+2+3 + ...+ 20

NEXT I

PRINT SUM

a.	200	c.	220
b.	210	d.	240

____ 97. Syntax errors (errors which violate rules of the programming language) will be caused by all of the following except ____.

a.	misspelling a command	c.	typing command words out of order
b.	leaving out required punctuation	d.	using a proper do-until loop

____ 98. One reason to use good and bad test data when testing computer software is to try to cause a ____, which is an error that occurs while a program is running.

a.	run-time error	c.	debugger error
b.	syntax error	d.	logic error

____ 99. ______ is an open source framework that provides technologies for developing object-oriented, database-driven Web sites. It is derived from languages such as Ada, LISP, Perl, and Smalltalk. Web developers are more productive because they have an easy-to-use environment for the Web development process. (Page 683 of textbook)

a.	Ajax	c.	Javascript
b.	Ruby on Rails (RoR)	d.	XML

____ 100. Given the following DO WHILE loop in the pseudocode logic of a computer program, how many times does the program go through the loop and print the indicated statements ?

int N = 4

WHILE ( N <= 24)

{

PRINT “KNOWLEDGE IS POWER ... STUDY AT NOVA...”

PRINT “HOPE TO SEE YOU IN THE FUTURE”

PRINT “CHECK THE NovaConnect Student Info System for your GRADE”

N = N + 4

}

// END WHILE

a.	3
b.	4
c.	5
d.	6