Exam 16: Databases

In a transaction, all updates to the database must be successfully executed.

SQL does not provide functions for performing calculations.

The columns in a table are assigned SQL data types.

Systems designers commonly use UML diagrams to show the relationships between database tables.

Which of the following do most developers prefer to use when developing applications that work with an intensive amount of data?

Which of the following is the Statement interface method that should be used to execute a SELECT statement?

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

In SQL the REFERENCES qualifier ensures referential integrity between tables.

In an entity relationship diagram, the primary key is denoted with __________.

In SQL, the __________ statement can be used to create a database table.

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

Of the following, which shows how a single quote (') is represented as part of a string in SQL?

The __________ type of SQL statement is used to retrieve the rows from a table.

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

Of the following column names, which one is most likely a primary key column?

In SQL the equal operator is ==, the same as Java.

What does JDBC stand for?

The __________ statement is used in SQL to insert a new row into a table,

The DBMS works directly with the data and sends the results of operations __________.

SQL stands for __________.