How would you improve the efficiency of this query?
You work as a database administrator at ABC.com. ABC.com has a SQL Server 2012 database
infrastructure that contains a database named ABCDB.
The ABCDB database is used by an in-house application named ABCApp3 that queries a readonly table with a clustered index. ABC.com users report that ABCApp3 is functioning sluggishly.
You suspect query the application uses is causing the problem. You analyze the query and
discover that column referenced in the WHERE clause is not part of the clustered index. You also
notice that the query returns five columns, as well as a COUNT (*) clause grouped on the five
columns.
How would you improve the efficiency of this query?
How would you create the stored procedure?
You work 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,
CustomerName nvarchar (250) NOT NULL,
Address1 nvarchar (100) NOT NULL,
Address2 nvarchar (100) NULL,
City nvarchar (50) NOT NULL,
State nvarchar (50) 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 are developing a stored procedure named OrdersByDate that returns the OrderID,
CustomerID, CustomerName and OrderDate. The stored procedure will take a parameter named
@date that uses the int datatype. The @date parameter will be used to filter the result set based
on the OrderDate column in the Orders table.
How would you create the stored procedure?
Which of the following SELECT statement would you write?
You work as a database administrator at ABC.com. ABC.com has a SQL Server 2012 database
named ProductsDB. The ProductsDB database is shown in the following database diagram:
You need to write a Transact-SQL query that displays rows of data in the following XML format:
<Suppliers>
<CompanyName>Company Name</CompanyName>
<ContactName>Contact Name</ContactName>
<Phone>453 3545 5224</Phone>
<Products>
<ProductID>10</ProductID>
<ProductName>Product Name</ProductName>
<UnitPrice>559.00</UnitPrice>
<UnitsInStock>12</UnitsInStock>
</Products>
<Products>
<ProductID>132</ProductID>
<ProductName>Product Name</ProductName>
<UnitPrice>59.00</UnitPrice>
<UnitsInStock>102</UnitsInStock>
</Products>
<Products>
<ProductID>259</ProductID>
<ProductName>Product Name</ProductName>
<UnitPrice>599.00</UnitPrice>
<UnitsInStock>6</UnitsInStock>
</Products>
</Suppliers>
Which of the following SELECT statement would you write?
Which of the following is TRUE with regards to this class?
You work as a developer at ABC.com. The ABC.com network consists of a single domain named
ABC.com. You make use of CSS3 and HTML5 for development purposes.
You are in the process of creating a client web form for ABC.com. The form contains an HTML
that requires the client to provide a suitable age, before the form is tendered.
You have added the necessary validation to the control. The validation includes an object of the
regex class.
Which of the following is TRUE with regards to this class? (Choose all that apply.)
Which of the following describes the reason for using this HTML?
You work as a developer at ABC.com. The ABC.com network consists of a single domain named
ABC.com. You make use of CSS3 and HTML5 for development purposes.
You are in the process of creating a client contact form for ABC.com. The form must be configured
to gather data regarding the client, and will be displayed on a page of ABC.com’s website.
You have added the following HTML:
<input name=”email” type=”email”/>
Which of the following describes the reason for using this HTML?
Which of the following are modes of the HTML5 PROGRESS element?
You work as a senior developer at ABC.com. The ABC.com network consists of a single domain
named ABC.com.
You are running a training exercise for ABC.com’s junior developers. You are currently discussing
the HTML5 PROGRESS element.
Which of the following are modes of the HTML5 PROGRESS element? (Choose two.)
Which of the following describes the reason for using this attribute?
You work as a developer at ABC.com. The ABC.com network consists of a single domain named
ABC.com. You make use of CSS3 and HTML5 for development purposes.
You are in the process of creating a client web form for ABC.com. The form contains an HTML
with the necessary validation. The validation includes the required attribute.
Which of the following describes the reason for using this attribute?
what your input type should be?
You work as a developer at ABC.com. The ABC.com network consists of a single domain named
ABC.com. You make use of CSS3 and HTML5 for development purposes.
You are in the process of creating a web page for ABC.com. The page will contain a slider control
for users to select their age. The slider control should not allow for the selection of ages 17 and
below, or ages 66 and above.
Which of the following describes what your input type should be?
Which of the following is the property being discussed?
You work as a senior developer at ABC.com. The ABC.com network consists of a single domain
named ABC.com. You make use of CSS3 and HTML5 for development purposes.
You are running a training exercise for ABC.com’s junior developers. You are currently discussing
property that obtains the Web Storage area specific to the current document.
Which of the following is the property being discussed?
Which of the following elements should be included in your code?
You work as a developer at ABC.com. The ABC.com network consists of a single domain named
ABC.com. You make use of CSS3 and HTML5 for development purposes.
You are in the process of creating a web application for ABC.com. You want to make sure that an
image in your content is specified, and that a description is related with it.
You want to make use of the correct semantic markup elements in your code.
Which of the following elements should be included in your code? (Choose two.)