Which of the following is the correct option for the given query?
Posted: Thu Jul 14, 2022 8:53 am
SELECT DISTINCT name
FROM RDBMS
WHERE ID IS NOT NULL;
a) The query gives all the possible RDBMS names where a finite value exists for ID
b) The query gives the RDBMS names where a finite value exists for ID and it excludes identical names
c) The query gives the names of the RDBMS that have a null ID and it also excludes identical names
d) The query is syntactically wrong
FROM RDBMS
WHERE ID IS NOT NULL;
a) The query gives all the possible RDBMS names where a finite value exists for ID
b) The query gives the RDBMS names where a finite value exists for ID and it excludes identical names
c) The query gives the names of the RDBMS that have a null ID and it also excludes identical names
d) The query is syntactically wrong