11.
Your database is in NOARCHIVELOG mode. You start to do a backup, but your users complain that they don't want you to shut down the database to perform the backup. What options are available to you?
- A.Put the database in hot backup mode and perform an online backup, including backing up the archived redo logs.
- B.Just back up the database datafiles without shutting down the database.
- C.You will have to wait until you can shut down the database to perform the backup.
- D.Mark each datafile as backup in progress, back them up individually, and then mark them as backup not in progress. No archived redo logs will need to be backed up.
- E.Only back up the datafiles that the user will not be touching. Once the user has finished what they were doing, you can shut down the database and back up the datafiles the user changed during the course of the remaining backup.
- Answer & Explanation
- Report
Answer : [C]
Explanation :
Explanation :
| You will have to wait until you can shut down the database since it's in NOARCHIVELOG mode. No other option will give you a backup that is recoverable. |
12.
When performing an online backup, what is the proper order of the following steps?
a. Issue the alter database end backup command.
b. Back up the archived redo logs.
c. Issue the alter database begin backup command.
d. Back up the database files.
e. Determine the beginning log sequence number.
f. Determine the ending log sequence number.
g. Force a log switch with the alter system switch logfile command.
b. Back up the archived redo logs.
c. Issue the alter database begin backup command.
d. Back up the database files.
e. Determine the beginning log sequence number.
f. Determine the ending log sequence number.
g. Force a log switch with the alter system switch logfile command.
- A.a, b, c, d, e, f, g
- B.c, d, a, b, e, g, f
- C.f, d, b, g, a, c, e
- D.e, c, d, a, g, f, b
- E.a, f, b, g, e, c, d
- Answer & Explanation
- Report
Answer : [D]
Explanation :
Explanation :
| The correct answer is D. First you determine the beginning log sequence number, then you issue the alter database begin backup command, then you back up the database files, and then you issue the alter database end backup command. Next you force a log switch with the alter system switch logfile command, and then you determine the ending log sequence number. Finally, you back up the archived redo logs. |
13.
You want to put a specific tablespace called MY_DATA in hot backup mode so you can back
it up. What command would you use?
- A.alter tablespace MY_DATA begin backup;
- B.alter tablespace MY_DATA start backup;
- C.alter tablespace MY_DATA backup begin;
- D.alter MY_DATA begin backup;
- E.You cannot back up individual tablespaces.
- Answer & Explanation
- Report
Answer : [A]
Explanation :
Explanation :
| The correct answer is A. The alter tablespace command is followed by the name of the tablespace and then the begin backup keyword. |
14.
You backed up the database at 8 a.m. today using an online backup. Accounting made a
large change to the underlying data between 10 a.m. and noon. Which of the following
actions would ensure that the changes could be recovered using the 8 a.m. backup?
- A.Create a manual incremental online database backup.
- B.Back up all the archived redo logs generated since the 8 a.m. backup.
- C.Create a brand-new backup after all the changes have been applied.
- D.There is no way to make the changes recoverable based on the 8 a.m. backup.
- E.Perform an online backup of the tablespace(s) that contained changed data.
- Answer & Explanation
- Report
Answer : [B]
Explanation :
Explanation :
| The most correct answer is B. This is because the question asked you what would be done using the 8 a.m. backup. |
15.
What are the different logging modes available in Oracle Database 11g? (Choose two.)
- A.NOLOG mode
- B.NOARCHIVELOG mode
- C.LOGGING mode
- D.HOTDATABASE mode
- E.ARCHIVELOG mode
- Answer & Explanation
- Report
Answer : [B,E]
Explanation :
Explanation :
| B and E are the correct answers because ARCHIVELOG and NOARCHIVELOG are the two logging modes available in Oracle Database 11g. |
|
|
||||||||||||||||||||||||||||
