Download MIS 3502 Final Quizzes Newest Edition 2025-2026. Questions & Correct Answers. Graded A and more Exams Software Engineering in PDF only on Docsity!
MIS 3502 Final Quizzes Newest Edition
2025-2026. Questions & Correct
Answers. Graded A
Consider the following line of code: let result = connection.query(txtSQL,[53]); Which of the following is true? If txtSQL holds a valid INSERT statement, then result.insertId will have the value of the primary key that was just created. If txtSQL holds a valid INSERT statement, then result.insertId will have the value 53. If txtSQL holds a valid SELECT statement, then result.insertId will have the value 53. If txtSQL holds a valid SELECT statement, then result.insertId will have the value of last primary key that was read. - ANSIf txtSQL holds a valid INSERT statement, then result.insertId will have the value of the primary key that was just created. Following the endpoint template we use in this class, where in your server- side code should students write the error trapping code? Routing function There is no error trapping on the server side. All the error trapping is done on the client. Supporting Function
Event Handler - ANSSupporting Function I just executed this line of code. The variable txtSQL holds a valid SQL INSERT statement. What is the best way to determine the primary key of the record I just created? let result = connection.query(txtSQL,["Moe","Howard"]); Issue a SELECT using "Moe" and "Howard" in the criteria. Use "ORDER BY" and "LIMIT" to identify the maximum primary key. Issue a SELECT using "Moe" and "Howard" in the criteria. Use a subselect to identify the maximum primary key. Look at the method result.insertId() Look at the attribute result.insertId - ANSLook at the attribute result.insertId I want to issue an HTTP POST to a third party API from within my AWS lamda code. Which of the following is true? You can use axios to do that. The axios library supports POST operations. You can't use axios to do that. The axios library only supports GET operations. You can use jQuery to do that. Use the $.ajax method in your lambda code.
In our endpoint template, we have three major sections of code: supporting functions, routing function, event handler. When processing an incoming HTTP request, what sequence do these operate it? event handler, routing function, supporting function event handler, supporting function, routing function routing function, supporting function, event handler routing function, event handler, supporting function supporting function, routing function, event handler - ANSevent handler, routing function, supporting function In our endpoint template, where are we most likely to report responses with a status code of 400? In the routing function In "catch" blocks In the event handler In error traps - ANSIn error traps In our endpoint template, where are we most likely to see error trapping and database operations?
routing function event handler supporting functions all of the above - ANSsupporting functions In our endpoint template, where do we see the res (response) object declared? supporting functions routing function none of the above event handler - ANSevent handler In the code sample below, what is "e" short for? try{ // some code here } catch(e){console.log(e); } encapsulation event handler expression encryption error - ANSerror In the following line of code, what is query?
In the online lecture we reviewed three different approaches to force asynchronous requests to execute in a specific order. One approach required us to update the DOM on the completion of each step. What were the other two approaches? (CHOOSE TWO) Use async / await commands Strategically place function calls inside of callback functions Specify "use strict" in your client-side JavaScript Use app.listen in AWS Lambda Put all sequential logic on the server side Put all sequential logic on the client side - ANSUse async / await commands Strategically place function calls inside of callback functions It is possible to write web services that all other web services. Can I use the jQuery $.ajax method in an AWS Lambda function to call another web service? Yes. The jQuery library can be used in AWS lambda functions. No. Use axios instead. No. Use $.getJSON instead. No. Use $.post instead - ANSNo. Use axios instead. Read the following definition: "A data construct that provides a description of something that may be used by a computer."
What is it a definition of? Library Object Protocol Framework Architectural style API - ANSObject Read the following definition: "A set of rules governing the exchange or transmission of data between devices." What is it a definition of? Architectural style Protocol Object Framework Library API - ANSProtocol Think of how .click() is used in client-side code. Like this: $("#button").click(function(){}); What is click? An attribute An object
It is part of JavaScript. It formats a general purpose response object. It is part of jQuery. It formats a response to be sent to the cloud. - ANSIt is part of the MIS3502 template. It formats a response to be sent to the client. What is the big difference between "Basic" and "Advanced" Web Service features as we have defined them in this class? Basic features may initiate a single SQL statement in response to a single request. Advanced features may initiate 2 or more SQL statements in response to a single request. Advanced features interact with a database using the sync-mysql connection object. Basic features do not. Basic features use "GET". Advanced features use other HTTP methods. Basic features expect data to be received as URL encoded data. Advanced features expect data to be received as JSON. - ANSBasic features may initiate a single SQL statement in response to a single request. Advanced features may initiate 2 or more SQL statements in response to a single request. What is the software architectural style that we have learned about all semester long? - ANSREST What jQuery event can be used to detect that an input tag has a new, changed value?
.change() .changed() .new() .input() .detect() .attr() - ANS.change() What statement best describes insertId as mentioned in the last question? insertId is an event of the result object insertId is either an event or a method of the result object insertId is an attribute of the result object insertId is a method of the result object - ANSinsertId is an attribute of the result object What term best describes the problem with Chuckle's approach in the last question? Gaslighting Composting Ghosting Lamp-post fallacy - ANSLamp-post fallacy What word can be placed in front of a jQuery ajax call to force it to behave synchronously?
The async and await commands are part of Axios. - ANSIf you define a function with async, you may use the await command inside the code block of the function.. Which of the following best describes Bootstrap? Library Architecture Framework Object - ANSFramework Which of the following best describes jQuery? Framework Library Object Architecture - ANSLibrary Which of the following is correct try / catch syntax? // Option A catch(e){ // response to error } // Option C try {
// code to try } catch(e){ // response to error } // Option B try(e) { // code to try } catch { // response to error } // Option D if ( expression ){ // code to try } catch(e){ // response to error } - ANS// Option C try { // code to try } catch(e){ // response to error } Which of the following is true about APIs? Some APIs are implemented over HTTP
PATCH
DELETE
POST - ANSGET
PUT
PATCH
DELETE
Which of the following methods transmit data in the query string? (CHECK AS MANY AS APPLY) PUT DELETE POST GET PATCH - ANSGET Which of the following portions of code is essentially a long list of conditional statements? Event Handler Client-Side Controller Routing function Supporting Function - ANSRouting function Which of the following portions of code will contain jQuery statements? Routing function
Client-Side Controller Supporting Function Event Handler - ANSClient-Side Controller Which, by its very nature, faster? Synchronous Code Execution Asynchronous Code Execution - ANSAsynchronous Code Execution You are at work and your colleague (let's call him "Chuckles") is very frustrated. He has been working with an AWS lambda function very similar to what you have used in class. All Chuckles needed to do was troubleshoot / debug one small feature using the AWS Lambda "Test" and "Deploy" buttons. Now, suddenly, mysteriously, none of the other features work. Most of those features were working. Now they have stopped. Chuckles has spent the last day making changes to his HTML and client- side JavaScript. You notice that, when you visit the endpoint URL of the API Gateway you get the response {"message": "Internal server error"} Which of the following seems like the best idea? Check your database schema Switch to Microsoft Azure Go back to the API gateway and enable CORS
