¡Descarga SQl server 2016 exam y más Exámenes en PDF de Programación de Bases de Datos solo en Docsity!
QUESTION: 1
You create a table named Products by running the following Transact-SQL statement:
You have the following stored procedure:
You need to modify the stored procedure to meet the following new requirements:
- Insert product records as a single unit of work.
- Return error number 51000 when a product fails to insert into the database.
- If a product record insert operation fails, the product information must not be permanently written to the database. Solution: You run the following Transact-SQL statement:
Does the solution meet the goal?
A. Yes B. No
Answer: B
QUESTION: 2
You create a table named Products by running the following Transact-SQL statement:
You have the following stored procedure:
You need to modify the stored procedure to meet the following new requirements:
- Insert product records as a single unit of work.
- Return error number 51000 when a product fails to insert into the database.
- If a product record insert operation fails, the product information must not be permanently written to the database. Solution: You run the following Transact-SQL statement:
Does the solution meet the goal?
A. Yes B. No
Answer: A
QUESTION: 4
You create a table named Customer by running the following Transact-SQL statement:
You must insert the following data into the Customer table:
You need to ensure that both records are inserted or neither record is inserted. Solution: You run the following Transact-SQL statement:
Does the solution meet the goal?
A. Yes B. No
Answer: B
QUESTION: 5
You create a table named Customer by running the following Transact-SQL statement:
You must insert the following data into the Customer table:
You need to ensure that both records are inserted or neither record is inserted. Solution: You run the following Transact-SQL statement:
Does the solution meet the goal?
A. Yes B. No
Answer: B
QUESTION: 6
You create a table named Customer by running the following Transact-SQL statement:
Application. Cities
Sales Customer Categories
The company's development team is designing a customer directory application. The application must list customers by the area code of their phone number. The area code is defined as the first three characters of the phone number. The main page of the application will be based on an indexed view that contains the area and phone number for all customers. You need to return the area code from the Phone Number field. Solution: You run the following Transact-SQL statement:
Does the solution meet the goal?
A. Yes B. No
Answer: A
QUESTION: 8
You have a database that tracks orders and deliveries for customers in North America. The database contains the following tables:
Application. Cities
Sales. CustomerCatagories
The company's development team is designing a customer directory application. The application must list customers by the area code of their phone number. The area code is defined as the first three characters of the phone number. The main page of the application will be based on an indexed view that contains the area and phone number for all customers. You need to return the area code from the PhoneNumber field. Solution: You run the following Transact-SQL statement:
The company's development team is designing a customer directory application. The application must list customers by the area code of their phone number. The area code is defined as the first three characters of the phone number. The main page of the application will be based on an indexed view that contains the area and phone number for all customers. You need to return the area code from the PhoneNumber field. Solution: You run the following Transact-SQL statement:
Does the solution meet the goal?
A. Yes B. No
Answer: B
QUESTION: 10
You query a database that includes two tables: Project and Task. The Project table includes the following columns:
You plan to run the following query to update tasks that are not yet started:
You need to return the total count of tasks that are impacted by this UPDATE operation, but are not associated with a project. What set of Transact-SQL statements should you run?
Answer: Pending. Please put your suggestions to [email protected]
QUESTION: 11
HOTSPOT
You query a database that includes two tables: Project and Task. The Project table includes the following columns:
QUESTION: 12
DRAG DROP
You query a database that includes two tables: Project and Task. The Project table includes the following columns:
Task level is defined using the following rules:
You need to determine the task level for each task in the hierarchy. Which five Transact-SQL segments should you use to develop the solution? To answer, move the appropriate Transact-SQL segments from the list of Transact-SQL segments to the answer area and arrange them in the correct order.
Answer: Exhibit
QUESTION: 13
DRAG DROP
You query a database that includes two tables: Project and Task. The Project table includes the following columns:
QUESTION: 14
DRAG DROP
You need to create a stored procedure that meets the following requirements:
- Produces a warning if the credit limit parameter is greater than 7,
- Propagates all unexpected errors to the calling process How should you complete the Transact-SQL statement? To answer, drag the appropriate Transact-SQP segments to the correct locations. Each Transact-SQL segments may be used once, more than once, or not at all. You may need to drag the split bar between panes or scroll to view content.
Answer: Exhibit
QUESTION: 15
HOTSPOT
You have the following stored procedure:
You run the following Transact-SQL statements:
What is the result of each Transact-SQL statement? To answer, select the appropriate options in the answer area.
Answer: Exhibit
QUESTION: 17
DRAG DROP
You need to create a stored procedure to update a table named Sales.Customers. The structure of the table is shown in the exhibit. (Click the exhibit button.)
The stored procedure must meet the following requirements:
- Accept two input parameters.
- Update the company name if the customer exists.
- Return a custom error message if the customer does not exist. Which five Transact-SQL segments should you use to develop the solution? To answer, move the appropriate Transact-SQL segments from the list of Transact-SQL segments to the answer area and arrange them in the correct order. NOTE: More than one order of answer choices is correct. You will receive credit for any of the correct orders you select.
Answer: Exhibit
