Suppose there are 4 fields in a table named CUST customer id-05049
Suppose there are 4 fields in a table named CUST (customer_id, first_name, last_name, phone). Which of thefollowing gives all the information of the customers in the table whose last name is ALI?
This multiple choice question (MCQ) is related to the book/course vu cs403 Database Management Systems. It can also be found in vu cs403 Final Term - Quiz No.11.
Suppose there are 4 fields in a table named CUST (customer_id, first_name, last_name, phone). Which of thefollowing gives all the information of the customers in the table whose last name is ALI?
SELECT * FROM CUST WHERE last_name='ALI';
SELECT * FROM CUST WHERE last_name=ALI;
SELECT * FROM CUSTOMER WHERE name=ALI;
SELECT * FROM CUSTOMER WHERE last_name=ALI;