Quiz
IT Applications Practice Exam - 2013, 2012, 2011
Crie uma conta grátis para terminar este quiz
Salve seu progresso e veja sua nota final.
Já tem uma conta? Inicie sessão
Perguntas do quiz (55)
1A 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
- Aare all back-up copies of customer records up-to-date and complete?
- Bcan the back-up copies of customer data be quickly accessed?
- Cis the customer data restored within 30 minutes of power returning?
- Dare all appropriate software companies contacted within 60 minutes?
2When 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
- Adone all that is required under the Health Records Act 2001.
- Bnot met their legal obligations under the Health Records Act 2001.
- Cprevented a threat to confidential data by unauthorised users.
- Dfollowed the correct procedure for the disposal of data under the Information Privacy Act 2000.
3The primary purpose of a proxy server is to
- Aconnect multiple devices together to act as a single network.
- Bforward data between computer networks.
- Ckeep an organisation’s network secure.
- Daccept requests from clients seeking resources from other servers.
4New employees use photocopy USER IDENTITIES from 999 to 1999. Test data to display an ‘INVALID USER IDENTITY’ message would be
- A998 and 2000
- B1000 and 1998
- C999 and 1999
- D999 and 1998
5Analysing the needs of an online community involves
- Adetermining what results are expected from test data.
- Bmonitoring users’ complaints about the existing system
- Cinterviewing community members to determine evaluation criteria.
- Dobserving the results of sample data used to test the new system
6Which one of the following is the best validation technique for the Country field?

- Aa range check
- Ban input mask
- Ca required fi eld
- Da dropdown box
7A security protocol to protect the privacy of individuals entering their data on this form would be

- Aencrypting all data before it is communicated.
- Bstating a shipping and returns policy
- Cbanning users who exceed their purchase limit.
- Daccepting orders only from customers who tick the acceptance box.
8What is the best data type for the box labelled ‘I have read and accept the conditions of purchase’?

- AImage
- BText
- CNumber
- DBoolean
9The appearance of a website can be enhanced by having
- Aconsistent font types.
- Bimportant information underlined
- Cminimum contrast between font and background colours.
- Dnavigation buttons of different sizes.
10Which one of the following would be a non-technical constraint on the design of a school’s new website?
- AIt must run on the existing classroom laptops
- BNew and existing fi le formats must be compatible
- CStudents’ examination results and attendance reports must be kept private.
- DThe size of video files used by teachers for online class presentations must be limited.
11Sunny 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?
- AA
- BB
- CC
- DD
12A 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- Ahow quickly each user enters the date.
- Bthe percentage of users who enter complete dates.
- Cthe number of users who accurately enter the current date.
- Dthe number of error messages received by users to indicate incorrect date order.
13A physical device that can help prevent unauthorised access to data and information on a network is
- Aa PIN.
- Ba swipe card.
- Ca thumb print.
- Dan encryption key
14A 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- Aquick start guide
- Btable of contents.
- Ctechnical manual
- DHelp Desk email contact
15Evaluating a solution involves
- Adetermining the evaluation criteria
- Btesting whether the solution does what it was intended to do
- Creporting on the extent to which the solution meets the requirements of the user
- Ddetermining what information the solution has to provide and what data is needed to produce it
16When 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- Asocial.
- Bcollaboration
- Cproject-based.
- Dknowledge-sharing.
17The primary key in the Movie table ensures that

- Aa movie has a unique identity.
- Ba director has a unique identity
- Ctwo directors cannot have the same LastName
- Da director cannot be credited with the wrong movie.
18The 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
- Asort the movies in order of release date.
- Bsearch for all directors born in the 20th century.
- Csort the directors’ last names in alphabetical order.
- Dsearch for movies in a particular language by a director.
19In which position would PatientID be best represented?

- Au
- Bv
- Cw
- Dz
20What does position ‘y’ represent?

