Database Backup   «Prev  Next»

Export Import in Oracle - Quiz

Select the best answer or ansewrs for each question.

1. Which of the following are valid inctype options for an import operation?
Please select all the correct answers.
  A. inctype=complete
  B. inctype=restore
  C. inctype=system
  D. inctype=incremental

2. When performing a direct path export, which of the following will generally increase performance?
Please select all the correct answers.
  A. Setting the init.ora parameter compatible=8.0.5
  B. Setting the buffer parameter to 8192 or higher
  C. Setting the recordlength parameter to a multiple of DB_BLOCK_SIZE
  D. Setting DB_BLOCK_SIZE to be a multiple of the file system I/O block size

3. Using direct path export, tables containing which type of data will not be exported?
Please select all the correct answers.
  A. LOBs
  B. Bitmap indexes
  C. REFs
  D. Triggers