Exam 15: Databases

To sort the results of a SQL query, you can use the __________ clause.

What SQL operator can be used to disqualify search criteria in a WHERE clause?

Which statement is used in SQL to insert a new row into a table?

What does JDBC stand for?

A result set is an object that is somewhat similar to a collection and it

In SQL, which statement can be used to create a database table?

In SQL, which statement is used to delete one or more rows from a table?

No two rows in a table can have the same value in the primary key column.

SQL stands for

A column in one table that references a primary key in another table is known as a

The data that is stored in a row of a database is divided into

In SQL the REFERENCES qualifier ensures referential integrity between tables.

What term refers to data that describes other data?

What string lists the protocol rhat should be used to access a database, the name of the database, and potentially other items?

The term commit refers to undoing changes in a database.

Which Statement interface method should be used to execute an INSERT statement?

The columns in a table are assigned SQL data types.

In SQL, which statement is used to change the contents of an existing row in a table?

SQL does not provide functions for performing calculations.

The standard lanuage for working with database management systems is __________.