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...
Answer the following statements true (T) or false (F)
1. Any global declarations or definitions can be placed in a namespace.
2. The include statement, #include “file.h” looks first in the system defined directory for file.h then, if the file is not found, it looks in the user’s current directory. (Windows PC and Macintosh users sometimes use “folder” for what I call “directory”.)
3. The include statement, #include
A visual aid consisting of a ____ appears under text that is a bookmark.
A. solid line B. bold line C. dashed line D. wavy line