You have a table that contains an XML column named XMLData1. The column contains the following nodes: • Title • Description • Author • Weight • NumPages You need to design a stored procedure that will return only the title…
You work in an International company named TAKEEEN. And you’re in charge of the database of your company. You intend to use SQL Server 2008 to create a database solution. A database will contain 10 tables that are used to…
You plan to implement a Web-based application that will save XML data to a column in a table. You need to design a query that ensures that before saving the XML data to the table, the data contains valid elements.…
You are a database developer. You plan to create a database by using SQL Server 2008. The database has a table named Employees. The table contains records of employees and their managers. The table includes the EmployeelD and ManagerlD fields.…
You plan to deploy a new application. The application will perform the following operations: • Create a new database • Back up the new database You need to configure a login to support the deployment of the new application. The…
You need to design a database solution that meets the following requirements: • Supports different types of databases • Provides reliable messaging between databases • Provides data workload distribution across several databases Which SQL Server component should you use? A.…
You are a database developer. You plan to design a database solution by using SQL Server 2008. You have a Web site supported by a database that has the full-text search component installed. You plan to create a table named…
A database contains two tables named Tablel and Tablel_Details. Tablel_Details contains details about the items in Tablel. You need to ensure that when an item is removed from Tablel, all related items are removed from Tablel_Details. You must achieve this…
You are a database developer. You design a database solution by using SQL Server 2008. There’s a query which is used very often. You notice that this query executes quite slow. This query often uses full-table scans while not indexes.…
You are a database developer. You design a database solution by using SQL Server 2008. Your company has offices in Europe, Asia, North America, and Africa. The company data is updated for each region after business hours. The queries used…