To make a report that contains all information about each student who's full name or address contains 'K': O a. select * from students where concat(full_name concat(address)) like '%k%'; b. select *...

sql database multiple choice questions..

Extracted text: To make a report that contains all information about each student who's full name or address contains 'K': O a. select * from students where concat(full_name concat(address)) like '%k%'; b. select * from students where concat(full_name,address) like '%k%'; O c. select * from students where full_name or address like '%k%'; O d. select * from students where full_name and address like '%k%';


Extracted text: The query: select max(course_level) from courses join registration using(course_id); displays: O a. Makes error. O b. The maximum course level in table courses. O c. The maximum course level for the courses registered in table registration. O d. The maximum course_id in table registration.