MC - Question 14 (1 Viewer)

[googy_1985]

Why isn't Question 14 A?

In the syllabus it says Select, From, Where and ORDER BY. There was NO order by, thus how can data be displayed?

 

[Morgues]

I always thought order by was optional........only if you want it sorted

 

[del]

agreed there

 

[Nelly]

You can tell that you dont need it because of question 15.

If you didnt need ORDER BY, then none of the answers in 15 are correct

 

[user]

by default, when no ORDER BY is stated, the DMBS or whatever does it will order the thing ASC. Technically, a complete SQL statement will have the ORDER BY bti whether it needs to be sorted ASC or DSC, but it will still work without the order by,

The only time ORDER BY is required is when you want to order it DESC.

 

[iptteacherssuck]

Originally posted by user
by default, when no ORDER BY is stated, the DMBS or whatever does it will order the thing ASC. Technically, a complete SQL statement will have the ORDER BY bti whether it needs to be sorted ASC or DSC, but it will still work without the order by,

The only time ORDER BY is required is when you want to order it DESC.

Technically, that's wrong!

The DMB will display it in the order it is stored on the disc not in ASC order of any kind.

If you have a clustered index on one of the fields , the field would be in asc order of that field. But that's essentailly what I said before. The DMB will display it in the order it is stored on the disc not in ASC order of any kind. Clustered Index, rearranges the way the records are stored so that they are in order .

 

[user]

According to the Heinemann book,
"the keyword ORDER BY sorts on a field in ascending (ASC) or descending (DEXC) order. Ascending order is the default and can be ommitted"


IPT isn't based on reality, it's based on what it says in the text book.

 

[Dario]

The SELECT command selects the fields that will be displayed as a result of the search.