Advanced SQL

Which API is used to access a database from Java?

Why should you always use prepared statements for user input?

By default in JDBC, each SQL statement is:

`group by rollup(item_name, color, size)` produces how many groupings?

How is a stored procedure invoked?

Which is TRUE about triggers versus stored procedures?

`for each statement` in a trigger means the action runs:

A recursive query stops when:

Which ranking function does NOT leave gaps in the ranks?

`group by cube(a, b, c)` produces how many groupings?

ODBC works with C, C++, C#, and Visual Basic.

You should build queries by concatenating user input as strings.

setAutoCommit(false) lets you manage transactions manually with commit() and rollback().

Embedded SQL references host-language variables with a colon prefix (e.g., :name).

Table-valued functions can return a relation as a result.

External language routines carry no security or corruption risk.

A trigger can be committed or rolled back inside the trigger body.

Two triggers updating each other's tables can cause an infinite loop.

A ranking result is automatically sorted without an extra order by clause.

MOLAP stores data cubes using multidimensional arrays in memory.

Match each access method with its description.

Match each routine concept.

Match each trigger concept.

Match each OLAP operation.

Match each aggregation/implementation term.