Exam about Querying MS SQL Server / consisting of questions and answers up + questions. Exam questions from questions and answers for Querying MS SQL Server / Exam Querying Microsoft SQL Server Objective chapter LessOn 1. create Database Objects Create and alter tables using T-SQL syntax.
|Language:||English, Spanish, Dutch|
|ePub File Size:||19.63 MB|
|PDF File Size:||9.77 MB|
|Distribution:||Free* [*Regsitration Required]|
Materiais voltados para certificações. Contribute to skywalkerluc/certification- materials development by creating an account on GitHub. Querying Microsoft SQL Server (MOC C). Course – 40 Hours. This 5-day instructor led course provides students with the technical. Exam Querying Microsoft SQL Server OBJECTIVE. CHAPTER. LESSON. 1. CREATE DATABASE OBJECTS. Create and alter tables using.
Bernard Palmer. If you don't receive any email, please check your Junk Mail box. AB Explanation: You need to ensure that if DeleteJobCandidate encounters an error, the execution of the stored procedure reports the error number. We start with very simple example and add extra options one step at a time. Which Transact-SQL query should you use? Stored procedure C.
You need to create a query that returns a list of products from Sales. The solution must meet the following requirements: You have an application named App1. You have a parameter named Count that uses the int data type. App1 is configured to pass Count to a stored procedure.
Id is the Primary Key. You need to append the "This is in a draft stage" string to the Summary column of the recent 10 entries based on the values in EntryDateTime. C Explanation: According to the append possibility of.
Write method when offset is specified as NULL. You create a stored procedure named DeleteJobCandidate. You need to ensure that if DeleteJobCandidate encounters an error, the execution of the stored procedure reports the error number.
The Profits table has columns named Territory, Year, and Profit. You need to create a report that displays the profits made by each territory for each year and its preceding year. Which Transact-SQL query should you use? Line numbers are included for reference only.
The procedure can be called within other transactions.
Log table fails. Which code segment should you add to line 14? You need to write a Transact-SQL statement that will find out the success of a cast to a decimal 36,9.
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?
E Explanation: The database is used by two web applications that access a table named Products. You want to create an object that will prevent the applications from accessing the table directly while still providing access to the required data. You need to ensure that the following requirements are met: You need to achieve this goal by using the minimum amount of changes to the applications. What should you create for each application? The application contains a table that has the following definition: You need to create a computed column that returns the sum total of the ItemsInStore and ItemsInWarehouse values for each row.
The new column is expected to be queried heavily, and you need to be able to index the column. The Customers table has the following definition. You need to create an audit record only when either the MobileNumber or HomeNumber column is updated.
Both tables have a column named AccountNumber of the nvarchar data type. You need to ensure that when multiple records are inserted in the Transactions table, only the records that have a valid AccountNumber in the SavingAccounts or LoanAccounts are inserted. If you don't receive any email, please check your Junk Mail box. If it is not there too, then contact us to info docsity.
If even this does not goes as it should, we need to start praying! This is only a preview.
Load more. Search in the document preview. DateHired B.
DepartmentID C. EmployeelD D. EmployeeNum E. JobTitle G. LastName H. MiddleName I. ReportsToID Answer: Float B. Money C. Smallmoney D. Numeric Answer: EmployeeID D. FirstName F. ProductName AND p. CreatedDateTime B. ProductName AND cte. CreatedDateTime C. ProductName D. ProductName Answer: USE Database2 B. USE Database1 D. Deny Delete permissions on each table in the Sales schema for each user.
Convert all indexes to Column Store indexes. Implement Unicode Compression. Implement row-level compression. Implement page-level compression. You discover that the performance of the query is slow. Analysis of the query plan shows table scans where the estimated rows do not match the actual rows for SalesOrderHeader by using an unexpected index on SalesOrderDetail. You need to improve the performance of the query. There is a non-clustered index on the PurchaseTime column.
The business team wants a report that displays the total number of purchases made on the current day. You need to write a query that will return the correct results in the most efficient manner. Which Transact-SQL query should you use? You need to store media files in several tables. Each media file is less than 1MB in size.
The media files will require fast access and will be retrieved frequently. F Explanation: You create a view that displays the dates and times of the airline schedules on a report. You need to display dates and times in several international formats. C Explanation: You are designing a table that will store Customer data from different sources.
The table will include a column that contains the CustomerID from the source system and a column that contains the SourceID. A sample of this data is as shown in the following table. Which Transact- SQL statement should you use?
The tables have the following definitions:.
You need to create an audit record only when either the Retail Price to insert records into both Employee and Person tables by using the VwEmployee view. The Products table has the following definition. You need to create an audit record only when either the RetailPrice or WholeSalePrice column is updated. You create a view that is used to look up telephone numbers for these companies. The view has the following definition. You need to ensure that users can update only the phone numbers by using this view.
Drop the view. The Profits table has columns named Territory, Year, and Profit. You need to create a report that displays the profits made by each territory for each year and its previous year.
You need to rotate the unique values of the ProductName field of a table-valued expression into multiple columns in the output. Which Transact-SQL operator should you use? You need to retrieve a list of customers who live in territories that do not have a sales person. Which Transact- SQL query or queries should you use? Each correct answer presents a complete solution.
You need to write a query that displays the following details: The question about BlogEntry is wrong. We need to "append" the text, with the query proposal in the answer, we overwrite the whole string. The correct answer to this question is C. If you don't receive any email, please check your Junk Mail box. If it is not there too, then contact us to info docsity. If even this does not goes as it should, we need to start praying!
This is only a preview. Load more. Search in the document preview.
Create a clustered index on the view. Use the CAST function. Use the DATE data type. Use an appropriate collation.
Use a user-defined table type. Customers Explanation: CustomerID B. CustomerID C. CustomerID D. CustomerID Answer: TRY D. What should you create for each application? Which object should you use? Inline user-defined function B. Stored procedure C. Table-valued user-defined function D. Scalar user-defined function Answer: Option A B. Option B C. Option C. Option D E. Option E F. Option F Answer: Update statistics on SalesOrderId on both tables. The tables have the following definitions: Option C D.