IT Fundamentals FC0-U61 Book

 A file backup is a type of backup that copies individual files or folders from a source to a destination. A file backup can be used to back up data on a network drive, as it allows the technician to select the specific files or folders that need to be backed up. A file backup can also be performed incrementally or differentially, which means that only the files that have changed since the last backup are copied, saving time and space. A file backup can be restored easily, as it does not require any special software or hardware to access the backed up files.

A database backup is a type of backup that copies the entire database or parts of it from a source to a destination. A database backup is used to back up data that is stored in a structured format, such as tables, records, and indexes. A database backup can be performed using the native tools of the database management system, such as SQL Server or Oracle, or using third-party software. A database backup can be restored using the same tools that performed the backup, and it may require some additional steps, such as restoring the transaction logs or applying the differential backups.

A webserver backup is a type of backup that copies the files and folders that are related to a webserver, such as HTML, CSS, JavaScript, PHP, images, and so on. A webserver backup is used to back up data that is used to host a website or a web application. A webserver backup can be performed using the file backup method, or using specialized software that can backup the webserver configuration, settings, and permissions. A webserver backup can be restored by copying the files and folders back to the webserver, or using the software that performed the backup.

An operating system backup is a type of backup that copies the entire operating system or parts of it from a source to a destination. An operating system backup is used to back up data that is essential for the functioning of the computer, such as the system files, the registry, the drivers, the applications, and the user settings. An operating system backup can be performed using the native tools of the operating system, such as Windows Backup or Time Machine, or using third-party software. An operating system backup can be restored by booting from a recovery media, such as a CD, DVD, or USB, or using the software that performed the backup.

References: Managing Backups – CompTIA A+ 220-1102, IT Fundamentals - CompTIA, Chapter 12 Compare and Contrast Storage Types - CompTIA IT Fundamentals+ (ITF+) Study Guide: Exam FC0-U61, Second Edition

Renewing the IP address would most likely fix the problem of not being able to access the Internet after connecting to the corporate WiFi. An IP address is a unique identifier that is assigned to a device on a network that uses the Internet Protocol (IP). An IP address consists of four numbers separated by dots, each ranging from 0 to 255. For example, 192.168.1.1 is an IP address. An IP address can be assigned statically (manually) or dynamically (automatically) by a DHCP (Dynamic Host Configuration Protocol) server on the network. Sometimes, an IP address may become invalid or conflict with another device on the network, which may prevent the device from accessing the Internet or other network resources. Renewing the IP address is a process of releasing the current IP address and requesting a new IP address from the DHCP server. Renewing the IP address can help resolve any IP address issues and restore network connectivity. References : The Official CompTIA IT Fundamentals (ITF+) Study Guide (FC0-U61), page 165-166.

 To add a column to an existing table, the database administrator should use the ALTER TABLE statement with the ADD COLUMN clause. This statement allows modifying the structure of a table by adding, deleting, or changing columns and constraints. The CREATE statement is used to create a new table, not to modify an existing one. The UPDATE statement is used to modify the data in a table, not the structure. The DROP statement is used to delete a table or a column, not to add a new column. References:

CompTIA IT Fundamentals (ITF+) Certification Guide, page 307

SQL ADD COLUMN - Add One or More Columns To a Table

 A corrupted cache is the most likely cause of the problem of seeing outdated information on a website. A cache is a temporary storage area that stores copies of frequently accessed data, such as web pages, images, or files. A cache can improve the performance and speed of data retrieval by reducing the need to access the original source. However, sometimes a cache may become corrupted or outdated, which may cause errors or inconsistencies in displaying the data. A corrupted cache may show old or incorrect information on a website instead of the current or updated information. To fix this problem, the user can clear the browser cache and reload the website. References : The Official CompTIA IT Fundamentals (ITF+) Study Guide (FC0-U61), page 202.