1. Write a query to display the credit card number of Catherine Abel. (Use the AdventureWorks database)
Ans.
Ans.
2.Write a query to display EmployeeID of those employees who belong to the department, Tool Design. (Use the AdventureWorks database)
Ans.
3.Write a query to display EmployeeID of those employees who belong to the department, Tool Design. (Use the AdventureWorks database)
Ans.
4. Write a query to display the first name and the last name of the customers along with their credit card identification number. (Use the AdventureWorks database)
Ans.
5. Write a query to display CreditCardID, CardNumber, and ExpYear of the credit cards that do not expire in the year 2005 and 2007. (Use the AdventureWorks database)
Ans.
6. Write a query to display the sales person ID and the total number of sales orders processed by each sales person. In addition, display the commision earned by each sales person. Commision is given to each sales person at the rate of $ 10 per order. Exclude the orders where sales person ID is null. The details of the sales person who has got the maximum commision should be displayed first in the result set. (Use the AdventureWorks database)
7. Create a table named Recipient in the NarrowFabrics database to store the details of the recipients to whom the orders are dispatched. The following table provides the structure of the Recipient table.
8. NarrowFabrics, Inc. is a leading cloth manufacturing organization that manufactures and delivers clothes to the distributors. Being a database developer at NarrowFabrics, you need to create a database that will store the various database objects, such as tables, views, and indexes, used by the organization. Write the SQL statements that you can use to create a database named NarrowFabrics.
9. Create a table named Country in the NarrowFabrics database to store the country details. The following table provides the structure of the Country table.
10. LiveChain, Inc. is a leading media company that organizes events and provides photography services. After each event, the company stores the pictures taken in the event and delivers the pictures to the client on request. As a database developer, you have been assigned the task to create a database named PictureLibrary that the company can use to store the pictures.
11. John is working with Client Network Ltd as the Database Administrator. He wants to create a database to store the details of all the employees working in the organization. He needs to ensure that while saving, the data is placed in multiple file groups so that he is able to effectively manage the backup and restore operations. What should John do to perform this task?
12. You need to store the details of the offices in the central database, PictureLibrary. Write the SQL statement to create the OfficeLocation table in the PictureLibrary database. The following table shows the structure of the OfficeLocation table.
13. Write a query to make EmpDetail_FG as the default filegroup for the EmpDetail database.
No comments:
Post a Comment