1:
| How many buffer pools should you define for your system? |
A1:
| Usually one buffer pool is sufficient, but you can create additional buffer pools for a higher level of database tuning. |
2:
| When do you need to change your configuration parameters? |
A2:
| Usually the default values defined for the configuration parameters are sufficient to suit your needs, but to achieve maximum performance for your system, you should analyze and tune these parameters by using the Configuration Advisor. |
3:
| Can database configuration parameters be set on the client? |
A3:
| Database configuration parameters exist only on the server where the database is located. On the client, you can set database manager configuration parameters. |
4:
| If you expect to have no locks on the data, which isolation level should you use? |
A4:
| Use the uncommitted read isolation level if you expect to have no locks on your data. |
No comments:
Post a Comment