Free 70-761 sample questions
Here are free 70-761 sample questions on T-SQL, each with an answer and an explanation. They cover joins, window functions and error handling. Use them to practise query skills that still matter in SQL Server today.
Try them in the simulator Same questions, with study, timed and flashcard modes.
Showing 6 of 12 free sample questions.
You are required to substitute three subqueries named SQ1, SQ2, and SQ3 with named result sets or temporary tables. The result set of SQ1 has to make use of the execution scope of a SELECT statement. Other session users have to see the result set of SQ2 prior to it being removed. Other statements in the same session should have access to the result set of SQ3. However, the result set of SQ3 should be invisible to other sessions. You have to make sure that a suitable subquery replacement is used for SQ2. Which of the following is the option you should use?
Your company has a database that includes the Clients, Towns, and Clientclassifications tables. The database monitors purchases and shipping for American clients. All of these tables have system versioning configured. You have been tasked with writing a query that retrieves data for analyzing the effects of discounts on credit limits. The main purpose of the analysis is to ascertain the average credit limit for every standard discount percentage, from 0% to 4%. Which of the following should be included in your Transact-SQL statement?
You are required to generate a table named Expenses that includes an ID, a Motivation, and a Total column. You informed that the ID column should be configured as the table’s primary key, which has to be a value that is globally exclusive. When INSERT procedures are executed, the value must be created automatically. The Motivation column should be configured to allow for values from various languages, with a maximum of 600 characters for explaining why a payment was made. The Total column should be configure to contain monetary values, and should not result in computations generating rounding inaccuracies. You need to use the correct data type for the Motivation column. Solution: You make use of the Nvarchar data type. Has the requirement been satisfied?
You are preparing to create a table using a Transact-SQL statement. You need to assign a property to a column, which prompts the Database Engine to supply a unique, incremental value when a new row is added to the table. Which of the following is property you should assign?
You are tasked with making sure that Users are capable of obtaining data from the tables in a specific database in an informal manner. The data retrieved should be referenced as a single table. You are informed that users must be able to retrieve the necessary information according to the variables stated when the query is made. Solution: Include a TRY_PARSE function in the Transact-SQL query. Has the requirement been satisfied?
6 more free samples are waiting
Create a free account to unlock the whole 70-761 sample bank, or get full access to all 52 practice questions in the simulator.