1Z0-032 · Question #102
You have joined an organization as a DBA. While examining one of the databases you notice the Oracle 1Z0-032 Exam following settings: LOG_ARCHIVE_START = FALSE LOG_ARCHIVE_MAX_PROCESS = 4 What do…
The correct answer is A. Manual archiving is enabled and no archiver processes are started. See the full explanation below for the reasoning.
Question
You have joined an organization as a DBA. While examining one of the databases you notice the Oracle 1Z0-032 Exam following settings:
LOG_ARCHIVE_START = FALSE LOG_ARCHIVE_MAX_PROCESS = 4 What do you understand from this settings?
Options
- AManual archiving is enabled and no archiver processes are started.
- BArchiving is not enabled, so the database is in NOARCHIVELOG mode.
- CAutomatic archiving is enabled and four archiver processes will be started on demand.
- DManual archiving is enabled and four archiver processes will be started for manual archiving.
How the community answered
(24 responses)- A79% (19)
- B13% (3)
- C4% (1)
- D4% (1)
Community Discussion
6
Hiroshi T.Jun 26, 2026The correct answer is A. LOG_ARCHIVE_START = FALSE tells Oracle not to automatically spawn ARCn background processes at instance startup, which means no archiver processes are running. The database can still be placed in ARCHIVELOG mode and a DBA can issue ALTER SYSTEM ARCHIVE LOG manually, so archiving capability exists but it is not automated. LOG_ARCHIVE_MAX_PROCESS = 4 simply caps the number of archiver processes at four, but that ceiling is irrelevant here since none are started to begin with. Option B is wrong because LOG_ARCHIVE_START has nothing to do with whether the database is in ARCHIVELOG or NOARCHIVELOG mode, those are separate and distinct settings controlled via ALTER DATABASE.
Luis F.Jun 26, 2026Got this exact one on my exam and almost picked B, but A is right. LOG_ARCHIVE_START=FALSE means manual archiving, zero ARCn processes auto-start. The LOG_ARCHIVE_MAX_PROCESS=4 just sets the ceiling, not a trigger. Saved myself by remembering my instructor saying "FALSE means hands-on, not hands-off."
Bao N.Jun 26, 2026LOG_ARCHIVE_MAX_PROCESS=4 spins up four archivers ready for manual archiving, D all day.
Orla P.Jun 29, 2026Bao, the key word there is automatic, not manual. LOG_ARCHIVE_MAX_PROCESS=4 controls how many ARCn background processes Oracle can spin up for automatic archiving, which points straight to A.
Orla P.Jun 26, 2026LOG_ARCHIVE_START=FALSE means manual only, so A is right, ignore that D distractor.
Hiroshi T.Jun 27, 2026Correct on A, but worth flagging for the exam that LOG_ARCHIVE_START was deprecated in Oracle Database 10g Release 1 and desupported in 11g, so if the question stem specifies a version at 10g or later, automatic archiving behavior is governed by ARCHIVELOG mode itself, not that parameter, per the Oracle Database Reference documentation for whichever version the exam blueprint targets.