READ Free Dumps For Oracle- 1z0-023
| Question ID 8785 | Which command does a DBA use to list the current status of archiving?
|
| Option A | ARCHIVE LOG LIST;
|
| Option B | FROM ARCHIVE LOGS;
|
| Option C | SELECT* FROM V$THREAD;
|
| Option D | SELECT* FROM ARCHIVE_ LOG_LIST;
|
| Correct Answer | A |
Explanation Explanation/Reference: Explanation: Answer A is correct. Command ARCHIVE LOG LIST is used to list the current status of archiving. Incorrect Answers: B: There is no command FROM ARCHIVE LOGS in Oracle. C: This statement will show information about redo logs, not about status of archiving. D: There is no ARCHIVE_LOG_LIST view in Oracle. Oracle 8, DBA Certification Exam Guide, Jason S. Couchman, p. 325-327 Chapter 7: Managing the Physical Database Structure
| Question ID 8786 | A DBA enters a command: ALTER DATABASE ADD LOGFILE ( '/u01/oracle/dba/log3a.rdo' 'u02/oracle/dba/log3a.rdo') SIZE 1M; What does Oracle do?
|
| Option A | Adds two online redo logs to the current group.
|
| Option B | Creates a new redo log group with two members.
|
| Option C | Adds a redo log to group 1 and a redo log to group 2.
|
| Option D | Creates two new redo log groups with one member each.
|
| Correct Answer | B |
Explanation Explanation/Reference: Explanation: Answer B is correct. This statement will create a new redo log group with two members. Incorrect Answers: A: This command will not add online redo logs to the current group. C: This statement does not add a redo log member to group 1 and a redo log member to group 2. D: This statement does not create two new redo log groups. Oracle 8, DBA Certification Exam Guide, Jason S. Couchman, p. 330-333 Chapter 7: Managing the Physical Database Structure