Big Java Binder Early Objects

Insert the statement that would remove the following table from the database. CREATE TABLE Course ( Course_ID VARCHAR(11), Credits VARCHAR(4), Room_No INT(4) ) ____________________

A _____________ is a column (or set of columns) whose value uniquely specifies a table record.

A ____________ is a reference to a primary key in a linked table.

Complete the following statement, which inserts rows into the following Course table. ____________________ VALUES ('CS221', 'Data Structures', '4', 'J. Jones') Course table

In the table below, the ____ correspond(s) to the attributes of a customer in the database. Customer table

In database terminology, a column (or combination of columns) that uniquely identifies a row in a table is called a(n) ____.

Which of the following table attributes could be a unique identifier for a person?

Which of the following statements is correct?

Based on the customer table below, which of the attributes do you think represents the primary key? Customer table

Which of the following would be a good primary key for a Course table designed to hold course information for a university?

In SQL, the _____________ command is used to issue queries.

In SQL, the _____________ command is used to issue queries that do not modify the database.

The outcome of a SQL query is a ____________________.

A ____________ is a set of rows and columns that provides a "window" through which you can see some of the database data.

Based on the following table, the query that gets the names and complete mailing addresses of all customers is ____________________. Customer table

Based on the table below, the query that finds all customers who do not live in Pleasantville is _________________. Customer table

Based on the table below, the query that finds the names and zip codes of all customers is _____________________. Customer table

Based on the table below, insert the statement that queries the database for the names of customers who live in the city of Pleasantville: ______________________ Customer table

In SQL, ____ is used to test for equality.

Based on the table below, which of the following statements will return the number of customers in Michigan (MI)? Customer table