16.
Which is the correct command to put the database in ARCHIVELOG mode?
- A.alter database archivelog
- B.alter system enable archivelog mode
- C.alter database enable archive
- D.alter database archivelog enable
- E.None of the above
- Answer & Explanation
- Report
Answer : [A]
Explanation :
Explanation :
| The alter database archivelog will put the database in ARCHIVELOG mode. |
17.
What is the correct order of steps to perform an online database backup?
a. alter database begin backup;
b. alter database end backup;
c. Back up the database datafiles.
d. Back up the archive log files.
e. alter system switch logfile;
b. alter database end backup;
c. Back up the database datafiles.
d. Back up the archive log files.
e. alter system switch logfile;
- A.a, b, c, d, e
- B.e, d, a, b, c
- C.a, c, b, d, e
- D.d, b, c, a, e
- E.a, c, b, e, d
- Answer & Explanation
- Report
Answer : [E]
Explanation :
Explanation :
| The correct answer is E. You first put the database in ARCHIVELOG mode with the alter database begin backup command. You then back up the database datafiles. Then take the database out of backup mode with the alter database end backup command. Issue the alter system switch logfile command and then back up the archived redo logs. |
18.
Which command will result in a trace file being created with the create controlfile
command contained in it?
- A.alter database backup controlfile;
- B.alter database backup controlfile to trace;
- C.alter database controlfile backup;
- D.Talter database controlfile backup to '/ora01/oracle/ctrl_backup.ctl';
- E.alter database begin controlfile backup;
- Answer & Explanation
- Report
Answer : [B]
Explanation :
Explanation :
| The alter database backup controlfile to trace command will create a trace file in the DIAGNOSTIC_DEST directory structure that contains your control file. |
19.
Which of the following is a valid way of putting a tablespace named DAVE_TBS into hot
backup mode?
- A.alter tablespace DAVE_TBS backup mode;
- B.alter tablespace DAVE_TBS start backup;
- C.alter tablespace DAVE_TBS begin backup;
- D.alter tablespace DAVE_TBS backup begin;
- E.alter tablespace DAVE_TBS backup;
- Answer & Explanation
- Report
Answer : [C]
Explanation :
Explanation :
| The correct command would be alter tablespace DAVE_TBS begin backup;. |
20.
Every Sunday the Unix system administrator has a job that executes a full backup of the
entire Unix system your database is on. Is this backup usable for backup and recovery of
your database?
- A.Yes, if the database is in ARCHIVELOG mode.
- B.Yes, if the database is in NOARCHIVELOG mode.
- C.No, the backup is not usable in any way.
- D.Only if the ENABLE_ONLINE_BACKUP parameter is set to TRUE.
- Answer & Explanation
- Report
Answer : [C]
Explanation :
Explanation :
| The correct answer is C. Regardless of the logging mode, the backup would not be usable since the tablespaces were not put in hot backup mode. |
|
|
||||||||||||||||||||||||||||
