Information Processes and Technology 2004 Independent Trial Exam-Multiple Choice (1 Viewer)

SamD

Member
Joined
Jul 21, 2002
Messages
256
Gender
Male
HSC
N/A
Lwaxana said:

in fact he might have even been there the day the examiners wrote that Qu 15 which I think is very hard considering the coverage that topic gets in the text books.

:)
Actually I wrote the question... and its covered in my IPT Prelim text (and will be in my IPT HSC text when I finish the damn thing!)

HTH
Sam

P.S. * waves back *
 
Joined
Feb 7, 2005
Messages
665
Location
Sydney
Gender
Male
HSC
2005
SamD said:
Actually I wrote the question... and its covered in my IPT Prelim text (and will be in my IPT HSC text when I finish the damn thing!)

HTH
Sam

P.S. * waves back *

Are you gonna make an A4 Sized book, or a small phat one like ur SDD,

I prefer the Bigger A4 sized.
 

melsc

Premium Member
Joined
Aug 17, 2004
Messages
6,365
Location
Chasing ambulances in the Inner West...
Gender
Female
HSC
2005
1. C
2. C
3. D
4. C (answer is B)
5. C (answer is B)
6. C
7. B
8. A
9. A
10. D
11. D
12. C
13. B
14. B
18. B
19. C
20. B

I got 15/17 I think, my mistakes are from communications...I know which area I need to brush up on...

I dont like question 15 it is evil

SamD said:
In regard to Q5...

Confusion often arises because many routers for home use include switches but the packaging still calls it a router.

HTH
Sam
I recently installed my own wireless router...that's why I thought it was a router LOL...Now I know...thanks for clearing that up :)
 
Last edited:

drewgcn

postpantsism
Joined
Jun 23, 2004
Messages
337
Location
Oatley...land of oats.
Gender
Male
HSC
2006
Whaoh, this is the trial hsc exam we got last year (except I'm fairly sure the teachers changed the answers to the bit/baud rate question to something considerably simpler). Ah memories.
 

crono

Member
Joined
Aug 24, 2003
Messages
31
Gender
Male
HSC
2005
shouldnt the answer for 13 be D). If im wrong can anyone explain the right answer to me. thnx
 

SamD

Member
Joined
Jul 21, 2002
Messages
256
Gender
Male
HSC
N/A
13. The following SQL command has been executed and 100 records are displayed.
SELECT Surname, FirstName FROM Customers ORDER BY DOB
Which of the following is NOT true?
(A) There are 100 records in the Customers table.
(B) The records are now stored in order of DOB
(C) Only the Surname and FirstName of each customer is displayed.
(D) The contents of the displayed fields can be edited.
The answer is B.

Notice the question asks for the statement which is NOT true.

A. is true, as there is no WHERE clause, hence all records are retrieved.
B. is false, because executing an SQL statement does not alter the order in which the records are STORED.
C. is true, as these are the only two fields specified in the SELECT clause.
D. is true, as the fields are retrieved from a single table, hence each row of the result must represent part of a single record and therefore there is no reason that they can't be edited.

HTH
Sam
 
Last edited:

Users Who Are Viewing This Thread (Users: 0, Guests: 1)

Top