Topic 3

Question 1

JDBC

Answer 1

Java Database Connectivity, accesses data as rows and columns

Question 2

Data access

Answer 2

the process of retrieving and manipulating data from a data source

Question 3

Examples of data sources

Answer 3

relational database servers, text files, spreadsheets and mainframes

Question 4

Database catalogue

Answer 4

refers tot he database system tables

Question 5

System tables

Answer 5

used to store information about the database, tables you created and the structure

Question 6

Metadata

Answer 6

describes the content of the database

Question 7

What is data?

Answer 7

Information

Question 8

What is a relational database?

Answer 8

a database that is organized into tables, which consists of rows and columns

Question 9

What is a database?

Answer 9

an organized collection of data

Question 10

What are the two ways to access a relational database from Java?

Answer 10

JDBC and JPA

Question 11

JPA

Answer 11

Java Persistence API, accesses data through Java objects using a concept called object-relational mapping(ORM)

Question 12

Driver

Answer 12

knows how to get a connection to their database

Question 13

connection

Answer 13

knows how to communicate with the database

Question 14

statement

Answer 14

knows how to run the SQL, an object used to submit a query to a database

Question 15

resultset

Answer 15

knows what was returned by a SELECT query