You are maintaining a Microsoft SQL Server database. You run the following query: You observe performance issues when you run the query. You capture the following query execution plan: You need to ensure that the query performs returns the results…
HOTSPOT You are developing an SQL Server database. The database contains two tables and a function that are defined by the following Transact-SQL statements. You need to create a query to determine the total number of products that are sold…
You are developing a Microsoft SQL Server 2012 database for a company. The database contains a table that is defined by the following Transact-SQL statement: You use the following Transact-SQL script to insert new employee data into the table. Line…
HOTSPOT You are developing an SQL Server database for an automobile manufacturer. The manufacturer maintains the list of vehicles sold and vehicles that have been recalled. The tables are shown below: You have the following Transact-SQL code. Line numbers are…
You are writing a set of queries against a FILESTREAM-enabled database. You create a stored procedure that will update multiple tables within a transaction. You need to ensure that if the stored procedure raises a run-time error, the entire transaction…
HOTSPOT You are designing an order entry system that uses an SQL Server database. The database includes the following tables: You need to ensure that Orders are added to the Orders table only for customers that have an account balance…
You use Microsoft SQL Server 2012 to develop a database application. You need to create an object that meets the following requirements: Takes an input parameter Returns a table of values Can be referenced within a view Which object should…
You administer a Microsoft SQL Server 2012 database that includes a table named Products. The Products table has columns named ProductId, ProductName, and CreatedDateTime. The table contains a unique constraint on the combination of ProductName and CreatedDateTime. You need to…
You have a Microsoft SQL Server database that includes two tables named EmployeeBonus and BonusParameters. The tables are defined by using the following Transact-SQL statements: The tables are used to compute a bonus for each employee. The EmployeeBonus table has…
You create a view based on the following statement: You grant the Select permission to User1. You need to change the view so that it displays only the records that were processed in the month prior to the current month.…