BCIS 3680 STUDY GUIDE QUESTIONS, Exams of Advanced Education

BCIS 3680 STUDY GUIDE QUESTIONS

Typology: Exams

2025/2026

Available from 01/13/2026

PRO.BILLY
PRO.BILLY 🇺🇸

1.6K documents

1 / 3

Toggle sidebar

This page cannot be seen from the preview

Don't miss anything!

bg1
BCIS 3680 STUDY GUIDE
Error - Answers -refers to an illegal operation performed by the user which results in
the abnormal working of the program.
Unchecked Exception - Answers -An exception that occurs at the time of the execution.
Checked Exception - Answers -means that the compiler will examine your code before
compiling.
Logical Error - Answers -An error that occurs when the output of the program does not
match with the programmer expected.
ArrayIndexOutOfBounds - Answers -An error that happens when you refer to an
element number larger than your array.
StringIndexOutOfBounds - Answers -Thrown when an index is either negative or
greater than the length of the String.
ArithmeticException - Answers -An exception thrown when division by 0 occurs.
NumberFormatException - Answers -Thrown when a method that converts a String to a
number receives a String that it cannot convert.
FileNotFoundException - Answers -Thrown when a method that converts a String to a
number receives a String that it cannot convert.
Command/keystrokes to log in to and exit MySQL. - Answers -Mysql -u root -p
Exit an incomplete SQL Statement - Answers -\q, exit, quit
Select which Database to work on - Answers -use <Database>;
Run SQL script files - Answers -source <source files>
List tables in a database - Answers -show<tables>;
Table - 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.
pf3

Partial preview of the text

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

BCIS 3680 STUDY GUIDE

Error - Answers - refers to an illegal operation performed by the user which results in the abnormal working of the program. Unchecked Exception - Answers - An exception that occurs at the time of the execution. Checked Exception - Answers - means that the compiler will examine your code before compiling. Logical Error - Answers - An error that occurs when the output of the program does not match with the programmer expected. ArrayIndexOutOfBounds - Answers - An error that happens when you refer to an element number larger than your array. StringIndexOutOfBounds - Answers - Thrown when an index is either negative or greater than the length of the String. ArithmeticException - Answers - An exception thrown when division by 0 occurs. NumberFormatException - Answers - Thrown when a method that converts a String to a number receives a String that it cannot convert. FileNotFoundException - Answers - Thrown when a method that converts a String to a number receives a String that it cannot convert. Command/keystrokes to log in to and exit MySQL. - Answers - Mysql - u root - p Exit an incomplete SQL Statement - Answers - \q, exit, quit Select which Database to work on - Answers - use ; Run SQL script files - Answers - source List tables in a database - Answers - show; Table - 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 - Cannot be null, 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 two tables. Null - Answers - A special "value" in the database. It means there is no entry in a particular field. SQL command to display the schema of a table. - Answers - Show columns from ; CRUD - Answers - SELECT, FROM, WHERE Describe the role of JDBC in database driven applications. - Answers - JDBC (Java Database Connectivity) is a Java API (Application Programming Interface) that allows Java programs to interact with databases using SQL (Structured Query Language). It provides a standard set of interfaces that enable Java applications to access and manipulate data in a wide range of databases, including Oracle, MySQL, SQL Server, and others. Java Package - Answers - java.sql Java.sql classes - Answers - Connection, Statement, ResultSet Know the steps involved in getting ready to perform database operations in Java code. - Answers - Compose the connection string, Establish the connection, (create the connection object), Create the statement object, Execute an SQL command (query or update), Process the results (the ResultSet object) , Close the connection Identify the various parts in a connection string and know the characters that connect the parts together. - Answers - Connection cxn = DriverManager.getConnection(cxnString, [Username], [Password]); JDBC Connector - Answers - mysql-connector-java-5.1.7.bin.jar Connection - Answers - jdbc:mysql://localhost:3306/forta?user=root&password=bcis Statement - Answers - Statement stm = cxn.createStatement(); executeUpdate() - Answers - returns the number of rows affected and is used for INSERT, UPDATE, DELETE, or a DDL. executeQuery() - Answers - returns the SQL ResultSet and is used for SELECT statements.