ASP.NET Core MVC - Cross-Platform Development - Managing Database Changes

What are the two new features requested by the client that require database changes?

• Tracking classes and student enrollments

• Adding a new user interface

• Improving system performance

• Enhancing security protocols

What tool is used to connect to the database instance running in Docker?

• Eclipse

• Visual Studio Code

• Data Studio

• SQL Server Management Studio

Why is it important to start a script with a 'use' statement in Data Studio?

• To ensure the script runs against the correct database

• To increase script execution speed

• To enable syntax highlighting

• To automatically save the script

What is the primary key in the 'classes' table used for?

• To uniquely identify each class

• To store the class name

• To link to the student table

• To define the class schedule

What is a foreign key used for in the 'classes' table?

• To reference related data in another table

• To store additional class information

• To increase database security

• To improve query performance

What command is used to scaffold the context in .NET EF Core?

• .NET EF Core Update

• .NET EF Core Scaffold

• .NET EF Core Migrate

• .NET EF Core Build

Why might you use a PowerShell script for database commands?

• To automate repetitive tasks

• To enhance security

• To improve database performance

• To create a backup of the database