Which parameter specified in the DEFAULT STORAGE

More DBA job interview questions and answers at http://dba.fyicenter.com/Interview-Questions/

(Continued from previous question...)

137. Which parameter specified in the DEFAULT STORAGE clause of CREATE TABLESPACE cannot be altered after creating the tablespace?

All the default storage parameters defined for the tablespace can be changed using the ALTER TABLESPACE command. When objects are created their INITIAL and MINEXTENS values cannot be changed.

(Continued on next question...)

Other Job Interview Questions

• What is the significance of having storage clause?
• What is a SNAPSHOT LOG?
• What is Restricted Mode of Instance Startup?
• What is a schema?
• What are built-ins used for Processing rows?
• Tablespaces
• Explain the use of table functions.
• Display the records between two range
• Give some examples of Analytical functions
• A user selects from a sequence and gets back two values, his select is:
• More...