1. If you have two redo log groups with four members each, what’s the optimal nu
ID: 3866334 • Letter: 1
Question
1. If you have two redo log groups with four members each, what’s the optimal number of disks you need to provide appropriate protection on the redo log files?
A. Eight
B. Four
C. Two
D. One
E. Operating system dependent
2. When is the redo log buffer written to the redo log file?
A. A transaction changes data.
B. The redo log buffer becomes one-third full.
C. A redo log group is archived.
D. The database starts up.
3. You have two redo log groups. Each group has three members that are 150 MB in size. The members reside on the E, F, and G drives. You issue this command:
ALTER DATABASE ADD LOGFILE MEMBER ‘G:pporadataINST1 edo04.log’ SIZE 200M TO GROUP 1;
The statement will fail because:
A. All redo log groups must have the same number of members.
B. The size cannot be specified in this command.
C. You cannot add a member to a redo log group.
D. The size is incorrect.
4. What is the correct method for moving a control file (assume you use PFILE)?
A. Issue the ALTER DATABASE RENAME FILE command.
B. Shut down the database; move the control file; modify the CONTROL_FILES parameter in PFILE; and start up the database using PFILE.
C. Copy the control file to a new location; shut down the database; modify the CONTROL_FILES parameter; and start up the database.
D. Shut down the database; delete the control file; start up the database in NOMOUNT mode; issue the CREATE CONTROL FILE command; and start up the database.
5. Which statement will add a member C:pporadataINST1 edo2A.log to log file group 2?
A. ALTER DATABASE ADD LOGFILE ‘C:pporadataINST1 edo2A.log’ TO GROUP 2;
B. ALTER DATABASE ADD LOGFILE MEMBER ‘C:pporadataINST1 edo2A.log’ TO GROUP 2;
C. ALTER DATABASE ADD MEMBER ‘C:pporadataINST1 edo2A.log’ TO GROUP 2;
D. ALTER DATABASE ADD LOGFILE ‘C:pporadataINST1 edo2A.log’;
Explanation / Answer
ANSWERS:
1. If you have two redo log groups with four members each, what’s the optimal number of disks you need to provide appropriate protection on the redo log files?
A. Eight
2. When is the redo log buffer written to the redo log file?
B. The redo log buffer becomes one-third full.
3. You have two redo log groups. Each group has three members that are 150 MB in size. The members reside on the E, F, and G drives. You issue this command:
ALTER DATABASE ADD LOGFILE MEMBER ‘G:pporadataINST1 edo04.log’ SIZE 200M TO GROUP 1;
D. The size is incorrect.
4. What is the correct method for moving a control file (assume you use PFILE)?
B. Shut down the database; move the control file; modify the CONTROL_FILES parameter in PFILE; and start up the database using PFILE.
5. Which statement will add a member C:pporadataINST1 edo2A.log to log file group 2?
B. ALTER DATABASE ADD LOGFILE MEMBER ‘C:pporadataINST1 edo2A.log’ TO GROUP 2;
Related Questions
Navigate
Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.