As a database administrator download and install one oracle and any one MS SQL server database...

Transcribed Image Text:

As a database administrator download and install one oracle and any one MS SQL server database utility as shown from the list below (although not exhaustive and alternative flavours welcome): 1. Oracle 11g environment (both for Windows and Linux) 2. Oracle 12c environment (both for Windows and Linux) 3. MS-SQL Server 2017 environment 4. MS-SQL Server 2019 environment where the installations can run for both a Windows (e.g. a dedicated Windows 10 or higher) compatible operating system and a Unix variant operating system (i.e. any Linux installations, or a Solaris Unix, FreeBSD etc.).(Hint many databases come with different releases within a version and you are free to choose any one). In addition to these basic installation requirement ensure that setup supports an Oracle NOSQL database (with say a Cloudera distribution of HADOOP as an example) as well as MS-SQL Server environments running Hadoop and its ability to support NO-SQL utilities. Your role is to document the installation process "very" carefully, highlighting any installation failures encountered within the environments selected and how the error identified at installation was fixed. Once the installations are complete, explain thoroughly the features available in these database tools and how they actually work including the details of the installation steps that were carried out. You will need to screen shot the processes. Ensure that you configure your machine to run hyper-V to prevent any hazards of installations on your local machine. This new setup will constitute a part of your lab environment for the remainder of the course so please complete ASAP. Marking Scheme Evidence of knowledge of the installation scenarios Analysis of the features within the installation 50% 50% As a database administrator download and install one oracle and any one MS SQL server database utility as shown from the list below (although not exhaustive and alternative flavours welcome): 1. Oracle 11g environment (both for Windows and Linux) 2. Oracle 12c environment (both for Windows and Linux) 3. MS-SQL Server 2017 environment 4. MS-SQL Server 2019 environment where the installations can run for both a Windows (e.g. a dedicated Windows 10 or higher) compatible operating system and a Unix variant operating system (i.e. any Linux installations, or a Solaris Unix, FreeBSD etc.).(Hint many databases come with different releases within a version and you are free to choose any one). In addition to these basic installation requirement ensure that setup supports an Oracle NOSQL database (with say a Cloudera distribution of HADOOP as an example) as well as MS-SQL Server environments running Hadoop and its ability to support NO-SQL utilities. Your role is to document the installation process "very" carefully, highlighting any installation failures encountered within the environments selected and how the error identified at installation was fixed. Once the installations are complete, explain thoroughly the features available in these database tools and how they actually work including the details of the installation steps that were carried out. You will need to screen shot the processes. Ensure that you configure your machine to run hyper-V to prevent any hazards of installations on your local machine. This new setup will constitute a part of your lab environment for the remainder of the course so please complete ASAP. Marking Scheme Evidence of knowledge of the installation scenarios Analysis of the features within the installation 50% 50%