Solved

STUDENT
Observe the Table STUDENT:
STUDENT This Table Will Be Used for the Following Questions Citing

Question 8

Multiple Choice

STUDENT
Observe the table STUDENT:
STUDENT

 StudentID  SSN  Nane  Class D111111111111 Connor  Freshman D222222222121 Trevor  Freshman D333333333333 Connor  Sophomore D444444444444 Parker  Sophomore D555555555555 Connor  Sophomore \begin{array} { l c l l } \text { StudentID } & \text { SSN } & \text { Nane } & { \text { Class } } \\\hline D 111 & 111 - 11 - 1111 & \text { Connor } & \text { Freshman } \\D 222 & 222 - 22 - 2121 & \text { Trevor } & \text { Freshman } \\D 333 & 333 - 33 - 3333 & \text { Connor } & \text { Sophomore } \\D 444 & 444 - 44-4444 & \text { Parker } & \text { Sophomore } \\D 555 & 555 - 55 - 5555 & \text { Connor } & \text { Sophomore }\end{array}

This table will be used for the following questions citing table STUDENT.
-Which of the following queries on table STUDENT will return number 2 as a result?


A) SELECT COUNT(*) FROM student;
B) SELECT COUNT(name) FROM student;
C) SELECT COUNT(class) FROM student;
D) SELECT COUNT(DISTINCT class) FROM student;

Correct Answer:

verifed

Verified

Unlock this answer now
Get Access to more Verified Answers free of charge

Related Questions

Unlock this Answer For Free Now!

View this answer and more for free by performing one of the following actions

qr-code

Scan the QR code to install the App and get 2 free unlocks

upload documents

Unlock quizzes for free by uploading documents