WGU D330 OA QUESTIONS AND ANSWERS
1. How many tablespaces can a data file belong to?: One
2. How many data files can a tablespace have?: Multiple
3. What are segments?: SQL tables
4. What are extents?: Multiple consecutive data blocks
5. What are the 3 main files that store data to disk?: Control files, Data files, and redo log files.
6. What are the additional files that are not part of the database?: Password files,
parameter file, and any archived redo log file
7. What's ADR?: Automatic Diagnostic Repository. Basically, an advanced fault diagnostic infrastructure.
8. What is an alert log used for?: tracks events like startup, shutdown, tablespace creation, critical events, and
errors
9. What is an alert log location?: Set by DIAGNOSTIC_DEST
10. What is Data Guard?: Rolling database upgrade. Upgrades primary and standby databases one at a time.
11. What's export/import?: Basically copies older databases, transforms, and imports to new databases.
12. What's Oracle's primary tool for migrating old versions of Oracle databases
to the newest version?: Export/Import
13. What's both used for logical exports/imports, and is the newest version of
import/export?: Data pump
14. Data pump vs Transportable tablespaces.: One copies the old database and then inputs it into
the new database. The other is used for a large database and moves the entire database.
15. What is SQL Loader used for?: Loads external data into databases. Basically, import data from
non-Oracle sources
16. What requires a control file for fixed-width imports: SQL Loader
17. Which parameter disables conventional path loading when using
1/
11
, SQL*Loader?: DIRECT
18. What is the use of RMAN?: Data migration, backup, recovery from corrupted databases, and correcting
endianness.
19. What is the primary tool for backup and recovery?: RMAN
20. What's RMAN incremental backup level 1 used for?: Incremental backups, basically only
backs up blocks changed since last full backup
21. What's RMAN incremental backup level 0 used for?: Full backup
22. What is a post-upgrade validation that recomplies invalid objects after up-
grade?: utlrp.sql
2/
11
1. How many tablespaces can a data file belong to?: One
2. How many data files can a tablespace have?: Multiple
3. What are segments?: SQL tables
4. What are extents?: Multiple consecutive data blocks
5. What are the 3 main files that store data to disk?: Control files, Data files, and redo log files.
6. What are the additional files that are not part of the database?: Password files,
parameter file, and any archived redo log file
7. What's ADR?: Automatic Diagnostic Repository. Basically, an advanced fault diagnostic infrastructure.
8. What is an alert log used for?: tracks events like startup, shutdown, tablespace creation, critical events, and
errors
9. What is an alert log location?: Set by DIAGNOSTIC_DEST
10. What is Data Guard?: Rolling database upgrade. Upgrades primary and standby databases one at a time.
11. What's export/import?: Basically copies older databases, transforms, and imports to new databases.
12. What's Oracle's primary tool for migrating old versions of Oracle databases
to the newest version?: Export/Import
13. What's both used for logical exports/imports, and is the newest version of
import/export?: Data pump
14. Data pump vs Transportable tablespaces.: One copies the old database and then inputs it into
the new database. The other is used for a large database and moves the entire database.
15. What is SQL Loader used for?: Loads external data into databases. Basically, import data from
non-Oracle sources
16. What requires a control file for fixed-width imports: SQL Loader
17. Which parameter disables conventional path loading when using
1/
11
, SQL*Loader?: DIRECT
18. What is the use of RMAN?: Data migration, backup, recovery from corrupted databases, and correcting
endianness.
19. What is the primary tool for backup and recovery?: RMAN
20. What's RMAN incremental backup level 1 used for?: Incremental backups, basically only
backs up blocks changed since last full backup
21. What's RMAN incremental backup level 0 used for?: Full backup
22. What is a post-upgrade validation that recomplies invalid objects after up-
grade?: utlrp.sql
2/
11
