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 in size. The media files will require fast access and will be retrieved
frequently.
What should you do?

You develop a database for a travel application. You need to design tables and other database
objects.
You create a view that displays the dates and times of the airline schedules on a report.
You need to display dates and times in several international formats.
What should you do?

You are a database developer of a Microsoft SQL Server 2012 database.
You are designing a table that will store Customer data from different sources. The table will include
a column that contains the CustomerID from the source system and a column that contains the
SourceID
A sample of this data is as shown in the following table.

You need to ensure that the table has no duplicate CustomerID within a SourceID. You also need to
ensure that the data in the table is in the order of SourceID and then CustomerID.
Which Transact- SQL statement should you use?

You have three tables that contain data for vendors, customers, and agents. You create a view that is
used to look up telephone numbers for these companies.
The view has the following definition:

You need to ensure that users can update only the phone numbers by using this view.
What should you do?

You develop a Microsoft SQL Server 2012 database that contains tables named Employee and
Person.
The tables have the following definitions:

Users are able to use single INSERT statements or INSERT…SELECT statements into this view.
You need to ensure that users are able to use a single statement to insert records into both
Employee and Person tables by using the VwEmployee view.
Which Transact-SQL statement should you use?

You develop a Microsoft SQL Server 2012 database that contains a table named Products. The
Products table has the following definition:

You need to create an audit record only when either the RetailPrice or WholeSalePrice column is
updated.
Which Transact-SQL query should you use?

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 made by each territory for each year and its
previous year.
Which Transact-SQL query should you use?

You use Microsoft SQL Server 2012 database to develop a shopping cart application.
You need to rotate the unique values of the ProductName field of a table-valued expression into
multiple columns in the output.
Which Transact-SQL operator should you use?

You administer a Microsoft SQL Server database that supports a shopping application.
You need to retrieve a list of customers who live in territories that do not have a sales person.
Which Transact- SQL query or queries should you use? (Each correct answer presents a complete
solution. Choose all that apply.)

You support a database structure shown in the exhibit. (Click the Exhibit button.)

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
A grand total of the sales amount
Which Transact-SQL query should you use?