H DDD - Database wildcards (revision)

Which of the following strings satisfies the condition 'T_'? (There can be more than one answer) 

• TW

• TWITTER

• TAIWAN

• TO

Which of the following strings satisfies the condition 'A_B%'? (There can be more than one answer)

• AKKB

• AKBKKK

• ABKK

• ABBB

Which of the following strings satisfies the condition 'Z%K_R'? (There can be more than one answer)

• ZKRR

• ZYKR

• ZRKKJ

• ZABCDEFKGR

Complete the condition below which would return productNames which end with the letters on. Don't forget the quotation marks!

productName LIKE

Complete the condition below which would return productNames which start with the letter S. Don't forget the quotation marks!

productName LIKE

Complete the condition below which would return productNames which contain the pattern ill. Don't forget the quotation marks!

productName LIKE

Complete the condition below which would return productNames which contain the letters o and n (in that order) with exactly one letter between them. Don't forget the quotation marks!

productName LIKE

Which of the following SQL statement is valid?

• SELECT firstName, lastName

  FROM Sales

  WHERE firstName LIKE 'A%' lastName LIKE 'W%'; 

• SELECT firstName, lastName

  FROM Sales

  WHERE firstName LIKE 'J%' AND lastName LIKE 'W%'; 

• SELECT firstName, lastName

  FROM Sales

  firstName LIKE 'J%' AND lastName LIKE 'W%'; 

• SELECT firstName, lastName

  FROM Sales

  WHERE firstName LIKE 'J%', lastName LIKE 'W%';

How many records will be returned by the following query? (Assuming the database is not case sensitive) 

 

SELECT *

FROM Sales

WHERE firstName LIKE '%a%'

OR lastName LIKE '%e%';

• 1

• 4

• 2

• 5

How many records will be returned by the following query? (Assuming the database is not case sensitive) 

 

SELECT *

FROM Sales

WHERE lastName LIKE '%l_e%';

• 1

• 4

• 2

• 5