The StayWell accommodation database includes tables to store data about property owners and the properties themselves, which are rented out for the owners by StayWell. The columns that make up the OWNER database include _____.

a. LAST_NAME b. PROPERTY_ID c. SQR_FT d. OFFICE_NUM

2.A(n) _____ is the association between entities.

A. qualificationB. functional dependencyC. attributeD. relationship

3.A relational database _____.

A. is a collection of tablesB. contains a single relationC. is a pool of raw dataD. separates entities from their attributes

4.If the primary key for the SALES_REP table is REP_ID, then the LAST_NAME column in this table is considered a(n) _____.

A. candidate keyB. relationC. nonkey column

D. entity column

5.In one style of entity-relationship (E-R) diagram, a crow's foot is used to represent _____.

A. a tableB. the "many" side of a relationshipC. an entityD. the "one" side of a relationship

6.When MySQL Workbench is first installed, executing the SHOW DATABASES command returns _____.

A. nothing because no databases have been created yetB. the KimTay and StayWell databasesC. any databases of any type saved to the computer's disk storageD. MySQL internal databases

7.Which command represents the correct syntax for creating a database called CHAMPYS in MySQL?

A. CHAMPYS DATABASE CREATE:B. CHAMPYS CREATE DATABASE;C. USE DATABASE CHAMPYS;D. CREATE DATABASE CHAMPYS;

8.Which data type is used to store integers?

A. CHARB. DECIMALC. NUMBER

D. INT

9.Janice is adding a new row to a table, but has incomplete data for this row. She can indicate that data in a column is unknown or unavailable by entering which value?

A. a zeroB. a nullC. a void

D. a dash

10.You use the SQL command INSERT INTO followed by a table name to _____.

A. add rows to a tableB. modify a row in a tableC. modify a column in a table

D. add columns to a table

11.In MySQL, to display all the rows and columns in a table, you use _____.

A. the VIEW command followed by a semicolonB. the SELECT command followed by an asteriskC. the FROM keyword followed by an asteriskD. the SHOW command followed by a semicolon

12.A query is a question represented in a way that the DBMS can understand.

A. TrueB . False

13.A key difference between simple and compound SQL queries is that, unlike simple queries, compound queries _____.

A. contain a FROM clauseB. connect two or more conditionsC. include a WHERE clause

D. do not use the AND, OR, or NOT operators

14.Which SQL operator allows you to specify a range of values in a condition?

A. LIKEB. DISTINCTC. GROUP

D. BETWEEN

15.In SQL, the ORDER BY clause should be followed by a(n) _____.

A. sort keyB. aggregate functionC. WHERE clauseD. IN clause

16.Thomas wants to write an SQL query that determines the average monthly unit sales for each of his bakery's cupcake flavors and then returns a list of flavors that sell better than average. Which of the following should he use as a subquery in his query after the > operator?

A. SELECT FLAVOR FROM CUPCAKESB. SELECT DISTINCT (FLAVOR) FROM CUPCAKESC. SELECT AVG(UNIT_SALES) FROM CUPCAKESD. SELECT FLAVOR FROM CUPCAKES WHERE (UNIT_SALES = 'AVG')

17.When a GROUP BY clause is used in SQL, functions in the SELECT command _____.

A. are calculated for the table as a wholeB. must be moved to the GROUP BY clauseC. are calculated for each groupD. will not produce output

18.When performing an SQL query, you can join two tables together when _____.

A. you list both tables in the SELECT clauseB. they contain rows with identical values in matching columnsC. no column names are qualified in the WHERE clauseD. they contain at least one matching row

19.Data from two tables can be combined in SQL by using which operator in a subquery?

A. AND or JOINB. AVGC. BETWEEN

D. IN or EXISTS