MTA Exam Questions with 100% Correct Answers 2022-23

b. Add a reference to the web service in the application. - Correct answer-How should you configure an application to consume a web service? a. Add the web service to the development computer. b. Add a reference to the web service in the application. c.Add a reference to the application in the web service. d.Add the web service code to the application. d. server-side - Correct answer-You are writing a web application that processes room reservation requests. You need to verify that the room that a guest has selected is not already reserved by another guest. Which type of programming should you use to determine whether the room is still available when the request is made? a. functional b. dynamic c. in-browser d. server-side a. Enable business decisions by collecting, consolidating, and organizing data. - Correct answer-A data warehouse database is designed to? a. Enable business decisions by collecting, consolidating, and organizing data. b. Support a large number of concurrent users. c. Support real-time business operations. d. Require validation of incoming data during real-time business transactions. b. SQL SQL is a special-purpose programming language designed for managing data held in a relational database management system (RDBMS). - Correct answer-Which language was designed for the primary purpose of querying data, modifying data, and managing databases in a Relational Database Management System? a. Java b. SQL c. C++ d. Visual Basic Boxing Boxing is an implicit conversion of a value types (C# reference) to an object type or to any interface type implemented by this value type. - Correct answer-Converting a value type to a reference type in an object is called? 1. True 2. True 3. False - Correct answer-True or False: 1. A queue's items are stored int he order they were added. 2. A queue is a first in, first out (FIFO) data structure. 3. A queue has a limited number of items. a. SELECT firstname, lastname, emailaddress FROM students ORDER BY lastname, firstname To sort use: ORDER BY lastname, firstname - Correct answer-In your student directory database, the students table contains the following fields: firstname lastname emailaddress telephonenumber You need to retrieve the data from the firstname, lastname, and emailaddress fields for all students listed in the directory. The results must be in alphabetical order according to lastname and then firstname. Which statement should you use? a. SELECT firstname, lastname, emailaddress FROM students ORDER BY lastname, firstname b. SELECT firstname, lastname, emailaddress FROM students SORT BY lastname, firstname c. SELECT firstname, lastname FROM students ORDER BY lastname, firstname, emailaddress d. SELECT firstname, lastname, emailaddress FROM students BY lastname, firstname c. console-based Building Console Applications Applications in the .NET Framework can use the System.Console class to read characters from and write characters to the console. Data from the console is read from the standard input stream, data to the console is written to the standard output stream, and error data to the console is written to the standard error output stream. - Correct answer-You plan to create an application for your company. The application will run automated routines and write the results to a text-based log file. Little or no user interaction is required. Security requirements on the host computers prevent you from running applications on startup, and users must be able to see the status easily on the screen. The host computers also have limited memory and monitors that display only two colors. These computers will have no network connectivity. Which type of application should you use for this environment? a. Directx b. Windows Service c. console-based d. Window Store app d. LocalService A LocalService runs in the context of an account that acts as a non-privileged user on the local computer, and presents anonymous credentials to any remote server. - Correct answer-You have a Windows Service running in the context of an account that acts as a nonprivileged user on the local computer. The account presents anonymous credentials to any remote server. What is the security context of the Windows Service? a. LocalSystem b. User c. NetworkService d. LocalService Execute code regardless of whether an exception is thrown. By using a finally block, you can clean up any resources that are allocated in a try block, and you can run code even if an exception occurs in the try block. Typically, the statements of a finally block run when control leaves a try statement. The transfer of control can occur as a result of normal execution, of execution of a break, continue, goto, or return statement, or of propagation of an exception out of the try statement. - Correct answer-The purpose of the Finally section in an exception handler is to? c. FROM d. SELECT e. WHERE Example: SELECT * FROM Customers WHERE Country = Mexico - Correct answerWhich three are valid SQL keywords? (Choose three) a. GET b. WHAT c. FROM d. SELECT e. WHERE a. String Need a string to store characters. - Correct answer-You are creating a variable for an application. You need to store data that has the following characteristics in this variable: -Consists of numbers and characters -Includes numbers that have decimal points Which data type should you use? a. String b. Float c. Char d. Decimal Requirements gathering, design, development, and testing - Correct answer-In which order do the typical phases of the Software Development Life Cycle occur? Internet Information Services By using the Internet Information Services (IIS) manager, you can create a local Web site for hosting an ASP.NET Web application. - Correct answer-Which service can host an ASP.NET application? a. in both the client-side code and the server-side code From version 2.0 on, ASP.NET recognized the JavaScript capabilities of these browsers, so client-side validation is now available to all modern browsers, including Opera, Firefox, and others. Support is even better now in ASP.NET 4.0. That said, its important not to forget that JavaScript can be disabled in any browser, so client-side validation cannot be relied uponwe must always validate any submitted data on the server. - Correct answer-You have a website that includes a form for usemame and password. You need to ensure that users enter their username and password. The validation must work in all browsers. Where should you put the validation control? a. in both the client-side code and the server-side code b. in the client-side code only c. in the Wg file d. in the server-side code only d. Queue A queue keeps the order of items in which they are entered. - Correct answer-You are creating an application for a help desk center. Calls must be handled in the same order in which they were received. Which data structure should you use? a. Binary tree b. Stack c. Hashtable d. Queue JavaScript JavaScript is characterized as a dynamic, weakly typed, prototype-based language with first-class functions. It is primarily used in the form of client-side JavaScript for the development of dynamic websites. - Correct answer-Which programming language is characterized as client-side, dynamic and weakly typed? b. SELECT firstName, lastName, telephoneNumber FROM Students - Correct answerYou are creating a database for a student directory. The Students table contains the following fields: -firstName -lastName -emailAddress -telephoneNumber Which statement will retrieve only the first name, last name, and telephone number for every student listed in the directory? Arguments are passed to console applications as a String Array object. - Correct answer-Arguments are passed to console applications as what? d. Establish a connection to the database by using the appropriate data provider. - Correct answer-Your application must pull data from a database that resides on a separate server. Which action must you perform before your application can retrieve the data? a. Configure the network routers to allow database connections. b. Install the database on each client computer. c. Create a routine that bypasses firewalls by using Windows Management Instrumentation (WMI).