Question: Q1, Consider table T1 with following data: a1 a2 a3 1 2 3 1 2 3 1 NULL NULL 1 NULL NULL how many rows

Q1, Consider table T1 with following data: a1 a2 a3 1 2 3 1 2 3 1 NULL NULL 1 NULL NULL how many rows will be retrieved by the following SQL statement? select count(*) from T1 where ((a3 = 3) OR (a2 <> 2));

1. 4

2. 2

3. 0

4. 1

Q2. What truth value will be returned by SQL for the expression NOT (a OR (NOT a)). Assume that column a has NOT NULL constraint.

1. True

2. False

3..Unknown

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Databases Questions!