CS1020 Introduction to Computers
Section 1
Final Exam
Date: Wed Mar 17, 2004
Student Name:
Last 4 digit of student ID:
The following tables are given:
| Class | 1 | 5 | 10 | 15 | 20 | 25 | 30 | |||||||||||||||||||||||||||
| A | 0 | Network (7 bits) |
Host (24 bits) |
|||||||||||||||||||||||||||||||
| B | 1 | 0 | Network (14 bits) |
Host (16 bits) |
||||||||||||||||||||||||||||||
| C | 1 | 1 | 0 | Network (21 bits) |
Host (8 bits) |
|||||||||||||||||||||||||||||
| D | 1 | 1 | 1 | 0 | Multicast address |
|||||||||||||||||||||||||||||
| E | 1 | 1 | 1 | 1 | 0 | Reserved for future use |
||||||||||||||||||||||||||||
| Class | # of networks can be identified | # of hosts in each network |
|---|---|---|
A |
126 |
16 million |
B |
16382 |
64K |
C |
2097152 |
254 |
1. Give the following 3 database tables
Catalog Table
call # |
title |
author |
subject |
publisher |
publication date |
edition |
A123 |
Introduction to database |
K. Smith |
Computer Science |
ABC publishing |
01/02/2003 |
1 |
B325 |
Cost of freedom |
J. Brown |
Politice |
XYZ publishing |
02/12/2002 |
2 |
Circulation Table
call# |
Due date |
Patron SSN |
A123 |
||
B325 |
03/23/2004 |
123-45-6789 |
Patron Table
Patron SSN |
Last Name |
First Name |
Address |
Fine owed |
123-45-6789 |
White |
Paul |
123 B Street |
0 |
987-65-4321 |
King |
Simon |
456 C Street |
12 |
To look for last name of the person who borrowed the book "Cost of freedom", which table(s) do I need to look up? Do I need to join tables? If yes, show the resultant table.
2. State 1 problem of the token ring network protocol.
3. What's the long form of HTML?
4. Evaluate the decimal number 978. Illustrate your steps.
5. Evaulate the following binary number and express their values in decimal form. Illustrate your steps.
6. The original permission setting of a file, file1, is rw-r--r--. Give 3 possible options of chmod to change the permission setting to --x-w---x.
7. The original permission setting of a file, file1, is r--r--r--. Show the new permission setting if the following command line is executed. Illustrate your steps.
chmod 567 file1
.
8. To post a directory onto the Internet, why the execute permission must be granted to other?
9. Render the following web page.
<html>
<head>
<title>My first web page </title>
</head>
<body>
<table width="75%" border="1" cellspacing="2" cellpadding="2">
<tr>
<td>F</td>
<td>3</td>
<td>G</td>
</tr>
<tr>
<td>A</td>
<td>2</td>
<td>H</td>
</tr>
<tr>
<td>E</td>
<td>1</td>
<td>C</td>
</tr>
</table>
</body>
</html>
10. If there are 255 computers on a network, in order to connect this network onto the Internet. Which class of IP address should be assigned to these computers.
11. Which class of IP address does this IP address belong to? Also, convert this IP address into dotted decimal form.
| 1 | 1 | 0 | 1 | 0 | 1 | 0 | 0 | 0 | 1 | 1 | 1 | 0 | 1 | 0 | 1 | 0 | 1 | 1 | 0 | 1 | 0 | 0 | 1 | 0 | 0 | 1 | 0 | 1 | 0 | 1 | 1 |
12. Give the command line to resolve the IP address of the domain marsrovers.jpl.nasa.gov
13. Provide the following 4 types of security threats
a) Active attack can cause which security threats
b) Passive attack can cause which security threats
14. Under patent protection, how long can a patent holder have the exclusive rights on the invention?