Question: In an UPDATE statement, the SET keyword is followed by _________. A. a comma-separated list of column value-name pairs in the format value = columnName.

In an UPDATE statement, the SET keyword is followed by _________.

A. a comma-separated list of column value-name pairs in the format value = columnName.
B. a comma-separated list of column name-value pairs in the format columnName = value.
C. a semicolon-separated list of column value-name pairs in the format value = columnName.

D. a semicolon-separated list of column name-value pairs in the format columnName = value.

Which statement is false?

A. A DELETE statement removes rows from a table.
B. A DELETE statement must specify the table from which to delete.
C. A DELETE statement starts with the keyword DELETE.

D. A WHERE clause must be present in a DELETE statement.

Pattern matching in a SQL query is performed with which clause?

A. FROM.
B. WHERE.
C. SELECT.

D. LIKE.

Initially, a ResultSet cursor is positioned _________.

A before the first row.
B at the first row.
C at the last row.
D

after the last row.

JDBC 4 supports _______, so you do not need to manually load the database driver before accessing a database.

A. automatic driver downloading.
B. automatic driver creation.
C. automatic driver discovery.

D. None of the above.

Transaction processing enables a program to treat a database operation, or set of operations, as single operation. This is known as a(n) ________ or a(n) ________.

A a. atomic operation, unique operation.
B unique operation, transaction.
C atomic operation, transaction.
D None of the above.

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Databases Questions!