Evaluate the following SQL statement:SQL> SELECT cust_id. cust_last_name FROM customersWHERE cust_credit_limit IN -(sele

Business, Finance, Economics, Accounting, Operations Management, Computer Science, Electrical Engineering, Mechanical Engineering, Civil Engineering, Chemical Engineering, Algebra, Precalculus, Statistics and Probabilty, Advanced Math, Physics, Chemistry, Biology, Nursing, Psychology, Certifications, Tests, Prep, and more.
Post Reply
answerhappygod
Site Admin
Posts: 899559
Joined: Mon Aug 02, 2021 8:13 am

Evaluate the following SQL statement:SQL> SELECT cust_id. cust_last_name FROM customersWHERE cust_credit_limit IN -(sele

Post by answerhappygod »

Evaluate the following SQL statement:SQL> SELECT cust_id. cust_last_name FROM customersWHERE cust_credit_limit IN -(select cust_credit_limitFROM customers -WHERE cust_city='Singapore'):Which statement is true regarding the above query if one of the values generated by the sub query is NULL?

A. It produces an error.
B. It executes but returns no rows.
C. It generates output for NULL as well as the other values produced by the sub query.
D. It ignores the NULL value and generates output for the other values produced by the sub query.
Join a community of subject matter experts. Register for FREE to view solutions, replies, and use search function. Request answer by replying!

This question has been solved and has 1 reply.

You must be registered to view answers and replies in this topic. Registration is free.


Register Login
 
Post Reply