Which of the last names will be matched by the WHERE clause in the following query? SELECT empID from personnel WHERE lastName LIKE 'Jo_s' Select one: O a. O b. 'Jons' will be matched but Johns' and 'Johnson' will not be matched 'Jons' and 'Johns' will be matched but Johnson' will not be matched O c. 'Jons', 'Johns' and 'Johnson' will all be matched O d. None of these three last names will be matched

Which of the last names will be matched by the WHERE clause in the following query? SELECT empID from personnel WHERE lastName LIKE 'Jo_s' Select one: O a. O b. 'Jons' will be matched but Johns' and 'Johnson' will not be matched 'Jons' and 'Johns' will be matched but Johnson' will not be matched O c. 'Jons', 'Johns' and 'Johnson' will all be matched O d. None of these three last names will be matched

Database System Concepts

7th Edition

ISBN:9780078022159

Author:Abraham Silberschatz Professor, Henry F. Korth, S. Sudarshan

Publisher:Abraham Silberschatz Professor, Henry F. Korth, S. Sudarshan

Chapter1: Introduction

Section: Chapter Questions

Problem 1PE

See similar textbooks

Similar questions

Which of the following is true about the result of the following query?SELECT ID, NAME, EMAIL FROM CLIENT a. It has three rows of the CLIENT table. b. It has all rows with null ID, NAME, or EMAIL from the CLIENT table. c. It has three columns of the CLIENT table. d. It has all rows with non null ID, NAME, and EMAIL from the CLIENT table.
Do not use AI.
From 16 to 19
Which type of join is demonasted by the folloing query? Select from make. model where make modelID to mode ID a) Non-Equlion b) Self Join c) Cross Join d) Equijoin
What will be the result of the query based on the following criteria? <columnname> = ALL (<subquery>) Returns true if the value is equal to any value returned by the subquery. Returns true if the value is equal to every value returned by the subquery. Returns true if the value is not equal to any values returned by the subquery. Returns true if the value is not equal to any value returned by the subquery.
Which of the following is true about the result of the following query?SELECT ID, NAME, EMAIL FROM CLIENT a. It has three rows of the CLIENT table. b. It has all rows with null ID, NAME, or EMAIL from the CLIENT table. c. It has three columns of the CLIENT table. d. It has all rows with non null ID, NAME, and EMAIL from the CLIENT table.
Which type of constraint can be used to make certain the category for a book is included when a new book is added to inventory? ( refer to the tables in the JustLee Books database).
Task 3: The InstantRide Finance team wants to collect the price and discount information with the driver names for each travel in the system. You need to return the TRAVEL_ID, DRIVER_FIRST_NAME, DRIVER_LAST_NAME, TRAVEL_PRICE, and TRAVEL_DISCOUNT information from the TRAVELS and DRIVERS tables combined over DRIVER_ID field with the ON keyword. Task: Calculate each user's price and discount information. (SQL Database Test)
2. Create a SELECT statement that returns the ORDER_NUM and PROD_ID for all records in the ORDERITEMS table. Using inner joins include the vendor name, product name and customer name for each item.
Write a query on the Songs table to print Taylor Swift’s songs along with the name of the Artist.
Which one of the following SQL select statements will display a list of all vendors that do not yet have names entered in the vendor table? Question 8 options: 1) select vend_code, vend_name from vendor where vend_name IS NULL; 2) select vend_code, vend_name from vendor where vend_name IS NOT NULL; 3) select vend_code, vend_name from vendor where vend_name = NULL; 4) select vend_code, vend_name from vendor where vend_name = NOT NULL;