You administer a Microsoft SQL Server instance that will support several databases. You need to ensure that the organization serial numbers can be stored in every new database created. You also need to ensure that the serial numbers are six…

You support a database structure shown in the exhibit. You need to write a query that displays the following details: Total sales made by sales people, year, city, and country Sub totals only at the city level and country level…

DRAG DROP You are developing a Microsoft SQL Server database. You need to meet the following requirements: Create a table that contains a primary key column and an XML data column. Prevent insertion of invalid XML. Load an XML document.…

You use a Microsoft Azure SQL Database instance. The instance contains a table named Products that has columns named Code, Name, and IsPerishable. You need to create a view named VwPerishableProducts that: returns rows from Products that have a value…

DRAG DROP You use a Microsoft Azure SQL Database instance named ContosoDb. ContosoDb contains a table named Products that has existing records. The Products table has columns named Code and QuantityOnHand. You need to create a new column in the…

You administer a Microsoft SQL Server database named Orders. The database contains a table named Customer that has the following definition: You add a new data source to the application that inserts records into the Customer table. An example of…

DRAG DROP You develop a Microsoft SQL Server database. The database contains a table named Level that is defined by the following Transact-SQL statement: There are thousands of rows in the Level table, with significant duplication of data in the…

You develop a Microsoft SQL Server database. You design a table to store product information. The table is defined as follows: You need to meet the following requirements: If a product has a product category value "REGULAR", the product should…

SIMULATION You have a SQL Server database that contains all of the sales data for your company. You need to create a query that returns the customers who represent the top five percent of the total actual sales. Part of…

You administer a Microsoft Azure SQL Database instance. You are writing a new stored procedure that uses explicit transactions. You need to ensure that no other process can affect the objects being used by the stored procedure while it is…