RelationalDBDesign RelationalDBDesign


Database Backup   «Prev  Next»

Export Utility - Quiz

Each question is worth one point. Select the best answer or answers for each question.

1. What is the name of the table that contains the last valid export?
Please select the best answer.
  A. SYS.INCEXP
  B. SYS.INCFIL
  C. SYS.INCVID
  D. SYS.INCVEX

2. Which of the following is used with the inctype parameter and indicates a full export of all the rows in a database?
Please select all the correct answers.
  A. complete
  B. partial
  C. cumulative
  D. incomplete

3. Your client's DEPT table has five rows. A new row is inserted into this table. When performing a successful export with inctype=incremental and no value specified for the record parameter, which statement below is true?
Please select the best answer.
  A. The DEPT table is exported with one row and the value in SYS.INCVID is incremented.
  B. The DEPT table is exported with six rows and the value in SYS.INCVID is incremented.
  C. The DEPT table is exported with one row and the value in SYS.INCVID is not incremented.
  D. The DEPT table is exported with six rows and the value in SYS.INCVID is not incremented.

4. If you want the SYS tables INCEXP, INCFIL. and INCVID to reflect your exports, which statement(s) below will accomplish this?
Please select all the correct answers.
  A. exp80 system/manager FULL=Y
  B. exp80 system/manager FULL=Y INCTYPE=INCREMENTAL RECORD=Y
  C. exp80 system/manager FULL=Y RECORD=Y
  D. The parameter RECORD=YES must be set in the init.ora file.