1. What type of database utility performs a logical backup?
A. Export
B. Import
C. Cold backup
D. Hot backup
Answer: A
The Export utility performs the logical backup of the Oracle database.
Chapter: 14
2. What type of database utility reads the dump file into the database?
A. Export
B. Import
C. SQL*Loader
D. Forms
Answer: B
The Import utility is responsible for reading in the dump file.
Chapter: 14
3. What is the default dump file named?
A. export.dmp
B. expdat.dmp
C. expdata.dmp
D. export_data.dmp
Answer: B
The expdat.dmp is the default dump filename.
Chapter: 14
4. Review the following export command and determine the incorrect syntax.
exp
users=ar/trar2
conventional=false
tables=ra_customer_deductions
A. The first line is incorrect.
B. The second line is incorrect.
C. The third line is incorrect.
D. The fourth line is incorrect.
Answer: C
Conventional path export is the default. The line conventional=false is invalid syntax.
Chapter: 14
5. What types of backup are required to use TSPITR? (Choose all that apply.)
A. Logical
B. Physical
C. Import
D. Export
Answer: A, B, D
Both logical and physical database backups are performed with the TSPITR, and exports are logical backups. Import is not a backup; it is a recovery utility in this context.
Chapter: 14
6. What is the name of the parameter that reads the parameter file?
A. PARAMETER FILE
B. PARFILE
C. PARAFILE
D. PAR-FILE
Answer: B
The PARFILE parameter is the name of the parameter that specifies the parameter file.
Chapter: 14
7. What is the name of the other database called when you are using TSPITR?
A. Secondary database
B. Recovery database
C. Cloned database
D. Backup database
Answer: C
The cloned database is the other database that is recovered when you are using TSPITR.
Chapter: 14
8. What is the name of the parameter that is used specifically for TSPITR?
A. DATABASE
B. TRANSPORT_TABLESPACE
C. CONTROL
D. COMPRESS
Answer: B
The TRANSPORT_TABLESPACE parameter is used specifically for TSPITR. It is used to identify the tablespace that needs to be recovered.
Chapter: 14
9. Which export type is the fastest?
A. Complete
B. Cumulative
C. Direct-path
D. Conventional-path
Answer: C
A direct-path export is the fastest. Complete and cumulative exports are data-volume dependent.
Chapter: 14
10. What is the complex recovery method that uses the Export and Import utilities designed for large database objects?
A. Full Export
B. Full=Y
C. TPSTIR
D. TSPITR
Answer: D
The tablespace point-in-time recovery (TSPITR) is an Export and Import recovery method that is designed for large database objects.
Chapter: 14
11. What is the export command that can be used in conjunction with database reorganization to improve performance?
A. COMPRESS_EXTENT=Y
B. COMPRESS_EXT=Y
C. COMPRESS=Y
D. COMPEXT=Y
Answer: C
The COMPRESS=Y command can be used to compress extents in a table when a table or database is reorganized for performance reasons.
Chapter: 14
12. Which of the following is a true statement about the Export and Import utilities?
A. They cannot be used to upgrade a database.
B. They can be used to upgrade a database.
C. Only the Export utility can be used to upgrade the database.
D. Only the Import utility can be used to upgrade the database.
Answer: B
When used together, both the Export and Import utilities can be used to upgrade databases to new versions.
Chapter: 14
13. Which of the following is a correct statement about how you would use the Export utility on a table without using any export keyword options?
A. The Export utility loads data into a database.
B. The Import utility extracts data from a database.
C. The Export utility performs a full SELECT of a table and then dumps the data into a binary file.
D. The Export utility performs a full SELECT of a table and then dumps the data into an ASCII file.
Answer: C
The Export utility performs a full SELECT of a table and then dumps it to the export.dmp file, which is in binary format.
Chapter: 14
14. Which of the following export keyword options selects a subset of a table?
A. SUBSET
B. SELECT
C. WHERE
D. QUERY
Answer: D
The QUERY keyword makes the Export utility perform a filtered SELECT of a table so that the complete table is not exported.
Chapter: 14
15. Which of the following export keyword options performs a complete database export?
A. ALL=Y
B. COMPLETE=Y
C. TOTAL=Y
D. FULL=Y
Answer: D
The FULL=Y keyword option causes the export to perform a complete database export including all objects and tablespaces.
Chapter: 14
A. Export
B. Import
C. Cold backup
D. Hot backup
Answer: A
The Export utility performs the logical backup of the Oracle database.
Chapter: 14
2. What type of database utility reads the dump file into the database?
A. Export
B. Import
C. SQL*Loader
D. Forms
Answer: B
The Import utility is responsible for reading in the dump file.
Chapter: 14
3. What is the default dump file named?
A. export.dmp
B. expdat.dmp
C. expdata.dmp
D. export_data.dmp
Answer: B
The expdat.dmp is the default dump filename.
Chapter: 14
4. Review the following export command and determine the incorrect syntax.
exp
users=ar/trar2
conventional=false
tables=ra_customer_deductions
A. The first line is incorrect.
B. The second line is incorrect.
C. The third line is incorrect.
D. The fourth line is incorrect.
Answer: C
Conventional path export is the default. The line conventional=false is invalid syntax.
Chapter: 14
5. What types of backup are required to use TSPITR? (Choose all that apply.)
A. Logical
B. Physical
C. Import
D. Export
Answer: A, B, D
Both logical and physical database backups are performed with the TSPITR, and exports are logical backups. Import is not a backup; it is a recovery utility in this context.
Chapter: 14
6. What is the name of the parameter that reads the parameter file?
A. PARAMETER FILE
B. PARFILE
C. PARAFILE
D. PAR-FILE
Answer: B
The PARFILE parameter is the name of the parameter that specifies the parameter file.
Chapter: 14
7. What is the name of the other database called when you are using TSPITR?
A. Secondary database
B. Recovery database
C. Cloned database
D. Backup database
Answer: C
The cloned database is the other database that is recovered when you are using TSPITR.
Chapter: 14
8. What is the name of the parameter that is used specifically for TSPITR?
A. DATABASE
B. TRANSPORT_TABLESPACE
C. CONTROL
D. COMPRESS
Answer: B
The TRANSPORT_TABLESPACE parameter is used specifically for TSPITR. It is used to identify the tablespace that needs to be recovered.
Chapter: 14
9. Which export type is the fastest?
A. Complete
B. Cumulative
C. Direct-path
D. Conventional-path
Answer: C
A direct-path export is the fastest. Complete and cumulative exports are data-volume dependent.
Chapter: 14
10. What is the complex recovery method that uses the Export and Import utilities designed for large database objects?
A. Full Export
B. Full=Y
C. TPSTIR
D. TSPITR
Answer: D
The tablespace point-in-time recovery (TSPITR) is an Export and Import recovery method that is designed for large database objects.
Chapter: 14
11. What is the export command that can be used in conjunction with database reorganization to improve performance?
A. COMPRESS_EXTENT=Y
B. COMPRESS_EXT=Y
C. COMPRESS=Y
D. COMPEXT=Y
Answer: C
The COMPRESS=Y command can be used to compress extents in a table when a table or database is reorganized for performance reasons.
Chapter: 14
12. Which of the following is a true statement about the Export and Import utilities?
A. They cannot be used to upgrade a database.
B. They can be used to upgrade a database.
C. Only the Export utility can be used to upgrade the database.
D. Only the Import utility can be used to upgrade the database.
Answer: B
When used together, both the Export and Import utilities can be used to upgrade databases to new versions.
Chapter: 14
13. Which of the following is a correct statement about how you would use the Export utility on a table without using any export keyword options?
A. The Export utility loads data into a database.
B. The Import utility extracts data from a database.
C. The Export utility performs a full SELECT of a table and then dumps the data into a binary file.
D. The Export utility performs a full SELECT of a table and then dumps the data into an ASCII file.
Answer: C
The Export utility performs a full SELECT of a table and then dumps it to the export.dmp file, which is in binary format.
Chapter: 14
14. Which of the following export keyword options selects a subset of a table?
A. SUBSET
B. SELECT
C. WHERE
D. QUERY
Answer: D
The QUERY keyword makes the Export utility perform a filtered SELECT of a table so that the complete table is not exported.
Chapter: 14
15. Which of the following export keyword options performs a complete database export?
A. ALL=Y
B. COMPLETE=Y
C. TOTAL=Y
D. FULL=Y
Answer: D
The FULL=Y keyword option causes the export to perform a complete database export including all objects and tablespaces.
Chapter: 14
