The main purpose of the global object in Node.js is to manage global variables and provide a context for globally accessible methods and properties. It is not primarily responsible for handling exceptions, controlling execution flow, or defining local variables.

In Express.js, the order in which routes are defined affects the routing mechanism. Routes are matched in the order they are defined, and the first matching route is executed. This means that the order of route definitions is crucial as it determines which route will handle a request.

According to SemVer, when you have experimental or initial releases that may have breaking changes, you should start with version 0.0.1. This signifies that the package is in the early development stage.

A parameterized query helps prevent SQL Injection attacks by escaping special characters in user input. This ensures that user input is treated as data and not executable code. The other options do not accurately describe how parameterized queries work against SQL Injection.

When testing a method that processes data from a database, you should use stubbing to simulate different scenarios and edge cases related to data retrieval. This can be achieved by stubbing the method that retrieves data and having it return different values for each test scenario. Stubbing the entire database may lead to over-complicated tests, and avoiding stubbing by using the real database can result in unreliable and slow tests. Stubbing only network communication is not sufficient for simulating different scenarios related to data retrieval.

To display the "@" symbol as a literal in a Razor view, you can use double "@" symbols, like "@@". This escapes the "@" symbol and ensures it's rendered as a plain "@" character in the generated HTML.

When there are conflicting directives between a Razor view and _ViewImports.cshtml, the directives in the Razor view take precedence. This means that the directives defined directly within the view itself will override any conflicting directives in the _ViewImports.cshtml file. This allows you to have fine-grained control over individual views.

The .NET CLI (Command-Line Interface) is a command-line tool provided by Microsoft for .NET operations. It allows developers to create, build, and manage .NET applications from the command line, making it a valuable tool for automation and scripting tasks.

To diagnose and rectify login functionality issues related to migrations, you should examine the database schema and migration history. Check if the expected changes have been applied by reviewing the migrations and comparing the schema with your model. This allows you to identify discrepancies and take appropriate corrective actions.

To programmatically sign in a user after creating them, you can use the 'SignInAsync' method provided by the UserManager class in ASP.NET Core Identity. This method sets up the authentication cookies and establishes the user's identity for subsequent requests.