What should you do?
You develop a database for a travel application. You need to design tables and other database objects. You need to store media files in several tables. Each media file is less than 1 MB...
You develop a database for a travel application. You need to design tables and other database objects. You need to store media files in several tables. Each media file is less than 1 MB...
You administer a Microsoft SQL Server database that supports a banking transaction management application. You need to retrieve a list of account holders who live in cities that do not have a branch location....
You develop a Microsoft SQL Server database. The database contains a table defined by the following Transact-SQL statement: All regions have more than one employee. You need to write a query to find the...
You use Microsoft SQL Server to develop a database application. Your application sends data to a VARCHAR (50) variable named @var. You need to write a Transact-SQL statement that will return information on a...
DRAG DROP You administer a Microsoft SQL Server database named ContosoDb. ContosoDb contains a table named Suppliers and an indexed view named VWLocalSuppliers, both of which were created by using the following Transact-SQL statement:...
CORRECT TEXT You have a database that contains the tables shown in the exhibit. (Click the Exhibit button.) You need to create a view named uv_CustomerFullName to meet the following requirements: • The code...
A table named Profits stores the total profit made each year within a territory. The Profits table has columns named Territory, Year, and Profit. You need to create a report that displays the profits...
You use a Microsoft SQL Server database that contains a table. The table has records of web requests as shown in the exhibit. (Click the Exhibit button.) Your network has three web servers that...
CORRECT TEXT 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...
You are working with a table that has an XML column that contains information about books. Each book may have an associated price. You need to write a query that returns each author on...