practice sql

With SQL, how do you select a column named "FirstName" from a table named "Persons"? a. select FirstName from Persons b. Get FirstName from Persons c. select Persons.Firstname

A

Which SQL statement lets you find the sales amount for each store: Table SALES Column name -STORE_ID -STORES_DATE -SALES_AMOUNT a. SELECT STORE_ID, SUM(SALES_AMOUNT) FROM SALES GROUP BY STORE_ID; b. SELECT STORE_ID, SUM(SALES_AMOUNT) FROM SALES ORDER BY STORE_ID; c. SELECT STORE_ID, SUM(SALES_AMOUNT) FROM SALES HAVING UNIQUE STORE_ID; d. SELECT STORE_ID, SUM(SALES_AMOUNT) FROM SALES;

A. SELECT STORE_ID, SUM(SALES_AMOUNT) FROM SALES GROUP BY STORE_ID;

Which SQL statement is used in order to change the structure of a table?

ALTER

What are the aggregate functions?

AVG, CHECKSUM_AGG, COUNT, COUNT_BIG, MAX, MIN, STDEV, STDEVP, SUM, VAR, VARP

A benefit of using JDBC is? A. It abstracts the process of opening a socket connection to a database manually and handling each request/ response B. It provides features for managing transaction safety and performance C. It reduces the amount of work required to make changes to your configuration D. All of the above

D. All of the Above

Transaction Control Statements manages changes made by which type of statements?

DML

What type of SQL statements are used for managing data within tables?

Data Manipulation Language (DML)

(T or F) It is generally acceptable practice to code database credentials directly into the DriverManager.getConnection() parameters

False

(T or F) It is not necessary to call the close() method on a connection, it does not consume resources unless it is actively being used

False

(T or F) The cursor of a ResultSet begins on the first element

False

(T or F) The executeQuery() method is used to send SQL UPDATE statements to the db

False

The Check constraint ensures each row for that column must have a unique value

False

The DELETE statement is used to delete an entire table or database

False

The NOT NULL constraint ensures the value in that column meets a specific condition

False

Which constraint is used to reference a primary key of another table?

Foreign key

Which SELECT clause gathers all rows together that contain data in specified columns

GROUP BY

Which SQL statement is used to insert data into a database?

INSERT INTO

The SQL keyword __________ is used with wildcards

Like

Which is not a JDBC statement? A. PreparedStatement B. Statement C. CallableStatement D. MacroStatement

MacroStatement

Which SQL keyword is used to sort the result set?

ORDER BY

Which constraint is used to uniquely identify each row?

Primary key

With SQL, how do you select all the records from a table named "Persons" where the value of the column "FirstName" starts with an "a"?

SELECT * FROM Persons WHERE FirstName LIKE 'a%';

With SQL, how can you return the number of records in the "Persons" table?

SELECT COUNT(*) FROM PERSONS

What SQL statement is used to extract data from a database?

Select

How should you reference your DAO in your source code? interface StudentDAO {...} class JdbcStudentDAO implements StudentDAO {...}

StudentDAO dao = new JdbcStudentDAO();

(T or F) A statement has no innate protection against SQL injection

True

(T or F) Data Definition Language statements are used to define database structure or schema

True

(T or F) Every db needs its own driver, to translate JDBC commands into something the db can understand

True

(T or F) The DAO pattern helps decouple your application's business layer from its data access layer

True

The INNER JOIN is used in order to return all rows and selected columns which satisfy a certain condition

True

Transaction Control Statements manage changes made by DML statements

True

Which of the following is NOT a type of SQL constraint? a. UNIQUE b. FOREIGN KEY c. PRIMARY KEY d. ALTERNATE KEY

d. ALTERNATE KEY