Advanced RegExp Functions

1. In a regular expression, what does the `^` symbol indicate?

• a. Start of the string

• b. End of the string

• c. Any single character

• d. Zero or more characters

2. What is the purpose of the `[]` brackets in a regular expression?

• a. Grouping expressions

• b. Denoting a character class

• c. Representing optional characters

• d. Signifying the end of a string

3. Which operator is used for alternation in a regular expression?

• a. &&

• b. ||

• c. |

• d. /

4. What does the `\d` pattern represent in a SQL regular expression?

• a. Any digit

• b. Any whitespace character

• c. Any letter

• d. Any special character

5. What does the `*` symbol indicate in a regular expression?

• a. One or more characters

• b. Zero or more characters

• c. Any single character

• d. End of the string

6. What does the '?' symbol represent in a regular expression?

• a. One or more characters

• b. Any single character

• c. End of the string

• d. Zero or one character

7. What is the purpose of the '{n}' syntax in a regular expression?

• a. Match exactly n characters

• b. Match at least n characters

• c. Match zero or more characters

• d. Match one or more characters

8. What does the `\w` pattern represent in a SQL regular expression?

• a. Any word character

• b. Any whitespace character

• c. Any digit

• d. Any special character

9. Which pattern does not support in Bigquery?

• a. \n

• b. (?: )

• c. (?=)

• d. $

10. What does the non-capturing group regex pattern look like?

• a. (?:pattern)

• b. (|pattern)

• c. (?pattern)

• d. {pattern}