Q 1. Fill in the blanks in order. Multiplexing refers to the act of creating multiple redo log _______ for each redo log ________.
a. archives, group
b. groups, member
c. members, group
d. groups, group
Q 2. Which of the following data dictionary views allow us to look at redo logs from a group perspective?
a. v$log
b. v$logfile
c. v$logfile_group
d. v$log_group
Q 3. Which of the following commands allows the DBA to manually switch from the current redo log group to the next redo log group in the sequence?
a. alter system switch archivelog;
b. alter system switch logfile sequence;
c. alter system switch to next log sequence;
d. alter system switch logfile;
Q 4. Following are the steps needed to enable ARCHIVELOG mode. Place them in their proper sequence.
Open the database
Enable archiving using the
alter database archivelogcommandShutdown the database
Start the database into the
MOUNTstate4, 2, 3, 1
1, 4, 2, 3
3, 4, 2, 1
1, 2, 4, 3
Q 5. We want to configure our Companylink database...