Download CS111 FINAL EXAM QUESTIONBANK COMPLETE WITH ALL YOU NEED TO PASS 2024-2025 and more Exams Computer Communication Systems in PDF only on Docsity!
CS111 FINAL EXAM QUESTIONBANK
COMPLETE WITH ALL YOU NEED TO
PASS 2024- 2025
What does ASCII stand for? Select one: a. Algorithmic Sequence of Computer Integrated Information b. All Standards Complete Initialization Interface c. Aspiring Students Confused by Incoherent Incantations
d. American Standard Code for Information Interchange CORRECT ANSWER: d. American
Standard Code for Information Interchange The JavaScript code var x; is ________ the variable x. Select one: a. identifying b. declaring c. defining
d. instantiating CORRECT ANSWER: b. declaring
Many desktop applications, regardless of vendor, share basic features, such as a File menu and an Edit menu, and furthermore, the items within these menus include the same operations. A. True
B. False CORRECT ANSWER: a
In the following code, the variable val is the function call's ____. def calc_square_area(size): area = size*size return area val = float(input('Enter size of square: ')) square_area = calc_square_area(val)
print(f'A square of size {val} has area {square_area}') CORRECT ANSWER: argument
How many times does the while loop execute for the given input values of - 1, 4, 0, 9? user_num = 3 while user_num > 0: #Do something
user_num=int(input()) CORRECT ANSWER: 1
Which term describes how Python assigns the type of a variable?
dynamic typing, static typing, quick typing, or random typing? CORRECT ANSWER:
dynamic typing
The code that includes the keyword "def" is called a _____. CORRECT ANSWER: function
definition
How many times will the print statement execute? for i in range(10): for j in range(3):
print(f'{i}.{j}') CORRECT ANSWER: 30
In Excel, which cell becomes active when you press the "Enter" key? a. The next cell down b. The next cell to the right c. The cell at the end of the current row
d. The cell at the bottom of the next column CORRECT ANSWER: a
You can always write a program without using break or continue in a loop. Select one: a. true
b. false CORRECT ANSWER: a
What is the number of iterations in the following loop?for (int i = 1; i < n; i++) {// iteration} Select one: a. n b. 2 * n c. n + 1
d. n - 1 CORRECT ANSWER: d
The while loop and the do loop are equivalent in their expressive power; in other words, you can rewrite a while loop using a do loop, and vice versa. Select one: a. true
b. false CORRECT ANSWER: a
Which of the following loops produces the output? 1 2 3 4 1 2 3 1 2 1 (I)for (int i = 5; i > 0; i--) { for (int j = 1; j < i; j++) System.out.print(j + " "); System.out.println();} (II)for (int i = 1; i < 5; i++) { for (int j = 1; j < i; j++) System.out.print(j + " "); System.out.println();} (III)int i = 0;while (i < 5) { for (int j = 1; j < i; j++) System.out.print(j + " "); System.out.println(); i++; }(IV) int i = 5;
Suppose your method does not return any value, which of the following keywords can be used as a return type? Select one: a. int b. double c. void d. public
e. None of the above CORRECT ANSWER: c
Methods can be declared in any order in a class. Select one: a. true
b. false CORRECT ANSWER: a
Which of the following is not an advantage of using methods? Select one: a. Using methods makes reusing code easier. b. Using methods hides detailed implementation from the clients. c. Using methods makes programs easier to read. d.
Using methods makes programs run faster. CORRECT ANSWER: d
Each time a method is invoked, the system stores parameters and local variables in an area of memory, known as ________, which stores elements in last-in first-out fashion. Select one: a. storage area b. an array c. a heap
d. a stack CORRECT ANSWER: d
Java allows you to declare methods with the same name in a class. This is called ________. Select one: a. method redeclaration b. method overriding c. method duplication d.
method overloading CORRECT ANSWER: d
What is the output? names = ['Bob', 'Jill', 'Xu'] ages = [24,18,33] for index in [2,0,1]:
print(f'{names[index]}:{ages[index]}') CORRECT ANSWER: Xu:
Bob: Jill:
What is the missing function name so that the output is: Cairo New York Paris Sydney? cities = ['Sydney', 'Paris', 'New York', 'Cairo'] for c in _____(cities):
print(c, end=' ') CORRECT ANSWER: reversed
Variables defined in the method header are called ________. Select one: a. global variables b. local variables c. parameters
d. arguments CORRECT ANSWER: c
The signature of a method consists of ________. Select one: a. return type, method name, and parameter list b. parameter list c. method name and parameter list d.
method name CORRECT ANSWER: c
Which range() function call generates every even number between 20 and 30 (including both 20
and 30)? CORRECT ANSWER: range(20,31,2)
Relying on 0s and 1s in representing digital information results in a great disadvantage in creating reproductions. a. True
b. False CORRECT ANSWER: b
Which of the following statements best describes a one-to-many relationship between two tables? a. A primary key in the first table matches exactly one foreign key in the second table. b. A foreign key in the first table matches several primary keys in the second table. c. A primary key in the first table matches several foreign keys in the second table. d. Primary and foreign keys have multiple cross matches between a first and second table.
CORRECT ANSWER: c
What is the output message produced in the alert box by the code
alert(3 + 3) CORRECT ANSWER: 6
Instruction sequences that repeat are called: a. sorting b. loops c. assumptions
d. tests CORRECT ANSWER: b
You can create or modify a table's field names and data types in ________ view.
A digitization guideline stating that the sampling frequency should exceed the signal frequency by at least two times is the: Select one: a. Sample Rate rule b. Analog-Digital rule c. Nyquist rule
d. Leibniz rule CORRECT ANSWER: c. Nyquist rule
Which input value causes "Goodbye" to be output next? x=int(input()) while x>=0:
Do something
x = int(input())
print('Goodbye') CORRECT ANSWER: - 1
The PMT function Select one: a. calculates the periodic payment for a loan with a fixed interest rate and fixed term. b. returns the total number of payment periods for a loan or savings plan. c. tells whether an expression is a Permissible Mathematical Term in a certain context.
d. returns the mean time between events being processed. CORRECT ANSWER: a.
calculates the periodic payment for a loan with a fixed interest rate and fixed term. Because the Xerox's Alto was targeted at businesses, the metaphor the PARC researchers chose for the GUI was a desktop. Select one: True
False CORRECT ANSWER: True
The JavaScript code x = 1;
is called a(n)________statement. CORRECT ANSWER: assignment
The PandA system: Select one: a. is binary b. is formed from 256 letter representations c. contains gray
d. has 10 digits CORRECT ANSWER: a. is binary
Transistors helped advance computing because they complicated the assembly process. Select one: True
False CORRECT ANSWER: False
In a Web search, a match to a query is known as a(n): Select one: a. intersection b. hit c. URL list
d. None of these CORRECT ANSWER: b. hit
The very last part of a URL is the: Select one: a. domain b. pathname c. protocol
d. server computer's name CORRECT ANSWER: b. pathname
Which of the following is not an operating system? Select one: a. Windows 7 b. Unix c. Linux d. Assembly
e. Mac OS X CORRECT ANSWER: d. Assembly
Following the introduction of Apple Macintosh and Microsoft Windows, the desktop metaphor became the universal way most people thought of using a computer. Select one: True
False CORRECT ANSWER: True
Describing a technical problem using the right words helps facilitate a speedy and helpful answer from tech support. Select one: True
False CORRECT ANSWER: True
You are reviewing a table you created in an Access database. As you review the table, you notice a column of cells that are supposed to contain sales figures have pound signs through them (#######). What is the cause of these pound signs? Select one: a. The pound signs are present because the column is not wide enough to display the data. b. The pound signs are present because the value of the fields are null. c. The pound signs are present because the data type used on the cells is incorrect.
d. The pound signs serve as a warning that the data in the cells contain an error. CORRECT
ANSWER: a. The pound signs are present because the column is not wide enough to display
the data.
Give the 4-bit binary equivalent for the following decimal number: 3 CORRECT ANSWER:
The JavaScript code var x=1; is ________ the variable x. a. setting b. initializing c. evaluating
d. assigning CORRECT ANSWER: b
c. comparison
d. delimiter CORRECT ANSWER: c
When the completion time of a computer operation can be predicted, applications typically show an hourglass icon. a. True
b. False CORRECT ANSWER: b
Spaces that have been inserted for readability are called: a. white space b. blanks c. tags
d. embedded space CORRECT ANSWER: a
A Value (as it applies to Excel) a. is a number that represents a quantity and can be the basis of calculations. b. includes letters, numbers, and spaces. c. is a combination of cell references, operators, values, and/or functions used to perform calculations.
d. controls the sequence in which Excel performs arithmetic operations. CORRECT
ANSWER: a
You can have an HTML element, such as a paragraph, change its background color whenever the user moves the cursor on top of that element. One way to do this is to add a Javascript function to that element's __________ property. a. onmouseover b. hover c. cursor
d. mouseon CORRECT ANSWER: a
The Formula Bar (as it applies to Excel 2010) a. displays the name of a worksheet within a workbook. b. displays the content of the active cell. c. identifies the address of the current cell.
d. is at the intersection of a column and a row. CORRECT ANSWER: b
Digitized sound can be: a. "fixed" by removing offending noises b. computed to reduce the number bits c. reproduced exactly
d. All of these CORRECT ANSWER: d
Give the 4-bit binary equivalent for the following decimal number: 12 CORRECT ANSWER:
Ribbon Commands with arrows indicate a. that you should hit "Enter" on the keyboard. b. a link to another worksheet. c. the next step in the process.
d. there are two or more sub-commands related to the command. CORRECT ANSWER: d
A function is a a. predefined formula that performs a calculation. b. activity performed by a worksheet. c. defined purpose for a set of cells or a group of formulas.
d. set of rules that govern the structure and components for a formula. CORRECT
ANSWER: a
Communication between one sender and many receivers is called: a. broadcast communication b. client/server communication c. multicast communication
d. point-to-point communication CORRECT ANSWER: a
Joe is working in a database that stores client data. He needs to design a field that will assign a client ID number each time a user enters a new client. The data type he should apply to this field is: a. Text b. Memo c. Number
d. AutoNumber CORRECT ANSWER: d
Which search technique will help avoid over constraining? a. Include a general topic term. b. Remove terms from the search using NOT. c. Add as many descriptive words as possible.
d. Begin with an inclusive search and add more words one at a time. CORRECT ANSWER:
d Haptic devices: a. rapidly display still images as a way to fool our eyes and brain b. are used to keep out "spambots" c. are input/output technology for interacting with our sense of touch and feel
d. Use a combination of half audio and half video signals CORRECT ANSWER: c
Perfect reproduction is a property of analog information. a. True
b. False CORRECT ANSWER: b
When we install a new app, we should immediately and intuitively perform two important activities: "clicking around" and "blazing away." a. True
b. False CORRECT ANSWER: a
Give the decimal equivalent for the following 8-bit binary number: 1100 0100 CORRECT
ANSWER: 196
A structure without any properties or content is: a. information b. an instance
The Basic Input/Output System (BIOS) is stored on a microchip called the: a. Boot ROM b. flash memory package c. ARM processor
d. kernel CORRECT ANSWER: a
What type of information comes from experts? a. information found in a library b. information found in Google's Advanced Search c. information on the Web
d. authoritative information CORRECT ANSWER: d
A relative cell reference a. indicates a cell's specific location and the reference does not change when you copy the formula. b. occurs when a formula directly or indirectly refers to the cell containing the formula. c. indicates a cells relative location from the cell containing the formula; the reference changes when you copy the formula.
d. contains an absolute and a relative cell reference as part of the formula. CORRECT
ANSWER: c
Something can't be considered a computer unless it has a keyboard attached to it. a. True
b. False CORRECT ANSWER: b
In JavaScript, the statement terminator is a(n) ________. a. colon (:) b. comma (,) c. semi-colon (;)
d. period (.) CORRECT ANSWER: c
Give the decimal equivalent for the following 4-bit binary number: 1001 CORRECT
ANSWER: 9
Which of the following is not controlled by the operating system? a. Internet connection management b. memory management c. I/O devices management
d. high-level language conversion to binary CORRECT ANSWER: d
Software is a collective term for programs; the instructions computers perform to implement applications. a. True
b. False CORRECT ANSWER: a
When determining the page layout, CSS considers every HTML5 element to be enclosed in a: a. page b. box c. body
d. folder CORRECT ANSWER: b
The ________ tab holds all of the operations necessary to carry out data import and export. a. Home b. Database Tools c. External Data
d. File CORRECT ANSWER: c
Using only 0s and 1s means the information can be perfectly: a. reproduced b. consistent c. converted to a placeholder
d. turned into a desktop CORRECT ANSWER: a
By selecting the ________ option, you can make sure that data entered into the foreign key field of one table matcheѕ existing data in the primary key field of a related table. a. referential integrity b. required field c. common field
d. key match CORRECT ANSWER: a
In software, a program that stops operating to avoid harm is called: a. fail-safe b. fault-tolerant c. bug-safe
d. fail-soft CORRECT ANSWER: a
Which of the following would be the best choice for a primary key? a. Social Security Number b. Street Address c. Last Name
d. First Name CORRECT ANSWER: a
Rebooting a computer means to: a. restart the computer b. run a program from the hard disk c. start the computer
d. None of these CORRECT ANSWER: a
Writing software is the job of programmers and software developers. a. True
b. False CORRECT ANSWER: a
A mixed cell reference a. contains both an absolute and a relative cell reference. b. contains neither absolute nor relative cell references. c. occurs when a formula directly or indirectly refers to the cell containing the formula.
d. contains cells that are incorrectly related. CORRECT ANSWER: a
Which GUI metaphor features file cabinets and wastebaskets as typical components? a. touch metaphor
b. downloading c. multicasting
d. client-based networking CORRECT ANSWER: b
In JavaScript, and other programming languages, a group of letters enclosed in double quotes is
known as a string ____________. CORRECT ANSWER: literal
When an operation is processing a series of inputs, the "completion count" gives the tally of the completed instances, or equivalently, the number remaining. a. True
b False CORRECT ANSWER: a
Give the 8-bit binary equivalent for the following decimal number: 225 CORRECT
ANSWER: 1111 1111
A family of styling specifications with a common name is called a: a. text document b. class c. HTML document
d. tree CORRECT ANSWER: b
To create a Web page with along with a description of their purpose, it would be best to use: a. an ordered list b. an unnumbered list c. a definitional list
d. a table CORRECT ANSWER: c
A way in which product developers who create technologies minimize learning time is by creating controls that match our expectations, such as with sliders and dials. a. True
b. False CORRECT ANSWER: a
You can create or modify a table's field names and data types in ________ view. CORRECT
ANSWER: a
What does ASCII stand for? a. Algorithmic Sequence of Computer Integrated Information b. All Standards Complete Initialization Interface c. Aspiring Students Confused by Incoherent Incantations
d. American Standard Code for Information Interchange CORRECT ANSWER: d
In a directory hierarchy in a Web address, folder names are separated by a: a. slash (/) b. backslash () c. dot (.)
d. space CORRECT ANSWER: a
Give the 8-bit binary equivalent for the following decimal number: 127 CORRECT
ANSWER: 0111 1111
A weakness of Wikipedia is that: a. editing of content is highly restricted b. the content is not validated by experts c. it covers a limited number of topics
d. it contains timely information CORRECT ANSWER: b
The ________ view in Access looks similar to an Excel Spreadsheet. a. Datasheet b. Form c. Report
d. Design CORRECT ANSWER: a
Data from two or more tables can be connected by specifying a: a. query form. b. common field. c. primary key.
d. hyperlink. CORRECT ANSWER: b
Using ROY G BIV to remember, in order, the colors of the rainbow as red, orange, yellow, green, blue, indigo, and violet is an example of a(n): a. mnemonic b. algorithm c. abstraction
d. generalization CORRECT ANSWER: a
The fill handle (as it applies to Excel 2010) a. performs the same action as pressing "enter." b. is a small black square at the bottom-right corner of a cell that facilitates fill operations. c. copies the contents of one worksheet to another.
d. is a quick way to copy a format from one range to another. CORRECT ANSWER: b
Access differs from other Microsoft software because it: a. size of the data you can work with. b. number of people that can view the file at one time. c. type of formatting you can perform.
d. number of undo's you can perform. CORRECT ANSWER: d
The HTML tag for bold text is: a. b. c.
d. CORRECT ANSWER: d
Which field property type should be applied to fields that should not remain empty? a. Special b. Required c. Indexed
d. Format CORRECT ANSWER: b
d. is the process of using the mouse to select cells while building a formula. CORRECT
ANSWER: d
Which of the following would be used to display an ampersand on a Web page? a. & b. && c. <&>
d. & CORRECT ANSWER: a
Give the 4-bit binary equivalent for the following decimal number: 2 CORRECT ANSWER:
The VLOOKUP function. a. references a cell located a given distance up or down in the current column. b. vertically aligns a cell according to a given style. c. returns the value of a given variable.
d. looks up a value and returns a related result from the lookup table. CORRECT ANSWER:
d The original version of ASCII used: a. 4-bit code b. 7-bit code c. 8-bit code
d. 16-bit code CORRECT ANSWER: b
The logical test a. contains data for the basis of the lookup and data to be retrieved. b. gives a popup hint that your formula may not make any sense c. checks whether an expression evaluates to true or to false.
d. checks the syntax of an expression CORRECT ANSWER: c
A related group of networked computers forms a: a. domain b. broadband c. DNS
d. server CORRECT ANSWER: a
A nanosecond is: a. 1/1,000,000,000th of a second b. 1/1,000th of a second c. 1/1,000,000th of a second
d. 1/100th of a second CORRECT ANSWER: a
A Formula (as it applies to Excel 2010) is a. should be used in each column of a workbook. b. a number that represents a quantity and can be the basis of calculations. c. a built in function that returns a value d. a combination of cell references, operators, values, and/or functions used to perform
calculations. CORRECT ANSWER: d
When choosing between Access and Excel, it is best to use Access in all of the following circumstances EXCEPT when: a. you are managing a large quantity of data. b. you require multiple tables to manage data. c. multiple users need to work with data simultaneously.
d. you need to create complex charts or graphs. CORRECT ANSWER: d
A field, or a combination of fields, that must have a unique value in a given table is a ________ for that table. a. foreign key b. primary key c. characteristic value
d. identifier CORRECT ANSWER: b
The New and Open commands are normally located on the: a. Edit menu b. Main menu c. File menu
d. Shortcut menu CORRECT ANSWER: c
The NPER a. is a "Not Permitted" Error b. is the number of possible arguments in a function c. is a "Number Past Expected Result" Error.
d. is the total number of payment periods. CORRECT ANSWER: d
The order of precedence (as it applies to math operations in Excel) a. controls which rows and columns are processed first. b. controls the sequence in which Excel performs arithmetic operations. c. determines which worksheet will be displayed when Excel is opened.
d. determines which cells will have their formulas evaluated first. CORRECT ANSWER: b
Irene is working on a database that stores customer data and order information. The Customer Information Table holds customer information. A unique customer number serves as the primary key for this table. The Order Information Table holds order information. A unique order number serves as the primary key for this table. A customer only has one customer number but may have several order numbers. If Irene wants to establish a one-to-many relationship between the customer information table and the order information table, which of the following steps should she follow? a. Irene should include the primary key in the customer information table as a foreign key in the order information table. b. Irene should include the foreign key in the customer information table as a primary key in the order information table. c. Irene cannot establish a relationship between the two tables.
d. Irene should include the primary key in th CORRECT ANSWER: a
In a search engine, the index is built by the: a. query processor b. crawler c. indexer
d. linker CORRECT ANSWER: b
