Certiport Software Development #2 with
Complete Solutions
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Strict// EN"
"http://www.w3.org/TR/Xhtmll-strict.dtd">
<html xmIns="http://www.w3.org/1999/xhtml" lang="en" xml:lang="en">
<head>
<title>The Title</title>
</head>
<body>
<h1>This is a Heading.</h1>
<p>This is a paragraph</p><br>
</body>
</html>
What will cause an error?
A.) All tags are not uppercase
B.) The line break tag is incorrectly formatted - ANS-B.) The line break tag is incorrectly
formatted
A table named Student has columns named ID, Name, and Age. An index has been
created on the ID column.
What advantage does this index provide?
A.) It speeds up query execution.
B.) It reorders the records alphabetically. - ANS-A.) It speeds up query execution.
Class C and Class D inherit from Class B. Class B inherits from Class A.
The classes have the methods shown in the following table.
Class Method
A m1
B m2
C m3
D m4
A.) m1, m2, m3
B.) only m2, m3
C.) only m3, m4
D.) only m1, m3 - ANS-A.) m1, m2, m3
, Dim beakerFull As Boolean = Ture
Dim flameOn As Boolean = False
Dim iResult As Integer
Select Case beakerFull
Case True
Select Case flameOn
Case True
iResult = 1
Case True
iResult = 2
End Select
Case False
Select Case flameOn
Case False
iResult = 3
Case False
iResult = 3
End Select
End Select
What will the variable result be?
A.) 4
B.) 1
C.) 3
D.) 2 - ANS-D.) 2
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 - ANS-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.
Complete Solutions
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Strict// EN"
"http://www.w3.org/TR/Xhtmll-strict.dtd">
<html xmIns="http://www.w3.org/1999/xhtml" lang="en" xml:lang="en">
<head>
<title>The Title</title>
</head>
<body>
<h1>This is a Heading.</h1>
<p>This is a paragraph</p><br>
</body>
</html>
What will cause an error?
A.) All tags are not uppercase
B.) The line break tag is incorrectly formatted - ANS-B.) The line break tag is incorrectly
formatted
A table named Student has columns named ID, Name, and Age. An index has been
created on the ID column.
What advantage does this index provide?
A.) It speeds up query execution.
B.) It reorders the records alphabetically. - ANS-A.) It speeds up query execution.
Class C and Class D inherit from Class B. Class B inherits from Class A.
The classes have the methods shown in the following table.
Class Method
A m1
B m2
C m3
D m4
A.) m1, m2, m3
B.) only m2, m3
C.) only m3, m4
D.) only m1, m3 - ANS-A.) m1, m2, m3
, Dim beakerFull As Boolean = Ture
Dim flameOn As Boolean = False
Dim iResult As Integer
Select Case beakerFull
Case True
Select Case flameOn
Case True
iResult = 1
Case True
iResult = 2
End Select
Case False
Select Case flameOn
Case False
iResult = 3
Case False
iResult = 3
End Select
End Select
What will the variable result be?
A.) 4
B.) 1
C.) 3
D.) 2 - ANS-D.) 2
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 - ANS-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.
