[ACT247H1] - Final Exam Guide - Everything you need to know! (72 pages long)

In a small study, 12 women with cervical cancer (cancer of the cervix) and 12 women with no apparent cervical cancer were contacted and asked whether they had ever used the hormone estrogen as a drug. Each woman with cancer was matched by age, race, and weight with a woman without the disease. This is an example of:

a) A randomized controlled trial

b)A prospective cohort study

c) A case-control study

d) A retrospective cohort study

(a) With the aid of a practical example (two tables), explain the SQL 
statement below:
SELECT FIRST_NAME, LAST_NAME, SCHOOL_FEE4
FROM STUDENT, FEE_PAYMENT
WHERE STUDENT.STUDENT_ID = FEE_PAYMENT.STUDENT_ID
ORDER BY FIRST_NAME AP(5)
(b)Using the following passwords “ABCefg12” and “KojoGiggs12” as 
examples, discuss the strengths and weaknesses of each password and 
discuss what could be done to strengthen them, if they are weak 
passwords. AN(8)
(c) Assuming your exam answer booklet for this course in the end of 
semester exams is flagged (indicated) by your antivirus as being infected 
with a virus but you have just about 5 hours to submit/upload your 
answer booklet to lemsas.net. Discuss what you would do to avoid not 
submitting your answer booklet and thereby not failing the course.

a.A sinewave has a period (duration of one cycle) of 645 μs. What is the corresponding frequency of this sinewave, in kHz, expressed to 3 significant figures? (See Study Note 7.1 in the ‘Using Numbers (maths)’ booklet.)

A (i) If the frequency of the sinewave is now reduced by a factor of 3.5, what will be the new period value? Express your answer in ms, to 3 significant figures.

Note: In the second part of this question, to avoid rounding errors in your calculations, use the full frequency value from the first part, not the rounded value to 3 significant figures.