Question Completion Status: Team opponent Run For RunsAgainst Dragons Tigers 5 3

Question

Question Completion Status: Team opponent Run For RunsAgainst Dragons Tigers 5 3 Swallows Bay Stars Giants Marines Hawks 6 Ham Fighters Buffaloes Golden Eagles 8 12 Lions 3 5 Tigers ragons Swallows Carp 2 Giants Bay Stars, Hawks Marines 6 1 Buffaloes Ham Fighters Golden Eagles Lions 12 What is the result of executing the following query on this data? SELECT Team, Opponent FROM Scores WHERE Team LIKE OR opponent LIKE i%; Identify, in the list below, a row of the result. O a Carp Swallows O b Bay Stars O c Marines Hawks d Lions Golden Eagles

Explanation / Answer

Q.1)

  The LIKE operator is used in a WHERE clause to search for a specified pattern in a column.

Here where team LIKE '% %' OR opponent LIKE '_i%';

means it returns a tuple in which team contains a space between words or a tuple in which opponent contains the 2nd letter having i character.

Here the result would be:

Dragons Tigers

Bay Stars Giants

Ham Fighters Buffaloes

Golden Eagles Lions

So the answer is b. Bay Stars and Gaints.

Q 2.)The condition would be c should be greater than 5 or b should be less than 5.

So the answer would be d.(5 5 6).Since 6 is greater than 5.So as c is descending first (5 5 6) will come and then (5 5 5).

Related Questions

Navigate

• Browse (All)
• Browse Q
• Subjects

---

---

Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.