SQL WILDCARDS

Which of following SQL Wildcard represents zero or more characters in MS Access?

• _

• ?

• %

• *

Which of following SQL Wildcard represents a single character in MS Access?

• *

• ?

• !

• _

Which of following SQL Wildcard represents a single character in MS Access?

• [ ]

• *

• _

• $

Which of following SQL Wildcard represents a single numeric character in MS Access?

• *

• _

• #

• &

Which of following SQL Wildcard represents zero or more characters in SQL Server?

• %

• *

• ( )

• \

Which of following SQL Wildcard represents a single character in SQL Server?

• #

• $

• [ ]

• _

Which of following SQL Wildcard represents a single character in SQL Server?

• %

• _

• &

• #

Which operator allows you to specify multiple values in a WHILE clause?

• SELECT

• FROM

• IN

• SELECT DISTINCT

Which operator selects values within a given range?

• AND

• LIKE

• SELECT

• BETWEEN