1:
| To create a new table by importing IXF data, which import mode should you use? |
A1:
| You must use the CREATE import mode to create a new table when importing IXF data. |
2:
| If you want to create a new table, what format should you use? Would you use the Load Wizard or the Import Wizard to create a new table? |
A2:
| Integrated exchange format (IXF) is used to create a new table; the DEL, ASC, and WSF formats can be used only to import data into an existing table. IXF format is the format used by database managers. Load doesn't support creating a new table; the table must exist before you can load data into it. To create a new table, use the Import utility. |
3:
| How do you export only a subset of the data in a table? |
A3:
| Click the Columns tab in the Export dialog box to specify only a subset of the columns to export. Exporting a subset of columns is supported only when using WSF or IXF formats. |
4:
| What must take place before you can save a copy of the changes when using the Load Wizard? |
A4:
| Forward recovery must be turned on to enable you to save a copy of the changes when using the Load utility. On the Copy Options page of the Load Wizard, specify that a copy of the changes be saved. |
No comments:
Post a Comment