Exam 15: Databases

What SQL operator can be used to perform a search for a substring?

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

A qualified column name takes the form

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

Which term refers to undoing changes to a database?

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

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

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

Which Statement interface method should be used to execute a SELECT statement?

Which type of SQL statement is used to retrieve the rows from a table?

What will happen if you try to store duplicate data in a primary key column?

What is the default concurrency level of a ResultSet object?

Of the following, which is the not-equal-to operator in SQL?

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

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

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

Although SQL is a language, you don't use it to write applications.

SQL statements that are stored in the DBMS are called resident queries.

In SQL, which statement is used to delete a table from a database?

Which of the following can be used as a wildcard to represent a single character in SQL?