BCIS 3680 FINAL STUDY GUIDE 2026, Exams of Advanced Education

BCIS 3680 FINAL STUDY GUIDE 2026

Typology: Exams

2025/2026

Available from 01/13/2026

PRO.BILLY
PRO.BILLY 🇺🇸

1.6K documents

1 / 4

Toggle sidebar

This page cannot be seen from the preview

Don't miss anything!

bg1
BCIS 3680 FINAL STUDY GUIDE
Error: unchecked exception - Answers -These are critical errors due to rare reasons,
such as:
An internal error in the Java Virtual Machine, Computer running out of memory.
Error: checked exception - Answers -These are errors having to do with your program,
they are checked before compiling and will have to be addressed before compiling
Error: logical - Answers -These are errors caused by erroneously used variables,
method names, data types, etc. may not cause run time errors if they are coincidentally
compatible and don't cause syntax errors when misplaced.
superclass of all exceptions and the major methods - Answers -RuntimeException
handling of exceptions - Answers -An exception handler is a section of code that
gracefully responds to exceptions.
try catchfinally block - Answers -try
{
(try block statements...)
}
catch (ExceptionType ParameterName)
{
(catch block statements...)
}
finally
{
(finally block statements...)
}
log in to MySQL - Answers -mysql -u root -p
Log out of MySQL - Answers -either type:
\q
exit
quit
List existing Databases in MySQL - Answers -show databases;
Selecting Database to work on - Answers -use <Database>;
Show tables in Database - Answers -show tables;
Run SQL script files - Answers -Sourse <sourse files>;
pf3
pf4

Partial preview of the text

Download BCIS 3680 FINAL STUDY GUIDE 2026 and more Exams Advanced Education in PDF only on Docsity!

BCIS 3680 FINAL STUDY GUIDE

Error: unchecked exception - Answers - These are critical errors due to rare reasons, such as: An internal error in the Java Virtual Machine, Computer running out of memory. Error: checked exception - Answers - These are errors having to do with your program, they are checked before compiling and will have to be addressed before compiling Error: logical - Answers - These are errors caused by erroneously used variables, method names, data types, etc. may not cause run time errors if they are coincidentally compatible and don't cause syntax errors when misplaced. superclass of all exceptions and the major methods - Answers - RuntimeException handling of exceptions - Answers - An exception handler is a section of code that gracefully responds to exceptions. try‐ catch‐finally block - Answers - try { (try block statements...) } catch (ExceptionType ParameterName) { (catch block statements...) } finally { (finally block statements...) } log in to MySQL - Answers - mysql - u root - p Log out of MySQL - Answers - either type: \q exit quit List existing Databases in MySQL - Answers - show databases; Selecting Database to work on - Answers - use ; Show tables in Database - Answers - show tables; Run SQL script files - Answers - Sourse ;

Tables - Answers - A structured list of data of a specific type. Row - Answers - Each row contains data for a single item. Column - Answers - Each column defines a certain attribute of a record, e.g., name, address, phone number, etc. Primary Key - Answers - a field that uniquely identifies a record in a table Foreign key - Answers - A primary key of one table that appears as an attribute in another table and acts to provide a logical relationship between the two tables null - Answers - A special "value" in database. It means there is no entry in a particular field. Schema - Answers - defines the datatype for the information to be stored in a column - text, numbers, currency values, even large blobs of binary information. How to show Schema - Answers - show columns from customers; Select in MySQL - Answers - Select * from

; Select from
; JDBC - Answers - JDBC is a technology developed by Sun to allow to access virtually any database system from JSP pages or Java applications. adding JDBC to java program - Answers -- Create \lib folder in program

  • Get mysql-connector-java-5.1.7.bin.jar from Canvas or the course VM
  • store in folder
  • right click on libraries in the project
  • click "add JAR/Folder"
    • Select file and select "Relative Path" Java package for SQL - Answers - java.sql java.sql classes - Answers --Connection
  • Statement
  • ResultSet Steps to Use Database - Answers --Compose the connection string
  • Establish the connection(create the connectionobject)
  • Create the statement object
  • Execute an SQL command (query or update)
  • Process the results (the ResultSet object)
  • Close the connection

What does JDBC getConnection() do? - Answers - Searches for and loads a compatible JDBC driver for the database specified by the URL Value Returning Menthod - Answers - String sql = "CREATE TABLE product " + "(productID char(5), name varchar(15))"; int result = stm.executeUpdate(sql); ResultSet to an ArrayList. - Answers - while(result.next()) { Result.add(result.getString("Enter the columnname here"); } Three-Tier (n-Tier) Architecture - Answers - Modern enterprise applications commonly employ a three-tier (or even n-tier) architecture. Three-Tier (n-Tier) Architecture example - Answers - User Interface Tier (Presentation Tier) <=> Business Logic Tier <=> Data Tier