Warning: count(): Parameter must be an array or an object that implements Countable in /var/www/html/live/searchResponsive.php on line 43
Warning: include(./views/auth.php): failed to open stream: Permission denied in /var/www/html/live/loginRightSlider.php on line 18
Warning: include(): Failed opening './views/auth.php' for inclusion (include_path='.:/usr/share/php') in /var/www/html/live/loginRightSlider.php on line 18
What does a query processor do in semantic checking?
A
Checks whether all the relations mentioned under the FROM clause in the SQL statement are from the database the user is referenced.
B
Checks all the attribute values and also checks whether they exist in a particular relation that is specified in the query. It checks all the attribute values that are mentioned in the SELECT and WHERE clauses of the SQL statement.
C
Verifies whether the types of attributes are compatible with the values used for the attributes.