@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

+37 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

+42 votes

Best answer

0

@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?

+25 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.5k
- Engineering Mathematics 7.1k
- Digital Logic 2.7k
- Programming & DS 4.9k
- Algorithms 4.2k
- Theory of Computation 5.3k
- Compiler Design 2.1k
- Databases 4k
- CO & Architecture 3.5k
- Computer Networks 4k
- Non GATE 1.4k
- Others 1.5k
- Admissions 556
- Exam Queries 551
- Tier 1 Placement Questions 23
- Job Queries 69
- Projects 18

47,894 questions

52,261 answers

182,169 comments

67,679 users