Query processor in semantic checking - Database

Q.  What does a query processor do in semantic checking?
- Published on 28 Aug 15

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.
d. All of these.

ANSWER: All of these.

Post your comment / Share knowledge


Enter the code shown above:
 
(Note: If you cannot read the numbers in the above image, reload the page to generate a new one.)