IT Applications Practice Exam - 2013, 2012, 2011

1

A business with more than 100 employees tests its disaster recovery strategy by simulating a fi re and power failure. A criterion to evaluate the effectiveness of the strategy to protect the integrity of customer data would be to ask

1

When a medical clinic in country Victoria implements its new information system, the managers select and delete all the patient fi les from the hard disks before donating the old computers to the local primary school. In doing this, the managers have

1

The primary purpose of a proxy server is to

1

New employees use photocopy USER IDENTITIES from 999 to 1999. Test data to display an ‘INVALID USER IDENTITY’ message would be

1

Analysing the needs of an online community involves

1

Which one of the following is the best validation technique for the Country field?

1

A security protocol to protect the privacy of individuals entering their data on this form would be

1

What is the best data type for the box labelled ‘I have read and accept the conditions of purchase’?

1

The appearance of a website can be enhanced by having

1

Which one of the following would be a non-technical constraint on the design of a school’s new website?

1

Sunny Tennis Club is updating its website to attract new members. It is making decisions about what
information will be available for the general public (open) and what will be for members only (closed).
Which diagram represents the best decision for the club?

1

A solution developer wants to test the effi ciency of using the date convention of mm/dd/yyyy for an online
sales form to be used in a global market. He tracks the results of 100 users who were required to enter the
current date using this convention

1

A physical device that can help prevent unauthorised access to data and information on a network is

1

A local library wants to update its website so that new users can easily access the online catalogue.
The most suitable form of user documentation would be a

1

Evaluating a solution involves

1

When Old Time Gardeners decides to re-landscape a suburban parkland, it sets up a website so that local
residents can view each stage of the construction.
This type of online community is best described as

1

The primary key in the Movie table ensures that

1

The relationship the owner has created between the primary key in the Director table and the foreign key in
the Movie table is needed if fans using the website want to

1

In which position would PatientID be best represented?

1

What does position ‘y’ represent?

1

The stage of the problem-solving methodology where the solution requirements are determined is

1

The best electronic validation technique for ensuring that an online data entry form is complete is

1

The manager of a graphic art studio wants to use cloud computing instead of an external hard drive to store
image data. One criterion that can be used to evaluate the effectiveness of this decision would be to ask

1

The best design tool to show the structure of a database solution is

1

A relational database management system (RDBMS) developer is creating a new table within a database.
The most effi cient name and data type for a fi eld containing phone numbers, such as (03) 456 5667, is

1

A farmer has hired you to develop a new stock management solution.
During development, to ensure that the new solution does what it is intended to do, you should

1

A government school has decided to store all parents’ credit card information in a text fi le on the school’s
computer system.
The school has a legal obligation to change this information management strategy because

1

Barry received a three-monthly report showing that the number of complaints about orders being delivered to
the wrong addresses had increased. He decides that all stages of the order delivery process will be completely
computerised in three years.
Strategies for evaluating the new solution are best carried out

1

The best procedure to dispose of a data file and make it extremely diffi cult to retrieve is to

1

Drivers are insured for mountain track driving if they pass a special driving course (SDC), have a car with
roll bars (RB) and are without any convictions (C) for dangerous driving.
The design for a query to identify drivers who can receive insurance is

1

An operating system is designed to

1

A text box on a data entry form has this validation rule applied to it: 2999 < Postcode < 4000.
The most suitable data to test the rule is

1

A telecommunications company has more than 2000 employees across Australia with 24-hour access to the
company intranet. The human resource manager wants to make sure that employees can check their holiday
entitlements at any time.
The most effi cient method of achieving this would be to

1

The database table below shows the most popular songs during the decade 2000 to 2010, as voted by an
online music community in 2011. The query Artist = The Black Eyed Peas OR Year < 2009 will display records

1

A non-technical constraint on using company logos for promotions on a website is

1

Determining the scope of a solution includes

1

The efficiency of the information architecture of a website can be measured by

1

To protect the rights of individuals and organisations that are supplying data on a website, a host company is
legally required to include on its website a policy statement regarding

1

A complete disaster recovery strategy involves

1

Developing a prototype website involves

1

What are the three sub headings of Analysis in the Problem-Solving Methodology?

1

What are the two boxes that fall under the Design phase of the Problem-Solving Methodolgy?

