Web Server Administration, CIS 83 Flashcards

Terms Definitions
Most databases are _________ and organize data into tables.


Chap 7.
Relational
What three basic steps dose a program perform?

Chap 7.
Input
Process
Outout
The purpose of a DBMS is to?
Store data in an organized manner for further processing.

Chap 7.
Structured Query Language (SQL) is the language used to?
Define and manipulate the data.


Chap 7.
What is MTA and what dose it do?


Chap 8.
MTA (Mail Transfer Agent)
Accepts e-mail from clients and sends e-mail to another MTA for storage.

Exchange 2000, sendmail
What is MDA and what dose it do?


Chap 8.
MDA (Mail Delivery Agent)
Delivers e-mail from server to MUA
Exchange 2000, imap-2001
What is MUA and what dose it do?


Chap 8.
MUA (Mail User Agent)
E-mail client
Outlook, KMail
E-mail System Terminology:

What dose Masquerading do?


Chap 8.
Masquerading
Replace actual host name with domain name
E-mail System Terminology:

What dose Relaying do?
Relaying
The process of sending e-mail to an intermediate e-mail server before the message is transmitted to its final destination.

This should not be allowed from the Internet because spammers could use it to send e-mail.

Chap 7.
Database Tables:

What is a primary Key and foreign key?


Chap. 7
A primary key uniquely defines a row of data

A foreign key is a column in a table that is related to a primary key
Three Categories of SQL:

Define DML, DDL & DCL.


Chap 7.
Data Manipulation Language (DML)
Used for programming and to insert, update, delete, and retrieve data
Data Definition Language (DDL)
Used to create tables and other related structures in a database
Data Control Language (DCL)
Allows you to control access to tables
Installing and Testing SQL Server- Authentication Mode:

Define Windows Authentication and Mixed Mode.

Chap 7.
The Windows Authentication Mode controls access to the database based on Windows users.
The Mixed Mode allows for SQL Server Authentication
This is more appropriate for Web-based systems.
The sa (systems administrator) account is a SQL Server user that has complete control over the databases.
Web-based Programming Environment:

Define CGI, Perl, JSP & Cookies.
Cookie
Text that a Web site stores on your disk
Common Gateway Interface (CGI)
A protocol that allows the operating system to interact with the Web server
Practical extraction and reporting language (Perl)
First popular language for Web servers
Java Server Pages (JSP)
Language similar to Java
Web-based Programming Environment:

Define ASP, ASP.NET, .NET Framework & PHP.


Chap 7.
Active Server Pages (ASP)
Script-based environment available on all IIS Web servers
ASP.NET
Compiled programs operate under .NET Framework
.NET Framework is an integral part of Windows Server 2003 and can be installed on Windows 2000
PHP Hypertext Protocol (PHP)
Popular language available on most platforms
The structure of JSP, ASP, and PHP are similar
Using Data Source Names (DSNs):

What are DSNs?


Chap 7.
DSNs are connections to databases that an administrator creates on the server
They encapsulate the information on the previous slide concerning the connection information
The Data Sources (ODBC) wizard is in the Control Panel
Once it is created, you can create a connection with Conn.open "DSN=humanresources;uid=sa"
What is the role of DNS in E-mail Systems?


Chap 8.
A domain name, such as technowidgets.com, needs to be associated with two IP addresses
One IP address can be for a Web site
Another IP address is for e-mail
To associate a domain name, or any other host name, with the IP address of an e-mail server, you need an MX record.

technowidgets.com. IN MX 10 mail.technowidgets.com.

The 10 refers to the priority of the e-mail server if there are multiple e-mail servers
E-mail System Terminology:

What do the following protocols do?

SMTP, POP3 & IMAP4


Chap 8.
SMTP (Simple Mail Transfer Protocol)
To send e-mail messages
POP3 (Post Office Protocol)
To retrieve e-mail
Typically, all messages are downloaded to a client
IMAP4 (Internet Mail Access Protocol)
To retrieve e-mail
E-mail stays on the server
You can create folders on server to store e-mail
Describe Web-based E-mail Clients-Advantages.



Chap 8.
Because a browser is used, no client configuration is needed
The lack of configuration can significantly reduce support costs
No specialized client software is needed
Users are not required to retrieve e-mail from specific computers that have been configured for them
POP3 or IMAP4 protocols are not required, which reduces server-side support
Because Web-based e-mail is not constrained by POP3 or IMAP4 protocols, a richer environment can be developed that extends beyond basic e-mail
Installing Microsoft Exchange 2000:

What needs to be installed prior to installing Echange?

