MTA Practice Exam Questions and Answers

MTA Practice Exam Questions and Answers

1. 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.: b. Add a reference to the web service in the application. 2. 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: d. server-side 3. 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 transac- tions.: a. Enable business decisions by collecting, consolidating, and organizing data. 4. 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: b. SQL SQL is a special-purpose programming language designed for managing data held in a relational database management system (RDBMS). 5. Converting a value type to a reference type in an object is called?: 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. 6. 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.: 1. True 2. True 3. False 7. 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?