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