Initiate the alter session truncate trace to integer

Info iconThis preview shows page 1. Sign up to view the full content.

View Full Document Right Arrow Icon
This is the end of the preview. Sign up to access the rest of the document.

Unformatted text preview: ON TRUNCATE TRACE TO integer K|M command D. Initiate the ALTER SYSTEM SET MAX_DUMP_FILE_SIZE=integer command Answer: B, D Explanation: Answers B and D are correct. You can control the size of the user trace files by settint the MAX_DUMP_FILE_SIZE in the initSID.ora file or by changing it using ALTER SYSTEM SET MAX_DUMP_FILE_SIZE=integer command. Incorrect Answers: A: There is no MAX_DUMP_FILE parameter in the initSID.ora file. C: There is no ALTER SESSION TRUNCATE TRACE TO integer K|M command. Oracle 8, DBA Certification Exam Guide, Jason S. Couchman, p. 279-281 Chapter 6: basics of the Oracle Database Architecture QUESTION 83: What is the primary function of the redo logs? A. To provide read consistency. B. To record all changes made to data. C. To roll back uncommitted transactions. D. To update datafiles of uncommitted transactions. Answer: B Explanation: Answer B is correct. The redo logs are used to record all changes made to data. Each user process that makes a change to a table must write a small record, called a redo log entry, that identifies the change that was made. Incorrect Answers: A: Ro...
View Full Document

This document was uploaded on 03/08/2014.

Ask a homework question - tutors are online