70-761

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...

CORRECT TEXT You work for an organization that monitors seismic activity around volcanos. You have a table named GroundSensors. The table stored data collected from seismic sensors. It includes the columns describes in the following table: The database also contains a scalar value function named NearestMountain that returns the name...

You have a database named My Db. You run the following Transact-SQL statements: A value of 1 in the IsActive column indicates that a user is active. You need to create a count for active users in each role. If a role has no active users. You must display a...

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 ....

You have a database that contains tables named Customer_CRMSystem and Customer_ HRSystem. Both tables use the following structure: The tables include the following records: Customer_ CRMSystem Customer_ HRSystem Records that contain null values for CustomerCode can be uniquely identified by Customer Name. You need to display a Cartesian product, combining...

CORRECT TEXT You have a database that contains the following tables. You need to create a query that lists all complaints from the Complaints table, and the name of the person handling the complaints if a person is assigned. The ComplaintID must be displayed first, followed by the person name....

You have a database that contains tables named Customer_CRMSystem and Customer_ HRSystem. Both tables use the following structure: The tables include the following records: Customer_ CRMSystem Customer_ HRSystem Records that contain null values for CustomerCode can be uniquely identified by Customer Name. You need to display customers who appear in...

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...

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...

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...