Study your flashcards anywhere!

Download the official Cram app for free >

  • Shuffle
    Toggle On
    Toggle Off
  • Alphabetize
    Toggle On
    Toggle Off
  • Front First
    Toggle On
    Toggle Off
  • Both Sides
    Toggle On
    Toggle Off
  • Read
    Toggle On
    Toggle Off

How to study your flashcards.

Right/Left arrow keys: Navigate between flashcards.right arrow keyleft arrow key

Up/Down arrow keys: Flip the card between the front and back.down keyup key

H key: Show hint (3rd side).h key

A key: Read text to speech.a key


Play button


Play button




Click to flip

12 Cards in this Set

  • Front
  • Back
Understand databases and their components
A database is a file that contains data in fields and records. These fields and records are contained in a table.
The table may be indexed on one or more fields, as long as these fields can uniquely identify each record.
Understand the client/server model and how it is used with databases.
The client/server model includes a user interface to data, process logic, and data storage.
Two-tier, three-tier, and N-tier models allow developers and server administrators to configure their client/server systems for optimal performance, by isolating or integrating database operations.
Understand database reliability
Must incorporate load balancing and fault tolerance. Database software has additional features to maintain reliability, including transaction processing features in SQL.
Be able to list the different types of databases and database management systems, including DBMS, RDBMS, and ODBMS.
DBMS: Uses a non-relational or flat-file model where all data is contained in a single file.
RDBMS: Uses a relational model, where multiple data tables are linked together through the use of common fields.
ODBMS: An object-oriented model, which allows developers to define their own data types.
Be able to differentiate between client-side and server-side scripting.
Client-side: Used to control or program events that appear in the web browser, including animations and data validation.
Server-side: Used by web servers to create custom web pages, based on the user's requests. Tells the web server where the server-side code should be executed.
Know how HTML forms are processed, including actions and methods.
1. User presses Submit; form's contents sent to web server for processing.
2. Data can be included in the HTTP header with the POST method.
3.Also can be appended to the URL string, using the GET method.
4. The POST method can use encryption to protect the form's contents during transmission.
5. Each form is assigned an action, which is the address of the appropriate database gateway for processing the form.
Know how server application programming interfaces work.
SAPIs are sets of dynamic link libraries that web servers use to add functionality. ISAPI is the leading SAPI and works with IIS. Netscape's NSAPI is still in use, although it has become a legaxy product.
Know HTML database gateway solutions
You can save HTML versions of database files and publish them to web servers. Access and other database clients can perform these conversions. There are also HTML gateway packages that use ISAPI and NSAPI to convert data to HTML.
Be able to describe the Java programming languages.
Java is a cross-platform, object-oriented programming language that is used for developing Internet-enabled applications. JVM is used to run Java apps on a computer. A well-written Java application can be run on any computer that has a JVM.
Know the functions of Java servlets and how they differ from scripting languages.
Java servlets are small Java services or applications that can be used with a web server. Servlets may be chained together, passing requests and output to other servlets to process a task.
Be able to describe other database gateway technologies including JavaServer Pages and ColdFusion.
JavaServer Pages is a database scripting language that uses a Java servlet to extend a web server's abilities. JSP is more extensible than Perl, PHP, ASP because developers can use the Java programming language to create sophisticated applications. CF uses HTML-like tags and SAPIs to provide a web database gateway.
Be able to differentiate between ODBC and JDBC.
ODBC is a Microsoft technology that is used for referencing databases. A client can communicate with a database by using an ODBC driver manager. The driver manager is responsible for requesting data. JDBC is a standard for working with SQL-compliant databases, using four different types for database communication.