- AMedicationID
- Bdoctor gives patient medication
- Cdoctor diagnoses patient’s condition
- Dname of medication given to patient
21The stage of the problem-solving methodology where the solution requirements are determined is
- Adesign.
- Banalysis.
- Cevaluation
- Ddevelopment.
22The best electronic validation technique for ensuring that an online data entry form is complete is
- Aa data type check.
- Ba data range check.
- Ca required field check.
- Dgraphic image recognition (CAPTCHA).
23The 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- Ais it cheaper to use the cloud than the external hard drive?
- Bis the upload time to the cloud faster than saving to the external hard drive?
- Cdo staff find it quicker to retrieve images from the cloud than from the external hard drive?
- Ddo the images have the same resolution when retrieved from the cloud as when retrieved from the
external hard drive?
24The best design tool to show the structure of a database solution is
- Aa site map.
- Ba mock-up of the input form.
- Can entity-relationship (ER) diagram
- Dan input-process-output (IPO) chart.
25A 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- Aname: cpn, data type: number
- Bname: custPn#, data type: text
- Cname: custPhNum, data type: text
- Dname: customer phone number, data type: number
26A 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- Aenter a lot of data to make sure the stock numbers are correct.
- Bread the quick start guide to make sure it is logical and efficient.
- Ccreate a set of evaluation criteria to judge if the requirements were met.
- Dcheck the system in three to six months to make sure it is working as intended.
27A 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- Aparents might get angry
- Bhuman error might occur when the credit card numbers are entered.
- Csensitive data should be stored safely and text files are too easily read.
- Dexpired credit cards may still be in the system, resulting in a lack of data integrity
28Barry 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- Aduring testing.
- Bas soon as the solution is in use.
- Cimmediately before the solution is in use.
- Dsix months after the solution has been in use.
29The best procedure to dispose of a data file and make it extremely diffi cult to retrieve is to
- Adelete it.
- Boverwrite it with specialty software
- Cmove it to the trash and empty the trash.
- Dencrypt it with licensed software and save it to the cloud.
30Drivers 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- AInsured = SDC or RB and C
- BInsured = SDC and RB and C
- CInsured = SDC or RB and not C
- DInsured = SDC and RB and not C
31An operating system is designed to
- Aprovide online help to new users
- Bmanage file access and application software.
- Cprovide user-friendly filenames for shared files
- Dencrypt fi les that are leaving and entering the network
32A 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- A3336, 3337, 3999
- B2050, 3050, 4050
- C2999, 4000, 4001
- D3000, 3999, 4050
33A 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- Aemail all employees whenever any entitlements change.
- Bupload new entitlement information to the home page on the company intranet.
- Csend new entitlement information to the relevant employees’ company mobile phones
- Dprovide each employee with a written copy of their entitlements whenever there is a change.
34The 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
- A5, 7
- B1, 5, 7
- C2, 3, 4, 6, 8, 9
- D2, 3, 4, 5, 6, 7, 8, 9
35A non-technical constraint on using company logos for promotions on a website is
- Abreach of copyright
- Bthe storage capacity of the server
- Cthe fi le format of the company logo
- Dthe data and fi le processing capabilities available to users.
36Determining the scope of a solution includes
- Aidentifying the functions the solution has to provide.
- Bdetermining what the solution can and cannot do.
- Cidentifying the constraints of the solution
- Dplanning the appearance of the solution.
37The efficiency of the information architecture of a website can be measured by
- Athe number of clicks required to get to the relevant information
- Bwhether all links go to relevant information
- Cthe number of different font colours used
- Dthe readability of the links.
38To 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- Ashipping and returns.
- Bhuman rights.
- Cprivacy.
- Dspam.
39A complete disaster recovery strategy involves
- Apreparing a backup plan for stored data and determining the cause of the disaster.
- Bpractising the procedures for shutting down the computer system and recovering data
- Cpurchasing preventative equipment and documenting the procedures for managing risk
to an organisation’s data. - Dundertaking a risk assessment, and documenting and practising the procedures for managing risk
to an organisation’s data and employees.
40Developing a prototype website involves
- Aconducting tests and recording results.
- Bdetermining what benefits the solution will bring to users.
- Cconsidering the constraints and conditions that need to be met.
- Ddeciding what measures will be used to judge whether or not the solution requirements have been met.
41What are the three sub headings of Analysis in the Problem-Solving Methodology?
- ASolution Analysis, Evaluation Criteria and Solution Design
- BSolution Requirements, Solution Constraints and Scope of Solution
- CReport, Strategy and Solution Documentation
- DSolution Design, Solution Documentation and Scope of Solution
42What are the two boxes that fall under the Design phase of the Problem-Solving Methodolgy?
- ASolution Design and Evaluation Criteria
- BAnalysis Solution and Validation Criteria
- CScope of Solution and Documentation
- DTesting and Solution Report
43What are the four activities listed during the Development stage of the Problem-Solving Methodology?
- AStrategy, Report, Solution and Validation
- BSolution Criteria, Evaluation Method, Scope of Solution and Testing
- CManipulation, Validation, Testing and Reporting
- DManipulation, Validation, Testing and Documentation
44What are the two steps of Evaluation in the Problem-Solving Methodology?
- AReport and Evaluation
- BValidation and Documentation
- CStrategy and Report
- DTesting and Documentation
45Acronym for the steps of the Problem-Solving Methodology?
- AADDR
- BADDD
- CEDDA
- DADDE
- EDDDA
- FDEDA
- GADED
46The four steps of the Problem-Solving Methodology are?
- AAnalysis, Design, Development and Evaluation
- BAnalysis, Design, Development and Documentation
- CDesign, Development, Documentation and Requirements
- DDesign, Discussion, Documentation and Evaluation
47All are examples of Design Tools:
- AFlowcharts, Layout Diagrams, Site Maps and Excel Spreadsheet
- BStoryboards, Hierarchy charts, Flowcharts and User Documentation
- COnline Tutorial, User Documentation, Context Diagrams and Flowcharts
- DEntity-Relationship Diagram, Flowcharts, Storyboards and Layout Diagrams
48Define Efficiency?
- AHow little time, cost and/or effort is applied/required to achieve intended results
- BA measure of how well something works - Attractiveness, clarity, accuracy, communication, relevance, etc
- CA way in which information should be treated and organised on screen
- DHow well information abides by the legal obligations set
49Define Effectiveness?
- AA measure of how well something works - Attractiveness, clarity, accuracy, communication, relevance, etc
- BHow well information abides by the legal obligations set.
- CA way in which information should be treated and organised on screen
- DHow little time, cost and/or effort is applied/required to achieve intended results
50Privacy Act _____
- A2001
- B1988
- C2003
- D1968
51Information Privacy Act ______
- A1998
- B2003
- C2001
- D2000
52Health Records Act _______
- A2001
- B2003
- C2000
- D1999
53Spam Act __________
- A2001
- B1988
- C1998
- D2003
54Copyright Act ______
- A1986
- B1968
- C1998
- D1996
55Charter of Human Rights and Responsibilities _______
- A2006
- B2003
- C2000
- D2001
Informações
- Descrição
- IT Applications Multiple Choice Exam from years 2012, 2012, 2011
- Autor
- Nicholas Bagnall
- Idioma
- English
- Visualizações
- 375
- Etiquetas
- Avaliação
- 3,0 de 5 · 1 avaliação Avalie este quiz