Persistence

Question 1

What do we call a primary key that consists of multiple columns in a table?
composite key

consisting key

foreign key

double-primary key

composting key

Answer 1

?

Question 2

ACID stands for

Atomicity, Consistency, Isolation, Durability

Authentic, Consistency, Immutable, Duplicable

Atomicity, Compatable, Immutable, Durability

Automated, Compatable, Isolation, Deterministic

Answer 2

Atomicity, Consistency, Isolation, Durability

Question 3

In a prepared statement, data is replaced with

Question marks

Variable names

Dollar signs

Excalamation points

Answer 3

Question marks

Question 4

In JDBC, a Statement is unsafe because

It is vulnerable to SQL injection attacks

Unlike Prepared Statements, data sent by a Statement query is unencrypted

Statements are safe

Statements may throw an exception which must be handled, while PreparedStatements will never throw exceptions

Answer 4

It is vulnerable to SQL injection attacks

Question 5

Referential integrity stipulates

Foreign keys must always reference a valid unique key

Every table must have a primary key

Joins should only be used with foreign and primary keys

Columns should be atomic

Answer 5

Foreign keys must always reference a valid unique key

Question 6

MAX(), SUM(), and COUNT() are examples of

Aggregate functions

Scalar functions

Operators

Sequences

Answer 6

Aggregate functions

Question 7

UPPER(), ABS(), CONCAT() are examples of

Scalar functions

Aggregate Functions

Constraints

Filters

Answer 7

Scalar functions

Question 8

Insert is a part of this sublanguage

DML

DQL

TCL

DDL

Answer 8

DML

Question 9

What is required of a primary key? (Select all that apply)

Unique Value

Integer Data Type

Not Null

Answer 9

Unique Value

Not Null

Question 10

A join can be used to combine information from two separate tables

TRUE

FALSE

Answer 10

TRUE

Question 11

Use the AS keyword to specify an alias

TRUE

FALSE

Answer 11

TRUE

Question 12

CRUD stands for:

Create, Read, Update, Delete

Create, Retrieve, Update, Derive

Create, Retrieve, Undo, Delete

Control, Read, Undo, Delete

Answer 12

Create, Read, Update, Delete

Question 13

Which of the following retrieves all columns and all rows from the Customers table?

SELECT * FROM Customers

SELECT all FROM Customers

SELECT % FROM Customers

SELECT all columns FROM Customers

Answer 13

SELECT * FROM Customers

Question 14

Which of the following clauses are added to sort the results of a SELECT statement?

ORDER BY

HAVING

GROUP BY

WHERE

Answer 14

ORDER BY

Question 15

Which of the following returns the number of records in the result from a SELECT query?

COUNT()

SUM(

ADD(

TOTAL(

Answer 15

COUNT()

Question 16

Which command is used to remove a table from memory?

DELETE

DROP

TRUNCATE

REMOVE

Answer 16

DROP

Question 17

DDL Statements include commands like INSERT, UPDATE, and DELETE?

TRUE

FALSE

Answer 17

FALSE

Question 18

n a one-to-one relationship, you typically use a third table as an association or join table.

TRUE

FALSE

Answer 18

FALSE

Question 19

In a one-to-many relationship, rows in one table can refer to multiple rows in another, but that other table can only refer to at most one row in the former table

TRUE

FALSE

Answer 19

TRUE

Question 20

A primary key is used to uniquely identify a particular entry or row in a table.

TRUE

FALSE

Answer 20

TRUE

Question 21

Which of the following are typical commands of DML?

CREATE

DROP

ALTER

UPDATE

Answer 21

?

Question 22

The SQL UPDATE statement can…

Update only one row at a time

Update multiple rows at a time

Delete a row based on a where clause

Update the current system time of the database

Answer 22

Update multiple rows at a time

Question 23

What is SQL Injection?

Using inline queries in a SqlCommand object

Injecting a SQL Statement as user input

Using Parameters to take inputs from users

Installing a plugin to SQL Server Management Studio

Answer 23

Injecting a SQL Statement as user input

Question 24

Which of the following is NOT a type of SQL constraint?

PRIMARY KEY

ALTERNATE KEY

FOREIGN KEY

UNIQUE

Answer 24

ALTERNATE KEY

Question 25

The OR operator displays a record if ANY conditions listed are true. The AND operator displays a record if ALL of the conditions listed are true

TRUE

FALSE

Answer 25

TRUE

Question 26

DDL stands for

Data Definition Language

Data Defined Language

Data Directed Language

Derived Data Language

Answer 26

Data Definition Language

Question 27

DML stands for

Data Manipulation Language

Data Manipulated Language

data Morphed Language

Defined Manipulation Language

Answer 27

Data Manipulation Language

Question 28

What JDBC object is used to reference the rows returned by a query?

Query

ResultSet

QuerySet

Results

Answer 28

?

Question 29

JDBC Exceptions
JDBC statements throw which exception(s)

IOException

JDBCConnectionException

SQLException

SQLSyntaxException

Answer 29

SQLException

Question 30

What is returned by executeUpdate?

ResultSet

a collection

Iterator

int

Answer 30

int

Question 31

True or False: Every database needs its own driver, to translate JDBC commands into something that database can understand.

TRUE

FALSE

Answer 31

TRUE

Question 32

A benefit of using JDBC is?

It abstracts the process of opening a socket connection to a database manually, and handling each request/response.

It provides features for managing transaction safety and performance

It reduces the amount of work required to make changes to your configuration

All of the above

Answer 32

All of the Above