Database Administration Questions

LIKE is a keyword that is used in the WHERE clause. Basically, LIKE allows us to do a search based operation on a pattern rather than specifying exactly what is desired (as in IN) or spell out a range (as in BETWEEN).

The syntax is as follows:
SELECT "column_name"
FROM "table_name"
WHERE "column_name" LIKE {PATTERN}

{PATTERN} often consists of wildcards.

In SQL, there are two wildcards:


% (percent sign) represents zero, one, or more characters.

_ (underscore) represents exactly one character.

More :: Certification Questions on SQL

The given letter equation implies that 11 P in a CT means 11 Players in a Cricket Team.

Java is a general-purpose computer-programming language that is concurrent, class-based, object-oriented, and specifically designed to have as few implementation dependencies as possible.

Java is used to develop mobile apps, web apps, desktop apps, games and much more...

Here the relation between the given words is that the second word is the collection of the first word.

As the collection of grains is called Stock, similarly, the collection of sticks is called as Bundle.

Hence, Grain : Stock :: Stick : Bundle.