QUESTION 1

Before you can use a new RDBMS, you must complete two tasks; create the database structure and create the tables.

True

False

2 points

QUESTION 2

Match the following terms with the appropriate commands.

- A. B. C. D.	PK
- A. B. C. D.	VARCHAR
- A. B. C. D.	CHAR
- A. B. C. D.	Number

A.	Numeric data
B.	Primary Key
C.	Fixed-length character data
D.	Variable-length character data

2 points

QUESTION 3

The GROUP BY clause can be used in place of a JOIN clause in a SQL query?

True

False

2 points

QUESTION 4

The WHERE clause applies to columns and expressions for individual rows.

True

False

2 points

QUESTION 5

The following query is written correctly?

Select Code, Name, Cost

From Inventory

Group By Code

Having (SUM(60 * 60) > 500)

Order By (SUM(60 * 60) > 500) ASC;

Hint: This will aggregate the results.

True

False

2 points

QUESTION 6

Authentication is the process the DBMS uses to verify registered users accessing the database.

True

False

2 points

QUESTION 7

The _____ constrain ensures that a column does NOT accept NULLS.

		NOT NULL
		NULL
		ZERO
		None of the above

2 points

QUESTION 8

The _____ constraint is used to validate data when an attribute value is entered.

		LOOK
		CHECK
		LOCATE
		FIND

2 points

QUESTION 9

Is this query correct?

Select Name

From Customers

Where LastName = 'Jones'

True

False

2 points

QUESTION 10

A foreign key attribute in one table must have values that match the _____ in another table.

		Secondary Key
		Primary Key
		Main Key
		None of the above