MTA Exam Questions with precise detailed solutions

MTA Exam Questions with precise |! |! |! |! |!




detailed solutions |!




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. - Correct answer ✔b. Add a
|! |! |! |! |! |! |! |! |! |! |! |! |! |!




reference to the web service in the application.
|! |! |! |! |! |! |!




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 - Correct answer ✔d. server-side
|! |! |! |! |! |!




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.
|! |! |! |! |! |! |! |! |!




- Correct answer ✔a. Enable business decisions by collecting, consolidating,
|! |! |! |! |! |! |! |! |! |! |!




and organizing data.
|! |!




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 - Correct answer ✔b. SQL
|! |! |! |! |! |! |!




SQL is a special-purpose programming language designed for managing data
|! |! |! |! |! |! |! |! |! |!




held in a relational database management system (RDBMS).
|! |! |! |! |! |! |!




Converting a value type to a reference type in an object is called? - Correct
|! |! |! |! |! |! |! |! |! |! |! |! |! |! |!




answer ✔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.
|! |! |! |! |! |! |! |! |! |!




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. - Correct answer ✔1. True
|! |! |! |! |! |! |! |! |! |! |! |! |!

, 2. True
|!




3. False
|!




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
|! |! |!