IT Certification exam information exchange, brain dumps discussions sharing.
You are not logged in. Please login or register.
Share Test → Oracle Certifications → 1z0-083 topic 1 question 110
Which three are true about a whole database backup? (Choose three.)
A.
It can consist of either backup sets or image copies.
B.
It is the only possible backup type for a database in NOARCHIVELOG mode.
C.
It can be consistent.
D.
It can be created only by using RMAN.
E.
It can be inconsistent.
F.
It always includes all data files, the current control file, the server parameter file, and archived redo logs.
A, C, E
Regarding B : If the database is in noarchivelog mode valid backups are:
1. whole consistent backup
2. incremental consistent backup
Alternative F is wrong due to the terms "always" and "archived redo logs". The database in non-archive mode does not need the redo logs backup due to the need for the database to be in mount mode, consequently the database is consistent.
https://docs.oracle.com/en/database/oracle/oracle-database/19/admqs/performing-backup-and-recovery.html#GUID-E6AB87FC-DE6E-433C-AB61-F2055B6CC547
While backing up a database that is closed, you need not back up the archived log files because the database is in a consistent state at the time of backup. Therefore, no media recovery is required if you restore the database from this backup.
F- wrong. redo log missing
Perform a Whole Database Backup
You can use RMAN to perform a whole backup of your database. A whole backup includes the complete contents of all data files of the database, plus the control file, archived redo log files, and server parameter file.
F:
a whole backup can be closed (datafiles, controlfile) or open (datafile,s controlfile, archived redologs).. so "always" is wrong
I think ACE because database may not generate archived redo logs
what is wrong with F?
Question asks abot whole backup.
Because "the server parameter file" is not a database file, only a "configuration file".
"A whole backup includes the complete contents of all data files of the database, plus the control file, archived redo log files, and server parameter file. You can perform a complete recovery with the files from a whole backup."
https://docs.oracle.com/en/database/oracle/oracle-database/tutorial-perf-back/index.html?opt-release-19c
The problem could be with option F is, the word "Always" and "archive redo logs". This can be true only when we have taken whole database backup using the command "BACKUP DATABASE PLUS ARCHIVELOG;"
So if you check the above-mentioned link, the Whole Database Backup is considered when using the command "BACKUP DATABASE PLUS ARCHIVELOG;" therefore Answer should be A,C,F
I say ACE.
Agree with Aldrid - BCE.
B because in case case of NOARCHIVELOG you have to CLOSE the DB (for RMAN open MOUNT) and then you have to take backup of WHOLE database.
... and again Aldrid was right :-)
To reduce backup sizes for NOARCHIVELOG databases. Instead of making a whole database backup every time, you can make incremental backups.
so ACE
BCE
https://docs.oracle.com/cd/B10501_01/server.920/a96519/backup.htm#1004644
You can backup offline tablespace in noarchivemode... but question about database backup.. not tablespace... so you can do only whole DB backup in noarchive mode.
I don't understand, your argument seem conflict. Question is about whole database backup, not limited to only database backup.
If it can be inconsistent (option E), then it has to be done with the Database open and that is only possible in ARCHIVELOG mode, therefore option B is False.
correct answers ACE.
Change to ACE
https://docs.oracle.com/cd/B19306_01/backup.102/b14192/bkup004.htm
It is possible to make Incremental Backup In NOARCHIVELOG
I think ACE
Share Test → Oracle Certifications → 1z0-083 topic 1 question 110
Note: This forum is a platform for users to share insights and discuss exam-related topics. We do not provide authentic exam questions or answers. The content here is contributed by community members and is meant for collaborative learning and discussion purposes only. Users are encouraged to refer to official sources for accurate exam materials.