READ Free Dumps For IBM- C2090-612
| Question ID 20478 | The following SQL statement is issued: SELECT col1 FROM tb1 ORDER BY col1 ASC The |
| Option A | Theencoding scheme of the table is EBCDIC. |
| Option B | The encoding scheme of the table is UNICODE. |
| Option C | This could never happen, this is an error and must be reported. |
| Option D | This is expected behavior and independent of the encoding scheme. |
| Correct Answer | B |
| Question ID 20479 | What is a consideration when specifying DATA CAPTURE CHANGES? |
| Option A | Can be specified for capturing changes to an XML object. |
| Option B | To minimize logging, specify NOT LOGGED when DATA CAPTURE CHANGES is specified. |
| Option C | REFRESH TABLE statement is not allowed with a table defined with DATA CAPTURE CHANGES. |
| Option D | You cannot turn on DATA CAPTURE CHANGES if the table space is in advisoryREORG-pending. |
| Correct Answer | D |