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

Create a query for each of the following, save and print a copy: Books on a loan, using only BookID, title, author, and date taken. List of female readers who have at least loaned a book using only ReaderID, surname, first name, town, sex, book, title, and date taken. List of books that have been taken at least once and whose date of publication is before January 2013.
2. What will be the result of the query beosed on the following criteria ? All (< subquery])
Based on the given table. Customer ID Name Balance Payment 193 Chen 2100 300 584 Ravindran 5000 250 231 Bolt 300 20 608 Gomez 950 125 What values are returned while the given query is executed? SELECT 2* (Balance - Payment) FROM Customer; 3900, 9750, 590, 1775 3600 3600, 9500, 560, 1650
1. What will be the result of the query based. on the following criteria ?
Do not use AI
Not all Global Fast Foods staff members have a manager. Create a query that displays the employee last name and 9999 in the manager ID column for these employees.
Create a query to concatenate the street address so you print stadr followed by a comma and a space and then city followed by a comma and a space and then state followed by a space and then zip
The Colombia City office of StayWell indicated that there is a new tenant by the name of Yigit Yilmaz staying at the property with an ID of 13. You need to include this new resident in the RESIDENTS table.
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.
Q1. Please write a query statement from emp table to display ename, sal, and sal_star for all employees. Each astetrisk is signified by a one-hundred dollars. For example, Mary's sal is 1500, the sal_star data is 3 asterisks. Sort the data in an descending order of sal_star. Label the column headingto ENAME and SAL_STAR. The result should be like below: [image below] Material to answer the question above: Material: https://drive.google.com/file/d/14OwWDIybjAIeuHCO7McupV08gJs9nB-8/view?usp=sharing https://drive.google.com/file/d/1npRH8JoJ6GYBzPU3iNjLXluvCyhr2tMu/view?usp=sharing
From 16 to 19
Which statement about subqueries is true? a. A subquery filters the same way an inner join does. b. More than one column can be listed in the select statement in the subquery c. Columns from a table in a subquery can be referenced in the main select statement d. A subquery filters the same way an outer join does