MTA EXAM QUESTIONS WITH
COMPLETE SOLUTIONS
b. Add a reference to the web service in the application. - Correct Answers -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 Answers -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
Answers -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 Answers -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 Answers -Converting a
value type to a reference type in an object is called?
1. True
2. True
3. False - Correct Answers -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 Answers -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 Answers -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
COMPLETE SOLUTIONS
b. Add a reference to the web service in the application. - Correct Answers -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 Answers -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
Answers -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 Answers -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 Answers -Converting a
value type to a reference type in an object is called?
1. True
2. True
3. False - Correct Answers -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 Answers -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 Answers -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
