DBMS online test, online practice test, exam, quiz
Online Practice Test
1. In semantic checking , query processor
Checks whether all the relations mentioned under the FROM clause in the SQL statement are from the database the user is referenced.
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.
Verifies whether the types of attributes are compatible with the values used for the attributes.
All of these.
View Answer and Discussion