| Number |
Question |
Before |
After |
Diff |
| 1 |
Fred and his team built an information system for a client. They
know the information system is incomplete and unstable, yet they were willing
to show this working model to the client in order to elicit feedback. What
type of information system is this? |
69% |
87% |
17% |
| 2 |
What’s the blueprint of a database? |
19% |
100% |
81% |
| 3 |
Which one of the following techniques is to used to generate
managerial reports? |
18% |
47% |
29% |
| 4 |
Which one of the following techniques is used to find the hidden
relationships between data entities? |
77% |
93% |
16% |
| 5 |
The referential integrity rule requires that _________. |
46% |
73% |
28% |
| 6 |
When you create a new entity to represent a multi-valued
attribute in a DBMS, what is the relationship between the original entity and
the new one? |
41% |
67% |
26% |
| 7 |
Assume that an Employee table has three attributes (columns)
-Employee_ID (primary key), Employee_Name and Employee_Department_ID. Which of the following SQL aggregate
functions would be used with GROUP BY EMPLOYEE_DEPARTMENT_ID in a command to
calculate the total number of employees in each department? |
19% |
36% |
17% |
| 8 |
Vanessa is working on a systems development project when she
comes to you and says, "Hey, my boss just told me I needed to do some
conceptual modeling, but he didn't tell me why. Do you know what modeling is
good for?" Which of the following answers is correct? |
57% |
93% |
36% |
| 9 |
Why is it a good thing to prioritize the goals of a system's
user interface? |
51% |
71% |
21% |
| 10 |
What is the value of intPositive when the following statements
are executed? (read ";" as line break) &LF;Const intNumber As
Integer = 10;&LF;Select Case intNumber;&LF; Case 1, 3, 5, 7,
9;&LF; intPositive = intNumber;&LF; Case 2, 4, 6, 8,
10;&LF; intPositive = intNumber + 1 * 2;&LF; Case Is >
10;&LF; intPositive = intNumber * 2 + 1;&LF; Case
Else;&LF; intPositive = 0;&LF; End Select; |
37% |
50% |
13% |
| 11 |
Your web browser is an example of ___ software; the web site you
visit with your browser is running on a type of ____ software. |
38% |
93% |
55% |
| 12 |
A typical transaction processing system has to be able to do
which of the following? |
79% |
80% |
1% |
| 13 |
What term is defined as: “An interrelated set of components
working together toward a common goal by accepting input and processing it
into output?” |
59% |
100% |
41% |
| 14 |
Jay Adams has a new telephone number and you need to update his
information. When you run the file to update Jay Adams’s telephone number,
this error message appears: Directory Object not found. The file is displayed
in the following format: Dn: ou=Jay Adams,ou=sales,dc=cohowinery,dc=com;
changetype: modify; replace: telephoneNumber; telephoneNumber:
602-555-4321&LF;You must find the error with this file and correct it.
Which part of the file is causing the error? |
29% |
40% |
11% |
| 15 |
In an internet, different individual networks are connected by
__________. |
63% |
67% |
4% |
| 16 |
In Windows Server 2003, the main repository for information
about network users and resources is called: |
33% |
80% |
47% |
| 17 |
Sensitive messages to and from the customer in e-commerce
dialogues usually are protected by __________. |
33% |
73% |
40% |
| 18 |
This statement is like a chain of If statements. They perform
their test, one after the other, until one of them is found to be true. |
37% |
87% |
49% |
| 19 |
The ________ loop is ideal for situations that require a counter
because it is specifically designed to initialize, test, and increment a
counter variable. |
27% |
33% |
6% |
| 20 |
What is an argument? |
37% |
87% |
49% |
| 21 |
The syntax of a code statement that changes the properties of a
control at run time is in the form of ________. |
29% |
80% |
51% |
| 22 |
The actions an object can perform are called ______, while those
recognized by an object are ______. |
11% |
27% |
16% |
| 23 |
An individual item can be deleted from a list box with the_____. |
24% |
93% |
69% |
| 24 |
You are managing databases for a long distance phone company.
One of these databases is used to temporarily hold millions of phone call
records. After the billing processes are finished, you have to delete certain
records from the tables, and you need to use your system disk resources
conservatively. How would you create the database and what kind of settings
would you use? |
24% |
57% |
33% |
| 25 |
You are designing a logical model to collect information about
the composition of fragrances for perfumeries. This model will be used to
create a database containing the recipes for different fragrances, and the
percentages of each ingredient in the fragrance recipe will need to be
tracked. You design an entity called PerfumeComposition and an entity called
Ingredient. The percentage of each ingredient in a particular perfume will be
stored in the PerfumeComposition table, one row for each ingredient. You want
to ensure that the sum of the ingredient percentages for a perfume does not
exceed 100. How can you accomplish this? |
43% |
36% |
-8% |
| 26 |
You are creating a model of employees in a large international
company. Each country provides a government-generated number given to every
person authorized to work. Other information contained in the employee entity
would be family name, given name, phone number, and address. Which of the
following is the best choice to uniquely identify each employee? |
30% |
53% |
24% |
| 27 |
You are creating a database to track music compositions
submitted for copyright to a large international copyright company.
Copyrights might be acquired for every composition submitted, but a
particular composer can submit only one composition of the same name at any
time. You create a composer entity with a composer ID for the primary key.
You also create a composition entity. Which of the following provides the
best logical primary key for each row in the composition entity? |
35% |
33% |
-2% |
| 28 |
You are designing a logical model to track airline flights. In
your system, an airplane is owned by one airline, and a flight would always
be flown by one airplane. You create the following
entities:&LF;• Airplane&LF;• Flight&LF;• Airline.&LF;In the
following sentence diagrams, the arrows indicate a one-to-many relationship.
Which of the following diagrams describes the relationship between these
three entities that meets the scenario requirements? |
42% |
53% |
12% |
| 29 |
A computer on your network with an unregistered IP address is
unable to access a specific Internet Web site. After reproducing the problem
on the computer several times, you try the same task on another computer
connected to the same LAN and find that you can access the Web site. You then
ping the Web server from the second computer to determine the Web site's IP
address and try to connect from the malfunctioning computer by using the Web
site's address instead of the server name. You can connect successfully using
the IP address. Which of the following TCP/IP configuration parameters on the
malfunctioning computer is probably incorrect? |
30% |
7% |
-23% |
| 30 |
You are designing an Internet access solution for an accounting
firm whose workers require constant access to Web sites and e-mail during
business hours. The company also maintains a Web site that receives heavy
traffic from clients. The company works extremely long hours during tax
season, which runs from January through April, but drops back to a standard
eight-hour work day after April 15. Which of the following wide, area
networking (WAN) technologies would provide the most flexible bandwidth
service for this network? |
17% |
7% |
-10% |
| 31 |
You are designing a new TCP/IP network and you request a Class B
network address from your ISP. The ISP gives you the following address:
131.107.0.0/16. You want to be able to create as many as 50 subnets of 1,000
hosts each on your new network, so you decide to allocate 6 bits to be used
as the subnet identifier. Which of the following subnet masks should you use
for the computers on your network? |
40% |
40% |
0% |
| 32 |
You are developing an accounting application that includes a
class named Transaction. Subclasses such as DepositTransaction and
PaymentTransaction inherit from the Transaction class. The Transaction class
includes a method named VerifyChecksum that should be available to the
Transaction class and to all classes derived from the Transaction class, but
not to any other classes in the application. Which access modifier should you
use in the declaration of the VerifyChecksum method? |
50% |
36% |
-14% |
| 33 |
You are planning to display invoices on a DataGrid control. The
user will specify a customer, and then you'll retrieve from the database all
the invoices for that customer. Which database object should you use to
retrieve these invoices? |
19% |
7% |
-12% |
| 34 |
Your application's main form contains two Button controls named
btnA and btnB. When the user clicks on either of these controls, or when the
user moves the mouse over either of these controls, you want to run code to
display a message on the form. The message is identical in all cases. How
should you structure your code to fulfill this requirement? |
15% |
47% |
31% |
| 35 |
Which of the following event categories should you audit if you
want to find out if an unauthorized person is trying to access a user account
by entering random passwords or by using password-cracking software? |
54% |
93% |
39% |
| 36 |
Which Microsoft Management Console (MMC) allows you to create
and manipulate Active Directory organizational units (OUs)? |
35% |
67% |
32% |
| 37 |
The total length of an IP address is __________ bits. |
9% |
87% |
78% |
| 38 |
In digital certificate authentication, the applicant performs a
calculation using their: |
36% |
7% |
-30% |
| 39 |
You are the network administrator of the Baldwin Museum of
Science. The company network has a single Active Directory domain named
baldwinmuseumofscience.com. All domain controllers run Windows Server 2003,
Standard Edition. The domain functional level is Windows 2000 native. Server
operators and administrators can log on interactively. Relevant group
memberships are configured as shown in the following table. Group Member
Domain Adminstrators: Kevin; Enterprise Adminstrators: Liz, Imtiaz; Schema
Adminstrators: Karan, Tengiz; Server Operators: Jim, Shane, Lab Aides; Domain
Users Tim, Russell; Lab Aides: Debra, Kendall. No modifications to the
default user rights have been made to the Domain Controllers organizational
unit (OU). Which users would not be able to log on interactively at the
domain controllers? |
31% |
27% |
-4% |
| 40 |
You are designing a Windows From that will work like a splash
screen, giving the welcome message and product information when the
application starts. What properties would you set on the form to make it look
like a splash screen? |
30% |
47% |
17% |
| 41 |
You are designing a Windows application with a variety of
controls on its user interface. Some controls will be infrequently used. For
those controls, you do not want the user to be able to tab into the control,
but the user should still be able to activate the control by clicking it.
Which of the following options should you use? |
30% |
73% |
44% |
| 42 |
Where should code statements be placed that are to be carried
out at run time when the form is moved into memory? |
37% |
73% |
36% |
| 43 |
In the context of OOP, each tool in the toolbox is _______, a pattern from which one or more
objects are created. |
24% |
47% |
22% |
| 44 |
Which property controls the text displayed in the form’s title
bar? |
23% |
20% |
-3% |
| 45 |
What is the data type of the return value in the function in the
snippet of code below? &LF;Private Function Max(decValue1 As Decimal,
sngValue2 As Single) As Integer |
36% |
100% |
64% |
| 46 |
You can cause events to occur at a set interval using the Timer
component and its ____________. |
19% |
73% |
55% |
| 47 |
In the following line of code, frmEdit is the _____, Caption is
the _______, and Edit is the ______.&LF; frmEdit.Caption = “Edit” |
23% |
53% |
30% |
| 48 |
What is the value of strName(1,0) after the following
declaration is initialized?&LF;Dim strName( , ) as String =
("James", "Mary")("Sammie", "Sean”) |
19% |
60% |
41% |
| 51 |
Which required course are you taking now? Mark only the highest
number. |
ISDS 3100 Average |
ISDS 4125 Average |
|
| |
Total |
35% |
60% |
25% |
|
|
|
|
|