1. Select the make_name, vehicle_id, and model_name of all vehicles, regardless of whether they are on the lot or not (is in inventory or not), which have a first production year of 1987. 2. Select the make_name, vehicle_id, and model_name of all vehicles with the color name "Sky Blue" and which are on the lot. 3. Select the make_name, model_name and incentive amount for all vehicles on the lot with an incentive type "dealer". 4. Convert the following query to relational algebra SELECT Player. id, Team. name, City. name FROM Player INNER JOIN Team ON Player. team_id = Team. id INNER JOIN City ON Team. city_id = City. id WHERE Player. score = 100;

Avariable definition defines the name of a variable that will be used in a program, as well as

Write a program that inserts the digits of an integer into an array in originalorderfollowed by reverse order. first, promptthe user to enter a positive integer(> 0). determine the number of digits of the integer. create a dynamically allocated integer arrayof a size twice the number of digits. now insert the digits in original order which will occupy half of the array. then, insert the digits in reverse order. finally, output thedigits in thearray. use at least two functions to organize your program.

You have been supporting csm tech publishing's windows server 2016 server network for over a year. the office has two windows server 2016 servers running active directory and a number of other roles. management has informed you that a small sales office is opening in the same building three floors up. the sales manager wants to install a sales application on a server located in the sales office. this server will have limited physical security because there's no special room dedicated for it, which means it will be accessible to non-it personnel and visitors. you're considering installing windows server 2016 server core on the new server because accessing its console regularly probably won't be necessary, and this server will be managed from one of the other csm tech publishing servers. what are the benefits and drawbacks of using server core for this branch office? what are some things you should do to set up this server management environment?