Database

What is the correct order of data hierarchy from largest to smallest?

• Table > Database > Record > Field

• Database > Table > Field > Record

• Field > Record > Table > Database

• Database > Table > Record > Field

Which function should Mr. Wong use to arrange the students in order of their scores, from highest to lowest?

• Sorting

• Filtering

• Updating

• Inserting

Which field is the most suitable to be the primary key of OrderForm?

• OrderID

• CustomerID

• OrderDate

• Status

Consider the following SQL statement:

SELECT SID, SNAME, ALBUM FROM SONGS

Which field(s) does the SQL statement retrieve?

(1) SID

(2) SNAME

(3) ALBUM

(4) SONGS

• (1) and (2)

• (2), (3) and (4)

• (1), (2) and (3)

• All of the above

According to the following table ATTENDANCE,

What will be the output of the following SQL statement?

SELECT Class, ClassNo FROM ATTENDANCE WHERE Present = False

• 1A, 1

• 1A, 2

• 1B, 1

• 1C, 1

Which of the following is essential to a database table

(1) Primary key

(2) Input mask of each field

(3) Field name of each field

(4) Data type of each field

• (1) and (2) only

• (3) and (4) only

• (1), (2) and (3) only

• (1), (3) and (4) only

Which of the following values will be included in the output of the SQL statement:

SELECT AVG(HEIGHT) FROM STUDENT GROUP BY CNO

(1) 132

(2) 134

(3) 136

(4) 138

• (1), (2) and (3) only

• (1), (2) and (4) only

• (1), (3) and (4) only

• (2), (3) and (4) only

Given that each student can participate in more than one event, what is the primary key of PARTICIPANT?

• EventID

• StudentID

• EventID + Name

• EventID + StudentID