Database and JDBC

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

• True

• False

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

• True

• False

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

• True

• False

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

• text files

• binary files

• a database management system

• Java DB

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

• SQL

• BASIC

• ADA

• COBOL

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

• back to the application

• along the encrypted data path

• to the unified data component

• back to the Web server

SQL stands for __________.

• structured query language

• standard equivalent language

• semiconductor qualified language

• simple equation library

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

• sections

• tables

• bytes

• columns

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

• The column will be duplicated.

• An error will occur.

• The duplicate data will have concurrency issues.

• The primary key column will not display the duplicate data.

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

• contains the result of a SQL statement

• allows the program to execute a SQL statement

• predicts the outcome of a SQL statement

• provides the rules for how a SQL statement should be executed