Answer these question bellows. 1. A new database administrator wants to test a backup and restore for the sales database on a SQL server. Using the dropdown arrows, choose the correct code for both a full backup of the database to the backups folder on the E: drive, naming the backup sales.bak, and a restore of the database. a. What is the correct statement for backing up the database? Answer:BACKUP DATABASE sales TO DISK = 'E:\backups\sales.bak b. What is the correct statement for restoring the database? Answer:RESTORE DATABASE sales FROM DISK = E:\backups\sales.bak 2. A report writer for a school wants to show students who appear in both a current student list and an archived student list to identify potential duplicate records between lists. Which query will return the needed records for the writer, including the duplicate records between the two tables? A. SELECT lastname, firstname from studentlist INTERSECT ALL SELECT lastname, firstname from archivestudentlist B. SELECT lastname, firstname from studentlist UNION SELECT lastname, firstname from archivestudentlist C. SELECT lastname, firstname from studentlist UNION ALL SELECT lastname, firstname from archivestudentlist D. SELECT lastname, firstname from studentlist INTERSECT SELECT lastname, firstname from archivestudentlist 3. You volunteer at a private campground. You are creating a database object named Campers to store the following data: IDName Cabin 1 Chipmunks 10 2 Squirrels 11 3 Bears 12 Which syntax should you use to create the object? Answer: CREATE TABLE Campers ( ID INT, Name VARCHAR(25), Cabin INT) 4. Evaluate the sample of records from the following sales_summary table: Date 1/3/23 1/3/23 1/4/23 1/4/23 Salesperson Jorgensen Smithson Marquez Smithson Amount 3000 3500 4000 3210 For a weekly sales report, a sales manager needs to see the top five salespersons by amount from the current day and the seven previous days. Which SQL statement will fulfill these requirements? A. SELECT TOP 5 Date, Salesperson, SUM (Amount) FROM sales_summary WHERE Date BETWEEN GETDATE() and GETDATE() -7 GROUP BY Date, Salesperson ORDER BY SUM (Amount) DESC B. SELECT TOP 5 Date, Salesperson, SUM (Amount) FROM sales_summary WHERE Date BETWEEN GETDATE() and GETDATE() -7 ORDER BY SUM (Amount) DESC C. SELECT TOP 5 Date, Salesperson, SUM (Amount) FROM sales_summary WHERE Date BETWEEN GETDATE() and GETDATE() -7 GROUP BY Date, Salesperson D. SELECT TOP 5 Date, Salesperson, SUM (Amount) HAVING Date BETWEEN GETDATE() and GETDATE() -7 FROM sales_summary GROUP BY Date, Salesperson ORDER BY SUM (Amount) DESC 5. In a database table, a group of fields across one row is called a what? A. Record B. Relationship C. Table D. Column