Incorrect answers b memory for the sga is allocated

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: ct Answers: B: Memory for the SGA is allocated when the instance was started, not with open stage. C: The Oracle password file is opened when you try to connect to Server manager to start the instance, if you use password file. Oracle 8, DBA Certification Exam Guide, Jason S. Couchman, p. 281-283 Chapter 6: Basics of the Oracle Database Architecture QUESTION 25: In which situation is it appropriate to enable the restricted session mode? A. Creating a table. B. Dropping an index. C. Taking a rollback segment offline. D. Exporting a consistent image of a large number of tables. Answer: D Explanation: Answer D is correct. You should use the restricted session mode if you are exporting a consistent image of a large number of tables. Incorrect Answers: A: You don't need to use the restricted session mode to create table. B: You don't need to use the restricted session mode to drop an index. D: You don't need to use the restricted session mode to take a rollback segment offline. Actualtests.com - Th...
View Full Document

Ask a homework question - tutors are online