final exam MC

Question 1

what is the name of the database we are using in lecture, lab, and homework?

Answer 1

SQLite

Question 2

Which of the following allows us to indicate two tables to be joined?

Answer 2

INNER JOIN

Question 3

which clause allows us to indicate how we want to filter the records?

Answer 3

WHERE

Question 4

What is the clause that indicates the field(s) to be retrieved from a query?

Answer 4

SELECT

Question 5

what is the clause which indicates the tables to be used in the query

Answer 5

FROM

Question 6

which query allows us to modify a record in a table?

Answer 6

UPDATE

Question 7

which query lets us delete a record from a table?

Answer 7

DELETE

Question 8

Which clause prevents us from deleting all records in a table when writing a DELETE query?

Answer 8

WHERE

Question 9

We can specify which fields in a table we want to fill in when we create a new record, but we are required to fill in any field that cannot be null when creating the record (T/F)

Answer 9

True

Question 10

When writing an update statement if you forget the WHERE clause, the entire table will be updated…not just the records you want to change.

Answer 10

True

Question 11

What is the tool that manages our dependencies for us?

Answer 11

Maven

Question 12

The three things we need for coordinates are the company id, artifact id, and version.

Answer 12

False

Question 13

To execute a SELECT query in the JDBC what method should you use?

Answer 13

executeQuery()

Question 14

what holds the results from running a SELECT query?

Answer 14

ResultSet