Hint: Type h


Chap 8.
SMTP is part of IIS, not Exchange, and needs to be installed
NNTP (Network News Transport Protocol) needs to be installed before Exchange and is also part of IIS
Active Directory is required for Exchange
Once the above are installed, the Exchange wizard guides you through a simple installation
To use Exchange 2000 on Windows Server 2003, Exchange 2000 Service Pack 3 is required
Installing Microsoft Exchange 2000:

What needs to be installed prior to installing Echange?

Hint: Type h


Chap 8.
Two protocols and a service
Understanding FTP Services:

What is FTP used for?
FTP is used to transfer files from a server to a client (download) and transfer files from a client to a server (upload)
Understanding FTP Services:

What is a FTP client?
FTP client is the browser
Also command-line and GUI clients

A 3ed party tool
Understanding FTP Services:

How secure is FTP?
FTP servers can operate as anonymous servers or they can require a valid logon
Typically, they are anonymous
FTP servers are not secure; user names and passwords are not sent encrypted
Understanding FTP Services:

What ports connect to FTP?
The client connects to port 21 (control port)
Port 20 (data port) is used to tell the client which unprivileged port to use for data transfer
The above describes passive mode FTP, the most common type
Install and Configure Windows FTP Server:

How do you install FTP on a Windows server. What application controls it.
FRP Windows component
Part of IIS

Configured through Internet Information Services (IIS) Manager
Understanding News Servers

Tell me something about news groups.
News servers allow threaded discussions
You post messages in a newsgroup
A newsgroup focuses on a single topic
There are more than 40,000 public newsgroups
There are hundreds of gigabytes of information generated per day
News servers can be set up for use within an organization
Things to know about Telnet in Linux:
By default, telnet is installed but not enabled
chkconfig telnet on
service xinetd restart
Telnet should not be used in a non-secure environment such as over the Internet because user names and passwords are not encrypted
ssh is a secure replacement (described in Chapter 10)
You cannot log on as root
However, you can log on as another user and "su root"
SSH terms to know for the test.

SSH
SFTP
SCP
Secure Shell
Secure FTP
Secure Copy

All 3 are installed when you install ssh.
Tell me about Terminal Services in Windows.
GUI-based access to a server
Can be used for remote administration or running applications remotely
In Windows 2000, you select remote administration on installation
In Windows Server 2003, it is installed already and you have to enable it
Client software is included in Windows Server 2003 and Windows XP
You have to install client software for Windows 2000
Understanding Streaming Media Services
Used to transfer video and audio
By default, UDP is used
Although TCP and HTTP can be used because of firewall issues in an organization
No single standard exists as is true with SMTP, HTTP, POP3, and others
Broadcast methods
unicast – each packet is sent individually to each client
multicast – each packet is sent to many clients
Understanding Streaming Media Services
Helix Universal Server from Real Networks is popular
Recognizes both Real Networks protocols (RTSP, PNA) and the Microsoft protocol (MMS)
Windows Media Services is a Windows component
Creates a folder called \ASFRoot to store Advanced Streaming Format (ASF) files

Flash
Understanding E-Commerce Servers
Can be as simple as a product list and a shopping cart
Can be as complex as amazon.com or dell.com
Microsoft Commerce Server is an add-on to IIS
Incorporates a number of features required for a typical e-commerce site
Highly customizable
What are names of common Virtual Machine downloads.
VM Ware &
Microsoft Virtual Machine Download.
What are the basic types of DNS records?
Name server – also known as DNS server. Supports name-to-address and address-to-name resolution.

Name resolver – also called DNS client. Can contact DNS server to lookup name
Used by browsers, e-mail clients, and client utilities such as ping and tracert
What are the basics of installing Exchange?
1) SMTP is part of IIS, not Exchange, and needs to be installed.
2) NNTP (Network News Transport Protocol) needs to be installed before Exchange and is also part of IIS.
3) Active Directory is required for Exchange
Once the above are installed. The Exchange wizard guides you through a simple installation
To use Exchange 2000 on Windows Server 2003,
4)Exchange 2000 Service Pack-3 is required
What are the basics of an FTP server?
FTP is used to transfer files from a server to a client (download) and transfer files from a client to a server (upload)

FTP client is the browser
Also command-line and GUI clients.

FTP servers can operate as anonymous servers or they can require a valid logon
Typically, they are anonymous
FTP servers are not secure; user names and passwords are not sent encrypted.

The client connects to port 21 (control port)
Port 20 (data port) is used to tell the client which unprivileged port to use for data transfer.
The above describes passive mode FTP, the most common type.

