1. In your production database, you use a parameter file and a server parameter file alternately. You have modified some parameters in your parameter file. After this, you want to incorporate the same changes into your server parameter file. Which action will you use to incorporate PFILE changes into the SPFILE?
2. You have executed the following statement:
SQL> ALTER TABLESPACE SYSAUX RENAME TO SYSAUXTAB;
What would happen as a result of that statement?
3. If the SQL used is poorly designed, an application may experience performance problems. What's the best approach to tuning SQL?
4. What happens if you increase the database block size by doubling it?
5. In Oracle Database 11g, what's the new system privilege designed for?
Question
Solution Preview
These solutions may offer step-by-step problem-solving explanations or good writing examples that include modern styles of formatting and construction of bibliographies out of text citations and references. Students may use these solutions for personal skill-building and practice. Unethical use is strictly forbidden.
1.Answer: Although it might seem strange, the modified PFILE is in a way “stronger” than SPFILE. If we try to edit the SPFILE, it won’t work....
By purchasing this solution you'll be able to access the following files:
Solution.docx.
Return to homework library