Controlfile DB Parameters   «Prev  Next»

Managing Database Parameters - Quiz

1. Which two commands will display the current value of the sort_area_size parameter?
Please select all the correct answers.
  A. SHOW PARAMETER sort_area_size
  B. SELECT value FROM dba_parameter WHERE name = 'sort_area_size';
  C. ALTER SYSTEM SHOW sort_area_size
  D. SELECT value FROM v$parameter WHERE name = 'sort_area_size';

2. You need a list of all parameters that you've modified since instance startup. Which command should you execute?
Please select the best answer.
  A. SHOW PARAMETERS * WHERE MODIFIED;
  B. SELECT name FROM v$parameter WHERE ismodified <> 'FALSE';
  C. SELECT name FROM dba_parameter WHERE ismodified <> 'FALSE';
  D. SELECT name FROM v$modified_parameters;

3. Earlier, you disabled resource limits for your database. Now you want to re-enable them, but you don't want to stop and restart the database. Which command should you issue?
Please select the best answer.
  A. ALTER RESOURCE LIMITS SET enforcement = TRUE;
  B. UPDATE v$parameter SET value = 'TRUE' WHERE name = 'resource_limit';
  C. ALTER SYSTEM ENABLE RESOURCE LIMITS;
  D. ALTER SYSTEM SET resource_limit = TRUE;