DRAG DROP You have a project management application. The application uses a Microsoft SQL Server database to store data. You are developing a software bug tracking add-on for the application. The add-on must meet the following requirements: Allow case sensitive…
DRAG DROP Note: This question-is part of a series of questions that use the same scenario. For your convenience, the scenario is repeated in each question. Each questionpresents a different goal and answer choices, but the text of the scenario…
HOTSPOT You create a table to store sales information for an online sales application by running the following Transact-SQL statement: You have a historical report that summarizes the sales for each quarter and year. The query that generated the data…
HOTSPOT You have the following Transact-SQL statement: DELETE FROM Person WHERE PersonID = 5 You need to implement error handling. How should you complete Transact-SQL statement? To answer, select the appropriate options in the answer area. NOTE: Each correct selection…
DRAG DROP You have a database named DB1 that contains a table named HR.Employees. HR.Employees contains two columns named ManagerID and EmployeeID. ManagerID refers to EmployeeID. You need to create a query that returns a list of all employees, the…
HOTSPOT You have a database that contains the following tables: tblEmployees and tblSalesSummary. Each record contains approximately one million records. You use Microsoft SQL Server Management Studio (SSMS) to run two queries. The Include Actual Execution Plan option is enabled.…
DRAG DROP You run the following Transact-SQL statement: You need to create a stored procedure that meets the following requirements: Inserts data into the Employees table. Processes all data changes as a single unit of work. Sets the exception severity…
HOTSPOT You are developing a training management application. You run the following Transact-SQL statement: You must create a report that returns course identifiers and the average evaluation score for each course. The result set must include only one score for…
HOTSPOT You develop and deploy a project management application. The application uses a Microsoft SQL Server database to store data. You are developing a software bug tracking add-on for the application. The add-on must meet the following requirements: Allow case…
A company’s sales team is divided in two different regions, North and South. You create tables named SalesNorth and SalesSouth. The SalesNorth table stores sales data from the North region. The SalesSouth table stores sales data from the South region.…