Full Stack Software Engineer Interview Questions

1,663 full stack software engineer interview questions shared by candidates

Consider these 3 tables that map hotels to a single city each: Table 1: costcotravel_ys003_DZ_Hotel - Id (numeric primary key) - Name (string) Table 2: costcotravel_ys003_DZ_Hotel_Mapping_to_City - Id (numeric primary key) - Hotel_Id (numeric foreign key to hotel table) - City_Id (numeric primary key to city table) Table 3: costcotravel_ys003_DZ_City - Id (numeric primary key) - Code (3-letter city airport code) - Name (full name of city) Please write a script to create a stored procedure that takes as its input these variables: CityCode: exactly 3 characters (but optionally empty) HotelName: Up to 100 characters and produces the following output fields: HotelName (the name of the hotel) CityName (the full name of the city) for records that (1) contain the HotelName input anywhere inside the name of the hotel and (2) if a non-empty CityCode value is supplied, then also match exactly on city code.
avatar

Full Stack Software Engineer

Interviewed at Costco Wholesale

3.9
Jul 16, 2024

Consider these 3 tables that map hotels to a single city each: Table 1: costcotravel_ys003_DZ_Hotel - Id (numeric primary key) - Name (string) Table 2: costcotravel_ys003_DZ_Hotel_Mapping_to_City - Id (numeric primary key) - Hotel_Id (numeric foreign key to hotel table) - City_Id (numeric primary key to city table) Table 3: costcotravel_ys003_DZ_City - Id (numeric primary key) - Code (3-letter city airport code) - Name (full name of city) Please write a script to create a stored procedure that takes as its input these variables: CityCode: exactly 3 characters (but optionally empty) HotelName: Up to 100 characters and produces the following output fields: HotelName (the name of the hotel) CityName (the full name of the city) for records that (1) contain the HotelName input anywhere inside the name of the hotel and (2) if a non-empty CityCode value is supplied, then also match exactly on city code.

You own a small online store, consisting of its own site and a bunch of products presented on it. Your task is to retrieve all the products that are currently contained in the store using the provided REST API. The current site contains the products represented by the following fields: id?- the unique identifier of the product (integer); name?- the name of the product (string); updated_at?- timestamp of the last product update (integer); price?- the price of the product (positive integer); manufacturer?(optional) - the name of the manufacturer. This field is optional, and if it is not presented, then the product is considered to be produced locally, by yourself. To obtain information about the current products from the site, you are given an?API endpoint. Use HTTP requests to obtain information about the current products from this endpoint. API information The API is served at?http://127.0.0.1:8081?and supports the only endpoint: A GET request of the form?http://127.0.0.1:8081/products This endpoint returns a JSON array, containing a list of JSON objects representing the information about the product with the fields described above. For example, the response for this endpoint may look like: [ { "id": 1, "name": "ProductName", "updated_at": 150000000, "price": 100, "manufacturer": "ManufacturerCompanyName" }, { "id": 3, "name": "ProductName 2", "updated_at": 150000230, "price": 90 } ] Your task is to request an API endpoint and print the information of all the products in the following format: Product has price and no manufacturer if product has no manufacturer field, and Product has price and manufacturer otherwise. The information about the products should be returned in the same order as the products were returned in response.
avatar

Full Stack Software Engineer

Interviewed at Costco Wholesale

3.9
Jul 16, 2024

You own a small online store, consisting of its own site and a bunch of products presented on it. Your task is to retrieve all the products that are currently contained in the store using the provided REST API. The current site contains the products represented by the following fields: id?- the unique identifier of the product (integer); name?- the name of the product (string); updated_at?- timestamp of the last product update (integer); price?- the price of the product (positive integer); manufacturer?(optional) - the name of the manufacturer. This field is optional, and if it is not presented, then the product is considered to be produced locally, by yourself. To obtain information about the current products from the site, you are given an?API endpoint. Use HTTP requests to obtain information about the current products from this endpoint. API information The API is served at?http://127.0.0.1:8081?and supports the only endpoint: A GET request of the form?http://127.0.0.1:8081/products This endpoint returns a JSON array, containing a list of JSON objects representing the information about the product with the fields described above. For example, the response for this endpoint may look like: [ { "id": 1, "name": "ProductName", "updated_at": 150000000, "price": 100, "manufacturer": "ManufacturerCompanyName" }, { "id": 3, "name": "ProductName 2", "updated_at": 150000230, "price": 90 } ] Your task is to request an API endpoint and print the information of all the products in the following format: Product has price and no manufacturer if product has no manufacturer field, and Product has price and manufacturer otherwise. The information about the products should be returned in the same order as the products were returned in response.

Viewing 1441 - 1450 interview questions

See Interview Questions for Similar Jobs

Glassdoor has 1,663 interview questions and reports from Full stack software engineer interviews. Prepare for your interview. Get hired. Love your job.