What Transact SQL statement would accomplish this task?
CORRECT TEXT
You are employed as a SQL Server 2012 database developer at ABC.com. ABC.com has a
database named HRDB with tables named Staff and SalaryHistory. The Staff and SalaryHistory
tables were created using the following Transact-SQL code:
CREATE TABLE HRDB.Staff
(
StaffID int NOT NULL PRIMARY KEY,
FirstName nvarchar(50) NOT NULL,
LastName nvarchar(50) NOT NULL,
JobTitle nvarchar(50) NOT NULL,
StaffAddress nvarchar (200) NULL,
StaffCity nvarchar(50) NOT NULL,
StaffState nvarchar(50) NOT NULL,
StaffPhone varchar (10) NOT NULL,
Salary smallmoney NOT NULL
)
GO
CREATE TABLE HRDB.SalaryHistory
(
StaffID int NOT NULL,
IncreaseDate date DEFAULT GETDATE(),
PrevSalary smallmoney NOT NULL,
NewSalary smallmoney NOT NULL
)
GO
You must write a Transact-SQL query to affect a salary increase of 6.5% for all staff members with
a JobTitle of Support Technician. Your query must also update the data in the SalaryHistory table.
What Transact SQL statement would accomplish this task?
To answer, type the correct code in the answer area.
How would you create this table?
CORRECT TEXT
You are employed as a SQL Server 2012 database developer at ABC.com. ABC.com has a
database named SalesDB with tables named Customer and Orders. The Customer and Orders
tables were created using the following Transact-SQL code:
CREATE TABLE SalesDB.Customers
(
CustomerID int NOT NULL PRIMARY KEY,
FirstName varchar (150) NOT NULL,
LastName varchar (150) NOT NULL,
Address1 varchar (200) NOT NULL,
Address2 varchar (200) NULL,
City varchar (100) NOT NULL,
StateCode varchar (2) NOT NULL,
Zip varchar (5) NOT NULL,
Phone varchar (10) NOT NULL
)
GO
CREATE TABLE SalesDB.Orders
(
OrderID int NOT NULL PRIMARY KEY,
CustomerID int NOT NULL,
OrderDate datetime NOT NULL,
ShipDate datetime NOT NULL,
CustomerID int NOT NULL,
SalesRepID int NOT NULL
)
GO
You must now create an OrderDetails table as shown in the following database diagram:
The TotalPrice column must be a computed column based on the product of the UnitPrice and
Quantity columns and the data must be stored in the table.
How would you create this table?
To answer, type the correct code in the answer area.
Which of the following actions should you use to achieve this?
You are employed as an application developer at ABC.com. ABC.com makes use of Microsoft
.NET Framework 4 for Windows Presentation Foundation (WPF) application development.
You have been tasked with developing an application that contains a form, which requires the use
of drag-and-drop operations. After making the necessary configurations, you are informed that as
soon as the pointer passes the limits of the form the drag-and-drop processes should end.
Which of the following actions should you use to achieve this?
Which of the following statements are TRUE with regards to the configuration?
You are employed as an application developer at ABC.com. You make use of Microsoft .NET
Framework 4 to develop Windows Presentation Foundation (WPF) applications.
You have created a new application, and written the code shown below:
MediaPlayer player = new MediaPlayer();
player.Open(new URI(AudioFilePath), UriKind.Relative)); player.play();
You then inserted this code into the button onclick event.
Which of the following statements are TRUE with regards to the configuration?
Select the correct answer if the underlined text does not make the statement correct
This question requires that you evaluate the underlined text to determine if it is correct.
When creating a site to utilize message queuing, the IP address must be configured to
MSMQ.
Select the correct answer if the underlined text does not make the statement correct. Select
"No change is needed” if the underlined text makes the statement correct.
You need to ensure that you can assign classifications to Share1 from Windows Explorer manually
You have a server named FS1 that runs Windows Server 2012 R2.
You install the File and Storage Services server role on FS1.
From Windows Explorer, you view the properties of a shared folder named Share1 and you
discover that the Classification tab is missing.
You need to ensure that you can assign classifications to Share1 from Windows Explorer
manually.
What should you do?
You need to ensure that if the WAN link between Site1 and Site2 fails while you are performing maintenance on
You have five servers that run Windows Server 2012 R2. The servers have the Failover
Clustering feature installed.
You deploy a new cluster named Cluster1. Cluster1 is configured as shown in the following table.
Server1, Server2/ and Server3 are configured as the preferred owners of the cluster roles.
Dynamic quorum management is disabled.
You plan to perform hardware maintenance on Server3.
You need to ensure that if the WAN link between Site1 and Site2 fails while you are
performing maintenance on Server3, the cluster resource will remain available in Site1.
What should you do?
How should you create the JavaScript code?
DRAG DROP
You have a webpage that includes the following markup:
An XML file named message.xml resides on a web server. The structure of the file is as follows:
You are developing a code-based solution to parse the contents of the XML file and display the
information on the page.
The solution must work on both modern and older browsers.
You need to display the information from the XML file onto the page.
How should you create the JavaScript code? (Develop the solution by selecting the required code
segments and arranging them in the correct order. You may not need all of the code segments.)
which order will the five style sheets be applied?
DRAG DROP
You are creating an application by using HTML5 and CSS3. The styles for the pages are derived from
five style sheets.
The styles are not being applied correctly to the pages in the application.
You need to determine the order in which the style sheets will be applied by the browser.
In which order will the five style sheets be applied? (To answer, move the style sheet types from the
list of style sheet types to the answer area and arrange them in the order that they will be applied.)
Which collection type should you use?
You are developing an application that includes a class named Order. The application will
store a collection of Order objects.
The collection must meet the following requirements:
Use strongly typed members.
Process Order objects in first-in-first-out order.
Store values for each Order object.
Use zero-based indices.
You need to use a collection type that meets the requirements.
Which collection type should you use?