Solved

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

Question 1

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.
-How many records will the following query on table STUDENT return?
SELECT * FROM student WHERE name LIKE '%or%';


A) 0
B) 2
C) 3
D) 4

Correct Answer:

verifed

Verified

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