For like predicate which of the following is true. i) % matches zero of more characters. ii) _ matches exactly one character.

Related MCQs

•                                    is a sequence of zero or more characters enclosed by single quotes.
• The predicate in a where clause can involve Boolean operations such as and. The result of true and unknown is               false and unknown is            while unknown and unknown is            
• Which character function can be used to return a specified portion of a character string?
• An entity in A is associated with at most one entity in B. An entity in B, however, can be associated with any number (zero or more) of entities in A.
• Which of the following consists of a row of column headings, together with zero or more rows of data values?
• The              clause allows us to select only those rows in the result relation of the           clause that satisfy a specified predicate.
• The        condition allows a general predicate over the relations being joined.
•                                allows a system administrator to associate a function with a relation; the function returns a predicate that must be added to any query that uses the relation.
• The____condition allows a general predicate over the relations being joined.
• Consider the employee work-team example, and assume that certain employees participate in more than one work team. A given employee may therefore appear in more than one of the team entity sets that are lower level entity sets of employee. Thus, the generalization is