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?