MTA EXAM QUESTIONS AND
ANSWERS 100% SOLVED
b. Add a reference to the web service in the application. - ANSWERHow 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 - ANSWERYou 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
Requirements gathering, design, development, and testing - ANSWERIn 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. - ANSWERWhich service can host an
ASP.NET application?
When you change the focus by using the mouse or by calling the Focus method,
focus events of the Control class occur in the following order: Enter GotFocus
,LostFocus Leave Validating Validated - ANSWERYou are creating an application
that presents the user with a Windows Form.
Which event is triggered each time the Windows Form receives focus?
Yes
No
No - ANSWERYou have a base class named Tree with a friend property named
color and a protected
property named NumberOfLeaves. In the same project, you also have a class
named
Person.
Yes or no, Methods in the Person class can access the color property
Yes or no, Methods in the Person class can access the NumberOfLeaves properties
Yes or no, Methods in the Tree class can access all private properties in Person
FormClosing
a. Enable business decisions by collecting, consolidating, and organizing data. -
ANSWERA 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). - ANSWERWhich 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. - ANSWERConverting a value
type to a reference type in an object is called?
1. True
2. True
3. False - ANSWERTrue 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 - ANSWERIn 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
ANSWERS 100% SOLVED
b. Add a reference to the web service in the application. - ANSWERHow 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 - ANSWERYou 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
Requirements gathering, design, development, and testing - ANSWERIn 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. - ANSWERWhich service can host an
ASP.NET application?
When you change the focus by using the mouse or by calling the Focus method,
focus events of the Control class occur in the following order: Enter GotFocus
,LostFocus Leave Validating Validated - ANSWERYou are creating an application
that presents the user with a Windows Form.
Which event is triggered each time the Windows Form receives focus?
Yes
No
No - ANSWERYou have a base class named Tree with a friend property named
color and a protected
property named NumberOfLeaves. In the same project, you also have a class
named
Person.
Yes or no, Methods in the Person class can access the color property
Yes or no, Methods in the Person class can access the NumberOfLeaves properties
Yes or no, Methods in the Tree class can access all private properties in Person
FormClosing
a. Enable business decisions by collecting, consolidating, and organizing data. -
ANSWERA 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). - ANSWERWhich 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. - ANSWERConverting a value
type to a reference type in an object is called?
1. True
2. True
3. False - ANSWERTrue 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 - ANSWERIn 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
