Certiport Software Development Exams 1–4 Questions and
Verified Answers– MTA/IT Specialist Certification Prep
(GUARANTEED PASS)
You are creating an application for computers that run Windows XP or
later. This application must run after the computer starts. The user must
not be aware that the application is running.
The application performs tasks that require permissions that the logged-
in user does not have.
Which type of application allows this behavior?
A.) Windows Forms application
B.) Windows Service application - VERIFIED ANSWER - B.) Windows Service
application
An application presents the user with a graphical interface. The interface
includes buttons that the user clicks to perform tasks. Each time the user
clicks a button, a method is called that corresponds to that button.
Which term is used to describe this programming model?
A.) structured
,B.) event driven - VERIFIED ANSWER - B.) event driven
What are two methods that can be used to evaluate the condition of a loop
at the start of each iteration? (Each correct answer presents a complete
solution. Choose two. )
A.) For
B.) While
C.) If
D.) Do...While - VERIFIED ANSWER - A.) For
B.) While
In the application life cycle, the revision of an application after it has been
deployed is referred to as:
A.)Monitoring
B.) Maintenance
C.) Integration
D.) Unit testing - VERIFIED ANSWER - B.) Maintenance
,You are creating a database for a student directory. 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.
A.) SELECT firstName, lastName, emailAddress FROM Students ORDER BY
lastName, firstName
B.) SELECT firstName, lastName, emailAddress FROM Students ORDER BY
lastName, firstName , emailAddress - VERIFIED ANSWER - A.) SELECT
firstName, lastName, emailAddress FROM Students ORDER BY lastName,
firstName
Which statement should you use to create the stored procedure?
A. CREATE PROCEDURE StoreData @UserName nvarchar(255)
, B. CREATE PROCEDURE StoreData @Age int
C. CREATE PROCEDURE StoreData @UserName nvarchar(255), @Age int -
VERIFIED ANSWER - C. CREATE PROCEDURE StoreData @UserName
nvarchar(255), @Age int
The ASP.NET MVC page lifecycle
The ______ event determines which action method is needed and then
calls that method. - VERIFIED ANSWER - Controller
The ASP.NET MVC page lifecycle
The URL pattern is matched during the ______ event. - VERIFIED ANSWER -
Route
Which type of Windows application presents a parent window that
contains child windows?
A.) Single-document interface (SDI)
B.) Multiple-document interface (MDI) - VERIFIED ANSWER - B.) Multiple-
document interface (MDI)
Verified Answers– MTA/IT Specialist Certification Prep
(GUARANTEED PASS)
You are creating an application for computers that run Windows XP or
later. This application must run after the computer starts. The user must
not be aware that the application is running.
The application performs tasks that require permissions that the logged-
in user does not have.
Which type of application allows this behavior?
A.) Windows Forms application
B.) Windows Service application - VERIFIED ANSWER - B.) Windows Service
application
An application presents the user with a graphical interface. The interface
includes buttons that the user clicks to perform tasks. Each time the user
clicks a button, a method is called that corresponds to that button.
Which term is used to describe this programming model?
A.) structured
,B.) event driven - VERIFIED ANSWER - B.) event driven
What are two methods that can be used to evaluate the condition of a loop
at the start of each iteration? (Each correct answer presents a complete
solution. Choose two. )
A.) For
B.) While
C.) If
D.) Do...While - VERIFIED ANSWER - A.) For
B.) While
In the application life cycle, the revision of an application after it has been
deployed is referred to as:
A.)Monitoring
B.) Maintenance
C.) Integration
D.) Unit testing - VERIFIED ANSWER - B.) Maintenance
,You are creating a database for a student directory. 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.
A.) SELECT firstName, lastName, emailAddress FROM Students ORDER BY
lastName, firstName
B.) SELECT firstName, lastName, emailAddress FROM Students ORDER BY
lastName, firstName , emailAddress - VERIFIED ANSWER - A.) SELECT
firstName, lastName, emailAddress FROM Students ORDER BY lastName,
firstName
Which statement should you use to create the stored procedure?
A. CREATE PROCEDURE StoreData @UserName nvarchar(255)
, B. CREATE PROCEDURE StoreData @Age int
C. CREATE PROCEDURE StoreData @UserName nvarchar(255), @Age int -
VERIFIED ANSWER - C. CREATE PROCEDURE StoreData @UserName
nvarchar(255), @Age int
The ASP.NET MVC page lifecycle
The ______ event determines which action method is needed and then
calls that method. - VERIFIED ANSWER - Controller
The ASP.NET MVC page lifecycle
The URL pattern is matched during the ______ event. - VERIFIED ANSWER -
Route
Which type of Windows application presents a parent window that
contains child windows?
A.) Single-document interface (SDI)
B.) Multiple-document interface (MDI) - VERIFIED ANSWER - B.) Multiple-
document interface (MDI)
