Querying Microsoft SQL Server 2012/2014 Free Practice Exam Questions

24 real Querying Microsoft SQL Server 2012/2014 exam questions with answers and AI explanations. Microsoft certification prep — page 1 of 3.

1. Question 1: You have a Microsoft SQL Server database that contains tables named Customers and Orders. The tables are related by a column named CustomerID. You need to crea…
2. Question 2: You develop a Microsoft SQL Server database that supports an application. The application contains a table that has the following definition: CREATE TABLE Inve…
3. Question 3: You have a database application that uses Microsoft SQL Server 2012. You have a query named Query1 that returns four columns from a frequently updated table th…
4. Question 4: You develop a database application. You create four tables. Each table stores different categories of products. You create a Primary Key field on each table. Y…
5. Question 5: Your database contains a table named Purchases. The table includes a DATETIME column named PurchaseTime that stores the date and time each purchase is made. Th…
6. Question 6: 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 n…
7. Question 7: You need to build a table structure for a stored procedure to support data entry from a website form. The website form must meet the following requirements: ✑…
8. Question 8: Your database contains a table named SalesOrders. The table includes a DATETIME column named OrderTime that stores the date and time each order is placed. Ther…
9. Question 9: Your application contains a stored procedure for each country. Each stored procedure accepts an employee identification number through the @EmpID parameter. Yo…
10. Question 10: You are developing a database application by using Microsoft SQL Server 2012. An application that uses a database begins to run slowly. You discover that the r…