1Z0-032 · Question #108
You want to maintain the logical backup of all the application tables at regular intervals. Which option would you use to achieve this?
The correct answer is C. Oracle Export utility. See the full explanation below for the reasoning.
Question
You want to maintain the logical backup of all the application tables at regular intervals. Which option would you use to achieve this?
Options
- AWallet Manager
- BSQL *Loader utility
- COracle Export utility
- DOracle Directory Manager
How the community answered
(51 responses)- A8% (4)
- B16% (8)
- C73% (37)
- D4% (2)
Community Discussion
12
Carlos M.Jun 27, 2026C is your answer. Oracle Export utility (exp/expdp) is specifically designed for logical backups, letting you dump table data and structure to a file on a schedule, which is exactly what the question describes. SQL*Loader imports data in, it does not back it up, and Wallet Manager and Directory Manager have nothing to do with backups.
Prof. SaraApr 24, 2026The answer is C, the Oracle Export utility, because Export (exp) is specifically designed to produce logical backups of database objects such as tables, schemas, or an entire database into a binary dump file that can be scheduled and repeated at regular intervals. The other options are distractors: SQL*Loader imports data into Oracle (it does not back up), Wallet Manager handles security credentials, and Oracle Directory Manager administers LDAP directory services, none of which have anything to do with logical backup operations.
Ingrid P.May 4, 2026Oracle Export utility is right, it dumps logical backups of selected tables on a schedule.
Dragan P.Jun 27, 2026Took 1Z0-032 back when exp.exe was still the workhorse and I almost second-guessed myself toward SQL*Loader out of exam-nerves, but the moment I saw "logical backup at regular intervals" I circled C without blinking, because Export has been the answer to that exact phrasing since Oracle 9i and nothing in that list, not Wallet Manager, not Directory Manager, comes anywhere close to producing a transportable dump of application table data on a schedule.
Viktor S.Jun 26, 2026The question is a bit loose with "logical backup" but that phrase is the actual key, so pay attention to it. A logical backup means you are exporting the data and structure as a transportable, human-readable artifact, not a block-level copy of datafiles, and the Oracle Export utility (exp, or Data Pump Export in newer versions) is exactly what does that job. SQL*Loader is a distractor that trips people up because it also deals with data movement, but it only goes one direction, inbound, it loads data into the database, it does not extract it. Wallet Manager handles encryption key and credential management, Directory Manager is an LDAP directory tool, neither has anything to do with extracting table data. The answer is C, and if you understand that logical versus physical backup distinction you will never get confused by this category of question on the job either.
Dragan P.Jun 28, 2026Solid breakdown, but "human-readable" is going to get you burned on a follow-up question, because both exp and expdp write proprietary binary dump files, the logical distinction is about extracting data as objects and rows rather than copying datafile blocks, not about whether you can open the output in Notepad.
Toby R.Apr 2, 2026The Oracle Export utility (exp/expdp) is exactly right for this, it dumps logical backups of selected tables to binary dump files you can schedule and restore from anytime. SQL*Loader is the opposite direction, it loads data in, and Wallet Manager and Directory Manager have nothing to do with backups.
Yusuf A.Apr 5, 2026Toby nailed it, though worth adding that expdp is the newer Data Pump version and gives you way better performance and parallelism than the older exp, so if your environment is 10g or later you really want to reach for expdp first.
Lena V.Apr 11, 2026The distractor here is B, since SQL*Loader handles imports, not exports, and people mix that up under pressure. For regular logical backups of application tables, Oracle Export utility is the only tool that actually dumps table data and definitions to a transportable binary file.
Yusuf A.Apr 13, 2026Lena nailed the SQL*Loader mixup, though worth adding that exp/expdp both produce logical backups, so the choice between the classic Export utility and Data Pump Export usually comes down to whether the exam is testing pre-10g knowledge or the newer architecture.
Yusuf A.Apr 30, 2026When I sat for that section I almost second-guessed myself and circled SQL*Loader, but then I remembered my senior saying "Loader is for getting data IN, Export is for getting data OUT and keeping it safe," and that clicked right away. The Oracle Export utility is the one built for logical backups of tables at scheduled intervals, so C is your pick there.
Ingrid P.May 3, 2026That mnemonic holds up well, though it is worth pinning down that "Export" in modern Oracle contexts usually means Data Pump Export (expdp) rather than the legacy exp utility, and the exam will sometimes test whether you know which generation is which.