Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Some rows of a User table are shown below: User ucode name phone scode 7 Alex 8 4 7 - 3 9 0 2 UX

Some rows of a User table are shown below:
User
ucode
name
phone
scode
7
Alex
847-3902
UX
8
Tony
203-3902
PX
9
Charles
BD
11
Mary
877-3333
BD
Which of the following queries retrieves the rows where there is no phone?
Group of answer choices
SELECT * FROM User WHERE phone =
SELECT * FROM User WHERE phone NOT IS NULL
SELECT * FROM User WHERE phone IS NULL
SELECT * FROM User WHERE phone >0

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Nested Relations And Complex Objects In Databases Lncs 361

Authors: Serge Abiteboul ,Patrick C. Fischer ,Hans-Jorg Schek

1st Edition

3540511717, 978-3540511717

More Books

Students also viewed these Databases questions

Question

(1 point) Calculate 3 sin x cos x dx.

Answered: 1 week ago

Question

5. If yes, then why?

Answered: 1 week ago

Question

6. How would you design your ideal position?

Answered: 1 week ago