Windows component Part of IIS
What are the types of web authentication available?
The Windows Authentication Mode controls access to the database based on Windows users.

The Mixed Mode allows for SQL Server Authentication
This is more appropriate for Web-based systems.
The sa (systems administrator) account is a SQL Server user that has complete control over the databases.
What are the basic parts of a SQL database table?
A primary key uniquely defines a row of data SSN in the Employee table and Department number in the Department table.

A foreign key is a column in a table that is related to a primary key
Department number in the Employee table
Also, know these acronyms, and for protocols, what they do and what ports they commonly reside upon:

DNS
DNS is used to map host names to IP addresses on the Internet
Also called name resolution or address resolution
Whenever a host is added, a configuration file has to be manually changed
A host represents a service on a server such as FTP or a Web server
There can be many hosts on a single computer
A Microsoft Windows 2000 or Windows 2003 network uses DNS to resolve computer names on a LAN
DNS in Windows is designed to be dynamic - as computers are added to the network, DNS automatically changes
Also, know these acronyms, and for protocols, what they do and what ports they commonly reside upon:

MX
Mail Exchanger (MX)

Identifies a server used for processing and delivering e-mail for the domain.

IN MX 10 mail.technowidgets.com.

IN MX 10 mail
Also, know these acronyms, and for protocols, what they do and what ports they commonly reside upon:

A
Address (A)

Associates a host to an IP address.

mail IN A 192.168.0.200

web1 IN A 192.168.0.100

research IN A 192.168.0.150
Also, know these acronyms, and for protocols, what they do and what ports they commonly reside upon:

FTP
File Transfer Protocol (FTP)

FTP client is the browser

The client connects to port 21 (control port)
Port 20 (data port) is used to tell the client which unprivileged port to use for data transfer
Also, know these acronyms, and for protocols, what they do and what ports they commonly reside upon:

SSH
Secure Shell (SSH) is a secure replacement for Telnet

An SSH server, by default, listens on the standard TCP port 22.
Also, know these acronyms, and for protocols, what they do and what ports they commonly reside upon:

• SSL
Secure Sockets Layer (SSL)

A digital certificate issued by a certification authority (CA) identifies an organization
The public key infrastructure (PKI) defines the system of CAs and certificates
Public key cryptography depends on two keys
A public key is shared with everyone
The public key can be used to encrypt data
Only the owner of the public key has the corresponding private key which is needed to decrypt the data
Also, know these acronyms, and for protocols, what they do and what ports they commonly reside upon:

• SMTP
SMTP (Simple Mail Transfer Protocol)
To send e-mail messages
Also, know these acronyms, and for protocols, what they do and what ports they commonly reside upon:

• POP
POP3 (Post Office Protocol)
To retrieve e-mail
Typically, all messages are downloaded to a client
Also, know these acronyms, and for protocols, what they do and what ports they commonly reside upon:

• IMAP
IMAP4 (Internet Mail Access Protocol)
To retrieve e-mail
E-mail stays on the server
You can create folders on server to store e-mail
Also, know these acronyms, and for protocols, what they do and what ports they commonly reside upon:

• MTA
MTA (Mail Transfer Agent)

Accepts e-mail from clients and sends e-mail to another MTA for storage
Exchange 2000, sendmail
Also, know these acronyms, and for protocols, what they do and what ports they commonly reside upon:

• MUA
MUA (Mail User Agent)
E-mail client
Outlook, KMail
Also, know these acronyms, and for protocols, what they do and what ports they commonly reside upon:

• MDA
MDA (Mail Delivery Agent)
Delivers e-mail from server to MUA
Exchange 2000, imap-2001
Also, know these acronyms, and for protocols, what they do and what ports they commonly reside upon:

• NNTP
NNTP (Network News Transport Protocol) needs to be installed before Exchange and is also part of IIS
Also, know these acronyms, and for protocols, what they do and what ports they commonly reside upon:

• CGI
Common Gateway Interface (CGI)
A protocol that allows the operating system to interact with the Web server
Also, know these acronyms, and for protocols, what they do and what ports they commonly reside upon:

• ASP
Active Server Pages (ASP)
Script-based environment available on all IIS Web servers
ASP.NET
Compiled programs operate under .NET Framework
.NET Framework is an integral part of Windows Server 2003 and can be installed on Windows 2000
/ 53
Term:
Definition:
Definition:

Leave a Comment ({[ getComments().length ]})

Comments ({[ getComments().length ]})

{[comment.username]}

{[ comment.comment ]}

View All {[ getComments().length ]} Comments
Ask a homework question - tutors are online