Describe how the Initial Size setting is used when defining a database. How can this setting affect database performance?
What will be an ideal response?
The Initial Size setting defines the initial size of the data and log files; the default sizes are 4 MB and 1 MB, respectively. Increasing the file size after a database has been created consumes significant resources and will lead to degraded performance. Other than the space that the files occupy on a physical disk, there is no harm in setting a file size that is much larger than the space that the data occupies.
You might also like to view...
While a ToolTip is being displayed, it’s appearance remains the same.
What will be an ideal response?
In OpenOffice Writer, the editing mode that tracks all edits made to a document is called ________
A) Record Changes B) shareware C) Record Updates D) AutoValue
A constant is a value that never changes, such as months in a year
Indicate whether the statement is true or false
When mathematical equations are used to describe an algorithm, the description is called ____.
A. pseudocode B. a formula C. an opcode D. a flowchart