final exam SR

Question 1

What are the four types of queries we can perform on data?

Answer 1

SELECT, INSERT, UPDATE, DELETE

Question 2

How do databases help decrease our workload as programmers? In other words, what can databases do to make it so we have to write less code?

Answer 2

Databases allow us to filter, sort, and group data with far less code

Question 3

How are databases better than using text files?

Answer 3

Databases allow for random access of data

Question 4

Which line is it important we always have in our queries, especially with DELETE and
UPDATE queries?

Answer 4

We should always have a WHERE clause

Question 5

Explain conceptually (not programmatically) how two tables can be stitched together to
create more complex result sets.

Answer 5

We can use the primary key / foreign key relationship between two tables to specify how the tables interrelate

Question 6

What happens if we do not specify how two tables relate to each other?

Answer 6

The result is a cartesian product

Question 7

How does Maven help us make our code portable to other programmers?

Answer 7

Maven gets the dependencies for us meaning anyone who uses our project, will have the correct items to run the program

Question 8

What are the three things we need to tell Maven about a dependency? What are the values for these items in the case of the SQLite JDBC?

Answer 8

Group ID - org.xerial
artifact ID - sqlite-jdbc
Version - 3.39.4.0

Question 9

What is our groupID when creating Maven projects?

Answer 9

edu.psu.bd.cs.<username></username>

Question 10

Why is the JDBC important?

Answer 10

The JDBC allows java to talk to the database

Question 11

Why do we have to close ResultSet objects?

Answer 11

Closing the ResultSet releases a lock on the data

Question 12

Besides the connection what do we need to create in order to run a query against the
database?

Answer 12

Prepared statement()

Question 13

What is Spring Framework?

Answer 13

Spring Framework is a tool that helps do the “heavy lifting” when we want to create a web application

Question 14

Why do we like using Maven when working with Spring?

Answer 14

Spring has numerous dependencies and having a tool to manage these dependencies means less work for us as programmers

Question 15

What benefits does Spring provide when trying to create methods that can be run over the internet?

Answer 15

1. Spring creates a Tomcat sever to run our application
2. Spring handles I/O conversion to and from bytes
3. Spring provides a mechanism to connect methods with URL’s and HTTP Verbs

Question 16

What annotation do we need to use to make a class with methods that can be called over the web?

Answer 16

@RestController

Question 17

What annotation do we need to use to indicate how method that can be called over the internet?

Answer 17

@GetMappins