フリー問題

問題文

The product ledger of the retailer sits on an IBM Db2 database. The lead has to give the two registry variables the values that the tuning notes call for, and to recognize the ending of the name that the table of match keys carries. Which pair completes the sentence below correctly?

選択肢

1. In an IBM Db2 environment the registry variable that steers the optimizer away from nested loop joins is set to NO and the variable that turns subqueries into anti-joins is set to YES, and the table of match keys of a base object is the one whose name ends in _STRP.
2. In an IBM Db2 environment the registry variable that steers the optimizer away from nested loop joins is set to NO and the variable that turns subqueries into anti-joins is set to YES, and the table of match keys of a base object is the one whose name ends in _SRTP.
3. In an IBM Db2 environment the registry variable that steers the optimizer away from nested loop joins is set to YES and the variable that turns subqueries into anti-joins is set to NO, and the table of match keys of a base object is the one whose name ends in _SRTP.
4. In an IBM Db2 environment the registry variable that steers the optimizer away from nested loop joins is set to YES and the variable that turns subqueries into anti-joins is set to NO, and the table of match keys of a base object is the one whose name ends in _STRP.