$CATEGORY: Exam09


::ITApps_Exam09_Q01::	Question 1: Joe and Helen have to name the database for their queen bee breeding program. The best filename from the list below is
{
~ file1.~
 databasefile1.~
 joeandHelen.=
 queenbreeding.
}


::ITApps_Exam09_Q02::	Question2: The most appropriate user documentation to help students working in classrooms send their work to a networked colour printer in the school library is
{
= onscreen help.~
 the colour printer manual.~
 an email to the IT technician.~
 a quick reference card on the colour printer.
}


::ITApps_Exam09_Q03::	Question 3: The Information Privacy Act 2000 applies to Victorian
{
~ advertisers using sports stars' images without permission.~
 doctors emailing patient records to a drug company without permission.~
 small businesses selling employee phone numbers to a telemarketing company.=
 local governments or councils selling employee details to a telemarketing company.
}


::ITApps_Exam09_Q04::	Question4: The design for a section of a spreadsheet shown above illustrates
{
= use of conventions.~
 testing techniques.~
 use of functions.~
 data validation.
}


::ITApps_Exam09_Q05::	Question 5: The best design tool for representing the relationships between pages in the wiki on a website is a
{
~ flow chart.~
 storyboard.=
 structure chart.~
 screen mock-up.
}


::ITApps_Exam09_Q06::	Question 6: A milestone
{
~ is shown as a circle in a Gantt chart.~
 is a task that has to be completed before the next task can begin.=
 indicates completion of a task that allows evaluation of the project to date.~
 occurs when a number of tasks are done simultaneously creating spare time.
}


::ITApps_Exam09_Q07::	Question 7: The formula to calculate the SubTotal Income for January is
{
~ SUM(B3:B5)~
 SUM(B3:B6)=
 \=SUM(B3:B5)~
 \=SUM(B3:B6)
}


::ITApps_Exam09_Q08::	Question 8: The Total amount of cash left to spend in February is most efficiently calculated in C14 by the formula
{
~ C6-C12=
 \=C6-C12~
 \=C3:C5-C9:11~
 \=C9+C10+C11-C3-C4-C5
}


::ITApps_Exam09_Q09::	Question 9 Typing the formula \=IF(D12<D6,"HOORAY"," ") in D13 returns
{
= HOORAY~
 NO MONEY LEFT OVER~
 " "~
 "HOORAY"
}


::ITApps_Exam09_Q10::	Question 10:Cell protection is most appropriate for all Column A and
{
~ B14:E14~
 B3:E5 and B9:E11~
 B6:E6 and B12:E12=
 B6:E6 and B12:E14
}


::ITApps_Exam09_Q11::	Question 11: In the one-to-many relationship between the Student table and the Print Job table
{
= one record in the Student table relates to many records in the Print Job table.~
 one field in the Student table relates to many records in the Print Job table.~
 one record in the Student table relates to many fields in the Print Job table.~
 one field in the Student table relates to many fields in the Print Job table.
}


::ITApps_Exam09_Q12::	Question 12: Below is a view of a section of the Student table. In this view of the Student table LastName is a
{
~ key.=
 field.~
 table.~
 record.
}


::ITApps_Exam09_Q13::	Question 13: Using a value list or drop-down list for YearLevel is an effective validation technique because
{
~ clicking an option is faster than typing it.~
 clicking an option is easier than typing it.~
 the options can be easily modified at any time.=
 it provides a list of options reducing data entry errors.
}


::ITApps_Exam09_Q14::	Question 14: John has designed a spreadsheet to provide quotes for lawn mower repairs. Which is the most appropriate criterion to evaluate the efficiency of the spreadsheet solution?
{
~ Is the information accurate?~
 Is the information up to date?=
 Does the spreadsheet provide quotes quickly?~
 Are the labels used for the headings relevant?
}


::ITApps_Exam09_Q15::	Question 15: Sam has to recommend a type of transmission media to support communication between two buildings 6 km apart. The most suitable media from the list below is
{
= microwave.~
 Bluetooth.~
 infrared.~
 Cat 5e.
}


::ITApps_Exam09_Q16::	Question 16: Workers for a telephone help line use a computer system to key in details as each caller describes their problem.The computer provides a prioritised list of suggestions the worker can use to help the caller. This is an example of
{
~ an information management system.~
 a transaction-processing system.~
 an office automation system.=
 a decision-support system.
}


::ITApps_Exam09_Q17::	Question 17: A task performed by a network operating system (NOS) includes
{
~ saving a file to a laptop hard drive.=
 authenticating users' access to the network printer.~
 changing the mouse click speed for a new user at a workstation.~
 displaying an alert when a flash drive is first plugged into a workstation.
}


::ITApps_Exam09_Q18::	Question 18: A costume warehouse sells its 200 products on an online website and uses database management software to create tables for the stock. Two products are shown below.
{
~ A.  =
 B.  ~
 C.  ~
 D.  
}


::ITApps_Exam09_Q19::	Question 19: The emergency plan within a disaster recovery strategy should include
{
~ evacuation procedures for backup files and a schedule for reinstalling software.~
 a schedule for reinstalling software and evacuation procedures for computers.=
 hardware shutdown procedures and evacuation procedures for backup files.~
 software supplier contact details and hardware shutdown procedures.
}


::ITApps_Exam09_Q20::	Question 20: Task X has 20 days duration and Task Y has 15 days duration. Task X is a predecessor of Task Y. Task Y cannot start until 10 days after Task X has finished.  If Tasks X and Y are on the critical path, the 10 days of delay for Task Y is called
{
= lag.~
 lead.~
 start to start time out.~
 finish to finish time out.
}