1

What are the four activities listed during the Development stage of the Problem-Solving Methodology?

1

What are the two steps of Evaluation in the Problem-Solving Methodology?

1

Acronym for the steps of the Problem-Solving Methodology?

1

The four steps of the Problem-Solving Methodology are?

1

All are examples of Design Tools:

1

Define Efficiency?

1

Define Effectiveness?

IT Applications Multiple Choice Exam from years 2012, 2012, 2011

IT Applications Practice Exam - 2013, 2012, 2011

A business with more than 100 employees tests its disaster recovery strategy by simulating a fi re and power failure. A criterion to evaluate the effectiveness of the strategy to protect the integrity of customer data would be to ask

When a medical clinic in country Victoria implements its new information system, the managers select and delete all the patient fi les from the hard disks before donating the old computers to the local primary school. In doing this, the managers have

The primary purpose of a proxy server is to

New employees use photocopy USER IDENTITIES from 999 to 1999. Test data to display an ‘INVALID USER IDENTITY’ message would be

Analysing the needs of an online community involves

Which one of the following is the best validation technique for the Country field?

A security protocol to protect the privacy of individuals entering their data on this form would be

What is the best data type for the box labelled ‘I have read and accept the conditions of purchase’?

The appearance of a website can be enhanced by having

Which one of the following would be a non-technical constraint on the design of a school’s new website?

Sunny Tennis Club is updating its website to attract new members. It is making decisions about what information will be available for the general public (open) and what will be for members only (closed). Which diagram represents the best decision for the club?

A solution developer wants to test the effi ciency of using the date convention of mm/dd/yyyy for an online sales form to be used in a global market. He tracks the results of 100 users who were required to enter the current date using this convention

A physical device that can help prevent unauthorised access to data and information on a network is

A local library wants to update its website so that new users can easily access the online catalogue. The most suitable form of user documentation would be a

Evaluating a solution involves

When Old Time Gardeners decides to re-landscape a suburban parkland, it sets up a website so that local residents can view each stage of the construction. This type of online community is best described as

The primary key in the Movie table ensures that

The relationship the owner has created between the primary key in the Director table and the foreign key in the Movie table is needed if fans using the website want to

In which position would PatientID be best represented?

What does position ‘y’ represent?

Sunny Tennis Club is updating its website to attract new members. It is making decisions about what
information will be available for the general public (open) and what will be for members only (closed).
Which diagram represents the best decision for the club?

A solution developer wants to test the effi ciency of using the date convention of mm/dd/yyyy for an online
sales form to be used in a global market. He tracks the results of 100 users who were required to enter the
current date using this convention

A local library wants to update its website so that new users can easily access the online catalogue.
The most suitable form of user documentation would be a

When Old Time Gardeners decides to re-landscape a suburban parkland, it sets up a website so that local
residents can view each stage of the construction.
This type of online community is best described as

The relationship the owner has created between the primary key in the Director table and the foreign key in
the Movie table is needed if fans using the website want to

The manager of a graphic art studio wants to use cloud computing instead of an external hard drive to store
image data. One criterion that can be used to evaluate the effectiveness of this decision would be to ask

A relational database management system (RDBMS) developer is creating a new table within a database.
The most effi cient name and data type for a fi eld containing phone numbers, such as (03) 456 5667, is

A farmer has hired you to develop a new stock management solution.
During development, to ensure that the new solution does what it is intended to do, you should

A government school has decided to store all parents’ credit card information in a text fi le on the school’s
computer system.
The school has a legal obligation to change this information management strategy because

Drivers are insured for mountain track driving if they pass a special driving course (SDC), have a car with
roll bars (RB) and are without any convictions (C) for dangerous driving.
The design for a query to identify drivers who can receive insurance is

A text box on a data entry form has this validation rule applied to it: 2999 < Postcode < 4000.
The most suitable data to test the rule is

A telecommunications company has more than 2000 employees across Australia with 24-hour access to the
company intranet. The human resource manager wants to make sure that employees can check their holiday
entitlements at any time.
The most effi cient method of achieving this would be to

The database table below shows the most popular songs during the decade 2000 to 2010, as voted by an
online music community in 2011. The query Artist = The Black Eyed Peas OR Year < 2009 will display records