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