117-102 LPIC-1 certification, Lpi 117-102 practice exam

[Free Onine Test] Microsoft 70-461 MCSA: SQL Server 2012/2014 Questions | Killtest

Posted by admin Nov 18 2017 No Comments »

70-461 Querying Microsoft SQL Server 2012

When preparing your MCSA: SQL Server 2012/2014 Certification, please choose Killtest Microsoft 70-461 MCSA: SQL Server 2012/2014 Questions. Killtest offers the valid MCSA: SQL Server 2012/2014 70-461 exam questions to ensure you pass your 70-461 Querying Microsoft SQL Server 2012 Exam.

Killtest has 70-461 free online test for you. Here, we set 10 questions to help you feel real 70-461 Querying Microsoft SQL Server 2012 exam, you can get 10 score once answer a question correctly. The total score is 100.

Now begin your 70-461 free online test:

1. You develop a Microsoft SQL Server 2012 server database that supports an application.
The application contains a table that has the following definition:
CREATE TABLE Inventory
(ItemID int NOT NULL PRIMARY KEY,
ItemsInStore int NOT NULL,
ItemsInWarehouse int NOT NULL)
You need to create a computed column that returns the sum total of the ItemsInStore and ItemsInWarehouse values for each row.
Which Transact-SQL statement should you use?

 
 
 
 

2. You develop a Microsoft SQL Server 2012 database.
You create a view from the Orders and OrderDetails tables by using the following definition.

 

 

 

 

 

You need to improve the performance of the view by persisting data to disk.
What should you do?

 
 
 
 

3. You develop a database for a travel application. You need to design tables and other database objects. You create the Airline_Schedules table. You need to store the departure and arrival dates and times of flights along with time zone information.
What should you do?

 
 
 
 
 
 
 
 
 
 

4. You develop a database for a travel application. You need to design tables and other database objects. You create a stored procedure. You need to supply the stored procedure with multiple event names and their dates as parameters.
What should you do?

 
 
 
 
 
 
 
 
 
 

5. You create a stored procedure that will update multiple tables within a transaction. You need to ensure that if the stored procedure raises a run-time error, the entire transaction is terminated and rolled back.
Which Transact-SQL statement should you include at the beginning of the stored procedure?

 
 
 
 
 
 

6. You have a Microsoft SQL Server 2012 database that contains tables named Customers and Orders.
The tables are related by a column named CustomerID.
You need to create a query that meets the following requirements:
• Returns the CustomerName for all customers and the OrderDate for any orders that they have placed.
• Results must include customers who have not placed any orders.
Which Transact-SQL query should you use?

 
 
 
 

7. You need to build a table structure for a stored procedure to support data entry from a website form of the following requirements:
* Users must validate their age as 18 or older to use the website.
* Users who leave the data of birth field blank or who enter an invalid date, must receive an error.
Which two actions should you perform? Select Two

 
 
 
 
 

8. You are developing a stored procedure in a SQL Server database. You have CREATE PROCEDURE. You need to ensure that you can recompile individual statements in the stored procedure or the correct.
Which two actions can you perform? (Choose Two)

 
 
 
 

9. You are developing a database that will contain price information.
You need to store the prices that include a fixed precision and a scale of six digits.
Which data type should you use?

 
 
 
 

10. You are writing a set of queries against a FILESTREAM-enabled database.
You create a stored procedure that will update multiple tables within a transaction.
You need to ensure that if the stored procedure raises a run-time error, the entire transaction is terminated and rolled back.
Which Transact-SQL statement should you include at the beginning of the stored procedure?

 
 
 
 
 
 

Question 1 of 10

How many points have you got? You can click the full version picture to visit Killtest Microsoft 70-461 MCSA: SQL Server 2012/2014 Questions and get the full version now. Any questions, please contact us: sales@killtest.com.

 

 

Tags: , , , , ,

Leave a Reply