Click on the Exhibit button to show an INVOKE of the table CUSTOMER and a partial FILEINFO
of the same table. The SQL statement ‘UPDATE SALES.CUSTOMER SET CREDIT = “A1”
WHERE CUSTNUM IN (21, 3333, 324)’ _______.

Which joins are supported by NonStop SQL?

If a table is heavily accessed, a bottleneck can ocur. What can be done to prevent this from
happening? Select TWO.

Which SQL object can reside on a non audited volume?

A new column is added to a table with similarity check enabled.. Which compiler options can
prevent recompilation? Select TWO.

The SQL compiler option REGISTERONLY _______.

The SQL catalog version number is used to _______.

The “CONTROL EXECUTOR PARALLEL EXECUTION ON” allows the optimizer to apply parallel
execution _______.

$DATA.A.B is an audited SQL table. The disk process $DATA is using default configuration
values. How many locks can a given transaction hold against the SQL table?

When should you perform UPDATE STATISTICS on a table?