@amarVashishth can oyu please explain me the options given, Like i am not able relate between null and x=5. Where does comparision with null comes in picture?

The Gateway to Computer Science Excellence

First time here? Checkout the FAQ!

x

+30 votes

In SQL, relations can contain null values, and comparisons with null values are treated as unknown. Suppose all comparisons with a null value are treated as false. Which of the following pairs is not equivalent?

- $x = 5 \quad not (not (x = 5))$
- $x = 5 \quad x > 4$ and $x < 6,$ where $x$ is an integer
- $x ≠ 5 \quad not (x = 5)$
- none of the above

+35 votes

Best answer

+1

@amarVashishth can oyu please explain me the options given, Like i am not able relate between null and x=5. Where does comparision with null comes in picture?

+24 votes

0

option (b)

NULL=5 False

x>4 and x<6 where x is an integer

Please explain how this evaluates to false

NULL=5 False

x>4 and x<6 where x is an integer

Please explain how this evaluates to false

- All categories
- General Aptitude 1.2k
- Engineering Mathematics 5k
- Digital Logic 2k
- Programming & DS 3.6k
- Algorithms 3.1k
- Theory of Computation 3.9k
- Compiler Design 1.5k
- Databases 2.9k
- CO & Architecture 2.5k
- Computer Networks 2.9k
- Non GATE 1k
- Others 1.4k
- Admissions 412
- Exam Queries 419
- Tier 1 Placement Questions 17
- Job Queries 55
- Projects 9

34,943 questions

41,959 answers

119,194 comments

41,472 users