Homework Sourse1Write a sql statement to select all rows and columns from t
1-Write a sql statement to select all rows and columns from the table Customer:
2-Write a sql statement that returns the Customer’s ID number for those customer’s first name starts with “F”.
3- Write a sql statement to edit all existing records so that the field lastUpdated has today’s date in it within the table CustomerPurchases.
4-Write a sql statement to delete the customer record who’s ID is “12345” from the table Customer.
Q2) Fill in the blank:
1-______________ Responds to client requests (typically from a web browser) by providing resources such as HTML documents.
2-A web server and a client communicate using the platform-independent ______________________, a protocol for transferring requests and files over the Internet or an intranet.
3-For security reasons the path location is typically a ___________ directory which gets translated to a real location on the server, thus hiding the true location of the resource
4-A get request sends parameters ________, while a post request sends them in ________.
5-Cache means ____________________________________________
6-The three-tiers to a web application are _____________ , ______________, and ________________.
7-JavaScript code would be within the tier __________________.
8-SQL stored procedures would be within the tier _________________.
9-C# or Java web service code would be within the tier ___________________.
10-Server-side scripting ______________ to the client.
11-Localhost is the ______________ that always refers to the local computer.
12-SQL is ________________________
13-A relational database table consists of _______________ and ____________________.
14-One-to-many relationship means ___________________________________________________
___________________________________________________________________.
15-One-to-one relationship means ___________________________________________________
___________________________________________________________________.
16-The SQL keyword ASC means ______________________________________________.
17-The SQL keyword DESC means ______________________________________________.
18-A service is self-____________ , modular, interoperable, discoverable, and dynamically bound.
19-A ______________ is a software system designed to support interoperable machine-to- machine interaction over a network.
20-Three examples of should have web service security are using Authorization, Integrity of transactions and communications, and _______________________________________.
21-The ____________________ type of web service came before the REST (Representational State Transfer) web server.
22-Two Microsoft developed types of web services are ____________________ and ________________________.
Solution
Please find the answers below:
1) SELECT * FROM Customer;
2) SELECT customerID FROM Customer WHERE fname LIKE \'F%\' ; (Here % is a wildcard charecter to denote rest of the string)
3) UPDATE CustomerPurchases SET lastUpdated = GETDATE() (Here GETDATE() function will return todays date)
4) DELETE FROM Customer WHERE customerID = 12345
Q2)
1- Server Responds to client requests (typically from a web browser) by providing resources such as HTML documents.
2-A web server and a client communicate using the platform-independent Hyper Text Transfer Protocol (HTTP) , a protocol for transferring requests and files over the Internet or an intranet.
3-For security reasons the path location is typically a relative directory which gets translated to a real location on the server, thus hiding the true location of the resource
4-A get request sends parameters header, while a post request sends them in body.
5-Cache means a small temporary storage location used for faster access
6-The three-tiers to a web application are Presentation tier, Business logic tier, and Data storage tier .
7-JavaScript code would be within the tier Presentation tier.
8-SQL stored procedures would be within the tier Data storage tier
9-C# or Java web service code would be within the tier Business logic tier.
