Chapter 4 Review Questions DB
Chapter 4 review questions – Abhinav Anand
1. List the decisions a network administrator should make prior to database installation.
A: Meeting requirements for software and hardware, and changing certain software and hardware components if needed to meet those requirements. Also making security decisions before installation such as having multiple firewalls, encrypting connections, configuring ports on the computer and even on an individual basis.
2. Explain what must be considered when choosing the appropriate supporting platform for an edition of SQL server 2008 being installed on a machine.
A: First choosing an appropriate platform, such as 32-bit or 64-bit, next finding which operating system you use and from that choosing the right edition to download. In general, SQL 2008 can be placed on different versions of Windows Server 2008, 2003, 7, Vista and XP. Then figuring out if you meet all the prerequisites that are needed for downloading SQL server 2008, such as having the latest version of Power Shell, having NET framework 3.5 SP11, having Internet Explorer 6 SP1 or later and so forth.
3. Identify and define at least six different features of Microsoft SQL Server available for downloading and Installation.
A: SQL server 6.05 had the first version to be written solely by Microsoft, SWL server 7.0, database engine was rewritten to support small-to-medium sized businesses. SQL server 2000, first version to support enterprise environments database engine was enhanced for improved performance and scalability. SQL server 2005, engine was rewritten to include integration services, .NET framework giving the user the ability to create NET SQL server. SQL server 2008, additions to the 2005 include additional data types, use of (LINO), and XML.
4. Explain why it is better to install a unique username and password for each installed feature, compares to one general username and password for all features.
A: This is mainly for security reasons, having a unique
1. List the decisions a network administrator should make prior to database installation.
A: Meeting requirements for software and hardware, and changing certain software and hardware components if needed to meet those requirements. Also making security decisions before installation such as having multiple firewalls, encrypting connections, configuring ports on the computer and even on an individual basis.
2. Explain what must be considered when choosing the appropriate supporting platform for an edition of SQL server 2008 being installed on a machine.
A: First choosing an appropriate platform, such as 32-bit or 64-bit, next finding which operating system you use and from that choosing the right edition to download. In general, SQL 2008 can be placed on different versions of Windows Server 2008, 2003, 7, Vista and XP. Then figuring out if you meet all the prerequisites that are needed for downloading SQL server 2008, such as having the latest version of Power Shell, having NET framework 3.5 SP11, having Internet Explorer 6 SP1 or later and so forth.
3. Identify and define at least six different features of Microsoft SQL Server available for downloading and Installation.
A: SQL server 6.05 had the first version to be written solely by Microsoft, SWL server 7.0, database engine was rewritten to support small-to-medium sized businesses. SQL server 2000, first version to support enterprise environments database engine was enhanced for improved performance and scalability. SQL server 2005, engine was rewritten to include integration services, .NET framework giving the user the ability to create NET SQL server. SQL server 2008, additions to the 2005 include additional data types, use of (LINO), and XML.
4. Explain why it is better to install a unique username and password for each installed feature, compares to one general username and password for all features.
A: This is mainly for security reasons, having a unique