Geek Test Round 2
<div class="IPBDescription">computers test</div> A while ago I posted a practice midterm for my computers class that didn't have solutions. Since there's no point taking the quiz unless I have some sort of reference to use I thought I might as well post it here for fellow "geeks" to mull over. Any questions you can answer help me that much more so post away! Thanks!
you can find the test here:
<a href='http://www.usrlocal.ca/~dbm/teaching/CIS1000/Exams/sample2/' target='_blank'>http://www.usrlocal.ca/~dbm/teaching/CIS1000/Exams/sample2/</a>
P.S and yes this is a sample one - it even says in the domain. I'm not trying to scam marks off you lot.
you can find the test here:
<a href='http://www.usrlocal.ca/~dbm/teaching/CIS1000/Exams/sample2/' target='_blank'>http://www.usrlocal.ca/~dbm/teaching/CIS1000/Exams/sample2/</a>
P.S and yes this is a sample one - it even says in the domain. I'm not trying to scam marks off you lot.
Comments
Question 1:
Which of the following searches would you expect to result in the smallest number of matching pages?
queen elizabeth
+queen +elizabeth
queen NEAR elizabeth
<b> "queen elizabeth” </b>
Question 2:
Which of the following searches would you expect to result in the largest number of matching pages?
queen or elizabeth
+queen +elizabeth
<b> queen and elizabeth </b>
“queen elizabeth”
Question 3:
Which of the following media has the highest potential bandwidth (can carry the largest amount of data over time):
coaxial cable
twisted pair (copper wire)
<b> fiber optic cable </b>
infra-red wireless
Question 4:
There are a variety of techniques for transmitting data from one place to another over a network. Which of the following is generally referred to as a “connectionless” protocol?
circuit switching
packet switching
<b> TCP </b>
satellite transmission
Question 5:
There are a variety of techniques for transmitting data from one place to another over a network. Which of the following protocols is most like a telephone system?
circuit switching
packet switching
IP
<b> UDP </b>
Question 6:
The standards by which two computers communicate over a network including such details as how to initiate a connection, how much data is sent at one time, etc. is referred to as a:
protocol
<b> LAN </b>
peer-to-peer
client-server
Question 7:
What is true of peer-to-peer networking?
there is no server
it is best suited to a small number of machines
<b> both A and B </b>
neither A nor B
Question 8:
You are able to use your computer at home as if it were physically located on your company’s LAN; this sort of configuration, achieved by transmitting encrypted data over the Internet is referred to as a(n):
<b> virtual private network </b>
extranet
intranet
public data network
Question 9:
Transmitting a file from one computer to another requires that all data be transmitted correctly, and it is convenient if it is received in the same order in which it was sent. Which Internet protocol is best suited to this sort of transfer?
TCP
<b> UDP </b>
IP
VPN
Question 10:
The application we use for remote access to machines, typically used to interact with a command shell running on the remote machine, is
<b> telnet </b>
ftp
ping
general
Question 11:
The unique value used to identify all computers/nodes on The Internet (for example 131.104.36.180) is called a(n):
network address
<b> IP address </b>
DNS
node
Question 12:
A program that operates by requesting services from another program/computer on a network is referred to as:
a server
<b> a client </b>
system software
application software
Question 13:
A computer or program that screens incoming data, helping to protect a system from unauthorized access while allowing desired data to get through is called:
a server
a client
<b> a firewall </b>
anti-virus software
Question 14:
What is the difference between ASCII and binary mode file transfers with FTP?
ASCII mode performs conversions between machine-specific values during transfer while binary mode does not
binary mode performs conversion between machine-specific values during transfer while ASCII mode does not
ASCII mode is slow whereas binary mode is fast
<b> binary mode is slow whereas ASCII mode is fast </b>
Question 15:
Which of the following requires broadband digital transmission:
sending e-mail
faxing
video conferencing
<b> voice over IP </b>
Question 16:
The major problem with satellite data transmission is:
<b> latency </b>
bandwidth
direction
protocols
Question 17:
What is the key difference between asynchronous and synchronous communication:
synchronous can be any length
asynchronous can be any length
synchronous is faster
<b> asynchronous is faster </b>
Question 18:
During a heated discussion with a friend, you find that your voice is getting louder the more angry you become. You fondly recall this class and recognize that encoding information in this manner corresponds to what type of signal?
analog
digital
both A and B
<b> neither A nor B </b>
Question 19:
Which of the following best describes what a modem does:
converts analog signals from a telephone line to digital signals
converts digital signals on a computer to analog signals
neither A nor B
<b> both A and B </b>
Question 20:
What is the major issue described as the “Last Mile Problem”
not everyone subscribes to cable
not all homes have high speed internet
<b> telephone lines are very expensive to replace </b>
fiber optics are very dangerous for the average home
Question 21:
What is an important difference between absolute and relative references?
<b> absolute references never change </b>
relative references never change
absolute references cannot be overwritten
relative references cannot be overwritten
Question 22:
If the formula =$A2+B$3 appears in cell A1, and it is copied to cell C4, what formula will appear in cell C4?
=$C2+B$6
<b> =$A2+B$3 </b>
=$C5+D$6
=$A5+D$3
Question 23:
Which type of chart/graph is best suited to represent the parts of a whole?
line
<b> pie </b>
bar
column
Question 24:
In a database, which of the following pairs are basically the same things?
column, record
<b> record, table </b>
file, table
record, file
Question 25:
What is true of a relational database?
queries are linked together
<b> records are linked together </b>
tables are linked together
fields are linked together
Question 26:
What is true of a flat file database?
records are all the same length
records can have different lengths
<b> records are linked to other records </b>
records are not used
Question 27:
Which of the following best describes data redundancy?
<b> having meaningless data </b>
having repeated data
having erroneous data
having too much data
Question 28:
What is a key benefit to Query By Example?
<b> more specific searches </b>
less specific searches
easier to use
more difficult to use
Question 29:
What is a key benefit to SQL?
more specific searches
less specific searches
<b> easier to use </b>
more difficult to use
Question 30:
What is the URL for the web page for this course?
<b> <a href='http://www.cis1000.uoguelph.ca' target='_blank'>http://www.cis1000.uoguelph.ca</a> </b>
<a href='http://courselink.uoguelph.ca' target='_blank'>http://courselink.uoguelph.ca</a>
<a href='http://cis1000.uoguelph.ca' target='_blank'>http://cis1000.uoguelph.ca</a>
<a href='http://ta100.cis.uoguelph.ca' target='_blank'>http://ta100.cis.uoguelph.ca</a>
I know I have lots wrong but, someone please be kind of enough to point out which ones and why?
What is the URL for the web page for this course?
<b> <a href='http://www.cis1000.uoguelph.ca' target='_blank'>http://www.cis1000.uoguelph.ca</a> </b>
<a href='http://courselink.uoguelph.ca' target='_blank'>http://courselink.uoguelph.ca</a>
<a href='http://cis1000.uoguelph.ca' target='_blank'>http://cis1000.uoguelph.ca</a>
<a href='http://ta100.cis.uoguelph.ca' target='_blank'>http://ta100.cis.uoguelph.ca</a> <!--QuoteEnd--> </td></tr></table><div class='postcolor'> <!--QuoteEEnd-->
Only one I looked at.
Only the second link works...not sure if I'm just too stupid to read the question right though.
What is the URL for the web page for this course?
<b> <a href='http://www.cis1000.uoguelph.ca' target='_blank'>http://www.cis1000.uoguelph.ca</a> </b>
<a href='http://courselink.uoguelph.ca' target='_blank'>http://courselink.uoguelph.ca</a>
<a href='http://cis1000.uoguelph.ca' target='_blank'>http://cis1000.uoguelph.ca</a>
<a href='http://ta100.cis.uoguelph.ca' target='_blank'>http://ta100.cis.uoguelph.ca</a> <!--QuoteEnd--></td></tr></table><div class='postcolor'><!--QuoteEEnd-->
Only one I looked at.
Only the second link works...not sure if I'm just too stupid to read the question right though. <!--QuoteEnd--> </td></tr></table><div class='postcolor'> <!--QuoteEEnd-->
It's definately wrong, because cis1000 is a subdomain to uoguelph.ca, therefore you do not use the www infront of it.
2a
3c
4c
5d
6b
7c
8a
9b
10a
11b
12b
13c
14-
15 ... None? I'm gonna go with c though
16a
17-
18... what?
19d
20-
21a
22d
23b
24b
25-
26-
27a
28a
29c
30-
Knowing me it's all wrong but meh.
Question 2:
<i>Which of the following searches would you expect to result in the largest number of matching pages?</i>
This seems simple. One of us isn't thinkinh straight; hopefully it's you. =) "queen or elizabeth" is my answer, as EITHER queen OR elizabeth results in a match.
Question 4:
<i>There are a variety of techniques for transmitting data from one place to another over a network. Which of the following is generally referred to as a “connectionless” protocol?</i>
Packet switching
The data communication method in which communication occurs between hosts with no previous setup. Packets sent between two hosts may take different routes. UDP is a good example.
Question 5:
<i>There are a variety of techniques for transmitting data from one place to another over a network. Which of the following protocols is most like a telephone system?</i>
UDP and packet-switching are non-linear, so that's not it.
Circuit switching establishes connections on demand, then permits exclusive use of those connections until they are released. ie, "No incomming calls until you hang up", so I think this is the answer. (IP can be compared to "calling" someone, but you can recieve many calls at once, unlike your basic phone system.)
Question 6:
<i>The standards by which two computers communicate over a network including such details as how to initiate a connection, how much data is sent at one time, etc. is referred to as a:</i>
Protocol
Question 9:
Transmitting a file from one computer to another requires that all data be transmitted correctly, and it is convenient if it is received in the same order in which it was sent. Which Internet protocol is best suited to this sort of transfer?
o0.
I didn't think it was UDP, but 2 people have posted saying it is... :S
UDP is packet-switching, so packets take different routes to get to their destination. I'd go with... Hmm. Pass? I'm 70% sure TCP/IP can be non-linear, so that leaves VPN, but that's not something I'd put money on.
Question 14:
<i>What is the difference between ASCII and binary mode file transfers with FTP?</i>
Well it's not a speed thing. Binary is machiene specific, whereas ASCII is a system of using binary to transfer human readable characters. From that, you'd need to convert ASCII to transfer it, so I'd answer A. (<i>ASCII mode performs conversions between machine-specific values during transfer while binary mode does not </i>
Question 15:
<i>Which of the following requires broadband digital transmission:</i>
Well, you can't do much video or voice conferencing on a baud modem, but it could be done. Video conferencing is pretty obviously the most bandwidth intensive though.
Question 17:
<i>What is the key difference between asynchronous and synchronous communication</i>
Synchronous is faster
I had to look this up:
<i> The theory behind asynchronous and synchronous communication is essentially the same: Point B needs to know when a transmission from Point A begins, when it ends, and if it was processed correctly. However, the difference lies in how the transmission is broken down. Think of the difference in terms of a friendly chat. With asynchronous communication you would need to stop after every word to make sure the listener understood your meaning, and knew that you were about to speak the next word. <b>With synchronous communication</b>, you would establish with your listener that you were speaking English, that you will be speaking words at measured intervals, and that you would utter a complete sentence, or paragraph, or extended soliloquy, before pausing to confirm understanding. Further, you would establish with your listener beforehand that any extraneous noises you make during the speech or between speeches (coughing, burping, hiccupping) should be ignored. <b>Clearly the second approach is much faster</b>, even though initializing communication may take slightly longer. In fact, by replacing the start, stop and parity bits around individual words with start, stop and control (processing instructions and error checking) sequences around large continuous data blocks, synchronous communication is about 30% faster than asynchronous communication, before any other factors are considered.</i>
Question 18:
<i>During a heated discussion with a friend, you find that your voice is getting louder the more angry you become. You fondly recall this class and recognize that encoding information in this manner corresponds to what type of signal?</i>
Hmm. As time passes, the amplitude of both signals falls; it does not become "louder" in any sense. However, for them to travel further distances when transmitted via EM waves (eg radio,) you would increase their amplitudes. This would only work effectively with digital, as analogue would mess up with the interference. Still, I think "neither A nor B" is a more accurate answer.
Question 20:
<i>What is the major issue described as the “Last Mile Problem”</i>
Not all homes have high speed internet.
That's my answer, but I'm not confident on my reasoning, so won't share it to avoid confusion. Anyone know for sure?
Question 22:
<i>If the formula =$A2+B$3 appears in cell A1, and it is copied to cell C4, what formula will appear in cell C4?</i>
Depends how it's copied.
=$A2+B$3 or =$C5+D$6.
Question 24:
<i>In a database, which of the following pairs are basically the same things?</i>
A column contains datas from many records
A table contains many records
But WTH is a file w.r.t a database... :S An alternate word for table?
If so, answer is C, "file, table".
Question 25:
<i>What is true of a relational database?</i>
Fields are linked together
Seriously guys, has no-one ever used Access?
Question 26:
No idea. I withdraw my above statement.
Question 27:
<i>Which of the following best describes data redundancy?</i>
lols. It's a backup dudes, not meaningless data. =D
"Having repeated data".
Question 28:
<i>What is a key benefit to Query By Example?</i>
Easier to use
Question 29:
<i>What is a key benefit to SQL?</i>
It's bloody hard, but that's not a benifit. :S
More specific searches? That's just stating the obvious though.
What is the URL for the web page for this course?
<a href='http://www.unknownworlds.com/forums/index.php?showtopic=90268&st=0&#entry1414385' target='_blank'>http://www.unknownworlds.com/forums/index....0&#entry1414385</a>
At the moment anyway. <!--emo&:p--><img src='http://www.unknownworlds.com/forums/html/emoticons/tounge.gif' border='0' style='vertical-align:middle' alt='tounge.gif' /><!--endemo-->
Great quiz, really enjoyed doing that. Thanks!
Question 1:
Which of the following searches would you expect to result in the smallest number of matching pages?
1. queen elizabeth
<b>2. +queen +elizabeth</b>
3. queen NEAR elizabeth
4. “queen elizabeth”
Question 2:
Which of the following searches would you expect to result in the largest number of matching pages?
1. queen or elizabeth
2. +queen +elizabeth
3. queen and elizabeth
<b>4. “queen elizabeth”</b>
Question 3:
Which of the following media has the highest potential bandwidth (can carry the largest amount of data over time):
1. coaxial cable
2. twisted pair (copper wire)
<b>3. fiber optic cable</b>
4. infra-red wireless
Question 4:
There are a variety of techniques for transmitting data from one place to another over a network. Which of the following is generally referred to as a “connectionless” protocol?
1. circuit switching
2. packet switching
3. TCP
4. satellite transmission
Answer : No idea, I'm not sure what you're asking for. The other 3 aren't protocols, and TCP isn't connectionless. SYN, SYN ACK, ACK anyone?
Question 5:
There are a variety of techniques for transmitting data from one place to another over a network. Which of the following protocols is most like a telephone system?
<b> 1. circuit switching</b>
2. packet switching
3. IP
4. UDP
Question 6:
The standards by which two computers communicate over a network including such details as how to initiate a connection, how much data is sent at one time, etc. is referred to as a:
<b>1. protocol</b>
2. LAN
3. peer-to-peer
4. client-server
Question 7:
What is true of peer-to-peer networking?
<b>1. there is no server</b> - Dependant on what P2P Protocol you're using, otherwise 4, please.
2. it is best suited to a small number of machines
3. both A and B
4. neither A nor B
Question 8:
You are able to use your computer at home as if it were physically located on your company’s LAN; this sort of configuration, achieved by transmitting encrypted data over the Internet is referred to as a(n):
<b>1. virtual private network</b> - Although the question is incorrect. God I'm a pedant.
2. extranet
3. intranet
4. public data network
Question 9:
Transmitting a file from one computer to another requires that all data be transmitted correctly, and it is convenient if it is received in the same order in which it was sent. Which Internet protocol is best suited to this sort of transfer?
<b>1. TCP</b> - Once again, packets don't necessarily <b>arrive</b> in the order they were sent, but the sequence number solves this issue.
2. UDP
3. IP
4. VPN
Question 10:
The application we use for remote access to machines, typically used to interact with a command shell running on the remote machine, is
<b>1. telnet</b> - Rephrase question to create a session on remote machines.
2. ftp
3. ping
4. general
Question 11:
The unique value used to identify all computers/nodes on The Internet (for example 131.104.36.180) is called a(n):
1. network address
<b>2. IP address</b> - Hope that isn't your IP. <!--emo&:)--><img src='http://www.unknownworlds.com/forums/html/emoticons/smile-fix.gif' border='0' style='vertical-align:middle' alt='smile-fix.gif' /><!--endemo-->
3. DNS
4. node
Question 12:
A program that operates by requesting services from another program/computer on a network is referred to as:
1. a server
<b> 2. a client</b>
3. system software
4. application software
Question 13:
A computer or program that screens incoming data, helping to protect a system from unauthorized access while allowing desired data to get through is called:
1. a server
2. a client
<b>3. a firewall</b> - Packet filter? Access List? Proxy? <!--emo&:D--><img src='http://www.unknownworlds.com/forums/html/emoticons/biggrin-fix.gif' border='0' style='vertical-align:middle' alt='biggrin-fix.gif' /><!--endemo--> Incidentally some AV software also performs proxying, so you could answer 4.
4. anti-virus software
Question 14:
What is the difference between ASCII and binary mode file transfers with FTP?
1. ASCII mode performs conversions between machine-specific values during transfer while binary mode does not
2. binary mode performs conversion between machine-specific values during transfer while ASCII mode does not
3. ASCII mode is slow whereas binary mode is fast
4. binary mode is slow whereas ASCII mode is fast
Answer : No idea. Don't know the FTP that well.
Question 15:
Which of the following requires broadband digital transmission:
1. sending e-mail
2. faxing
3. video conferencing
4. voice over IP
Answer - None. "Broadband" is a made up Salesman term (try xDSL/Cable) and none of these answers 'require' it. Although to get satisfactory performance it would be higly reccomended. (3 & 4, btw)
Question 16:
The major problem with satellite data transmission is:
<b>1. latency</b>
2. bandwidth
3. direction
4. protocols
Question 17:
What is the key difference between asynchronous and synchronous communication:
1. synchronous can be any length
2. asynchronous can be any length
3. synchronous is faster
4. asynchronous is faster
Answer - Once again, not sure your intent. Async means we don't transmit equal amounts, sync is?
Question 18:
During a heated discussion with a friend, you find that your voice is getting louder the more angry you become. You fondly recall this class and recognize that encoding information in this manner corresponds to what type of signal?
<b>1. analog</b>
2. digital
3. both A and B
4. neither A nor B
Question 19:
Which of the following best describes what a modem does:
1. converts analog signals from a telephone line to digital signals
2. converts digital signals on a computer to analog signals
3. neither A nor B
<b>4. both A and B</b> - Maybe? Not a Telco guy, usually. Modulates/Demodulates? <!--emo&:D--><img src='http://www.unknownworlds.com/forums/html/emoticons/biggrin-fix.gif' border='0' style='vertical-align:middle' alt='biggrin-fix.gif' /><!--endemo-->
Question 20:
What is the major issue described as the “Last Mile Problem”
1. not everyone subscribes to cable
2. not all homes have high speed internet
3. telephone lines are very expensive to replace
4. fiber optics are very dangerous for the average home
Answer - Never heard of it. NEXT!
Question 21:
What is an important difference between absolute and relative references?
1. absolute references never change
2. relative references never change
3. absolute references cannot be overwritten
4. relative references cannot be overwritten
Answer - See 20.
Question 22:
If the formula =$A2+B$3 appears in cell A1, and it is copied to cell C4, what formula will appear in cell C4?
1. =$C2+B$6
2. =$A2+B$3
3. =$C5+D$6
4. =$A5+D$3
Answer - Depends what program you're using, sunshine. Some are smart enough to do it, some aren't.
Question 23:
Which type of chart/graph is best suited to represent the parts of a whole?
1. line
<b>2. pie</b> - Mmmm... pie.
3. bar
4. column
Question 24:
In a database, which of the following pairs are basically the same things?
1. column, record
2. record, table
<b>3. file, table</b>
4. record, file
Question 25:
What is true of a relational database?
1. queries are linked together
<b> 2. records are linked together</b>
3. tables are linked together
4. fields are linked together
Answer - Not sure, 70% guess.
Question 26:
What is true of a flat file database?
1. records are all the same length
2. records can have different lengths
3. records are linked to other records
4. records are not used
Answer - No idea.
Question 27:
Which of the following best describes data redundancy?
1. having meaningless data
<b>2. having repeated data</b>, across multiple sources/locations
3. having erroneous data
4. having too much data
Question 28:
What is a key benefit to Query By Example?
1. more specific searches
2. less specific searches
3. easier to use
4. more difficult to use
Answer - You <b>LIKE</b> databases, don't you?
Question 29:
What is a key benefit to SQL?
<b>1. more specific searches</b>
2. less specific searches
3. easier to use
4. more difficult to use
Question 30:
What is the URL for the web page for this course?
1. <a href='http://www.cis1000.uoguelph.ca' target='_blank'>http://www.cis1000.uoguelph.ca</a>
<b> 2. <a href='http://courselink.uoguelph.ca' target='_blank'>http://courselink.uoguelph.ca</a></b> - The rest are dead?
3. <a href='http://cis1000.uoguelph.ca' target='_blank'>http://cis1000.uoguelph.ca</a>
4. <a href='http://ta100.cis.uoguelph.ca' target='_blank'>http://ta100.cis.uoguelph.ca</a>
Ta-da!
- Shockwave
lol at your answers Shock. "You <b>LIKE</b> databases don't you?"
I bet examiners love you. <!--emo&:p--><img src='http://www.unknownworlds.com/forums/html/emoticons/tounge.gif' border='0' style='vertical-align:middle' alt='tounge.gif' /><!--endemo-->
queen or elizabeth
fiber optic cable
packet switching (I don't like any of the answers though, technically TCP is packet switched too, UDP would have been the best answer)
circuit switching (not a protocol, so WTH?)
protocol
there is no server
virtual private network
TCP
telnet (YOU SHOULD BE USING SSH!)
IP address
a client
a firewall (the term firewall is best suited to hardware, a better answer would be "software firewall")
ASCII mode performs conversions between machine-specific values during transfer while binary mode does not (I don't think this is true, but none of the answeres looked right)
video conferencing
direction (possibly latency, I like direction better becuase the real problem is that upstream bandwidth via satellite is really low, question should be less vaugue)
asynchronous can be any length
neither A nor B (WTH is he talking about?)
both A and B
not all homes have high speed internet (??? WTH!? WORST QUESTION EVER! none of the answeres are really correct)
absolute references never change (It'd be really helpfull to have a context for this)
$C2+B$6 (Not sure, shouldn't the question say that we're talking about Excell here?)
pie
file, table (Not familiar with database terminology, basically a guess)
records are linked together (Not familiar with database terminology, basically a guess)
records are all the same length
having repeated data
more specific searches (No idea, not a database guy)
more specific searches (No idea, not a database guy)
No idea<!--c2--></td></tr></table><div class='postcolor'><!--ec2-->
Any questions on why I answered what I did?
Relational databases, the tables are linked. Entries in the tables are indexed across the linked tables by SINs. (Filemaker Pro)
"queen elizabeth" will return the least number of matching pages (but the most RELEVANT to queen elizabeth)
queen OR elizabeth will return the MOST number of matching pages (but most of them will be irrelevant)
#9 - TCP. UDP is a faster way to get it there, but it will not neccessarily all get there in order. That's why UDP is used for FPS netcode.. less lag on updates, but you can run into choke. <!--emo&:)--><img src='http://www.unknownworlds.com/forums/html/emoticons/smile-fix.gif' border='0' style='vertical-align:middle' alt='smile-fix.gif' /><!--endemo-->
Video conferencing. Highest bandwidth application EASILY. (I've run 6 VoIP streams over a 56K at a show site before, and one vid link over a T3-equivalent satlink)
MoDem = Modulate/Demodulate.
24 is incorrect... it's not file/table. There are many dbases that use a unified filestructure. I believe it's record/table.
Go geek powa!