Use LEFT and RIGHT arrow keys to navigate between flashcards;
Use UP and DOWN arrow keys to flip the card;
H to show hint;
A reads text to speech;
52 Cards in this Set
- Front
- Back
- 3rd side (hint)
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 |
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 |
|