Which of the following query would display all the students where the second letter in the first name is "i"? Select one: O a. select first_name from students where first_name like '_i O b. select first_name from students where first_name like '%i%'; O c. select first_name from students where first_name like '_i%'; O d. select first_name from students where first_name like '%i_';

Which of the following query would display all the students where the second letter in the first name is "i"? Select one: O a. select first_name from students where first_name like '_i O b. select first_name from students where first_name like '%i%'; O c. select first_name from students where first_name like '_i%'; O d. select first_name from students where first_name like '%i_';

Oracle 12c: SQL

3rd Edition

ISBN:9781305251038

Author:Joan Casteel

Publisher:Joan Casteel

Chapter10: Selected Single-row Functions

Section: Chapter Questions

Problem 17MC

See similar textbooks

Similar questions

1. What will be the result of the query based. on the following criteria ?
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.
In the below given query, which expression is evaluated first? SELECT id_number, (quantity – 100 / 0.15 – 35 * 20) FROM inventory a) 0.15-35 b) quantity – 100 c) 35*20 d) 100 / 0.15
2. What will be the result of the query beosed on the following criteria ? All (< subquery])
Which line of the SELECT statement is used to restrict groups displayed in the query results? 1. SELECT customer#, COUNT(*)2. FROM customers JOIN orders USING(customer#)3. WHERE orderdate > '02-APR-09'4. GROUP BY customer#5. HAVING COUNT(*) > 2;
Please help with the following: Which of the following queries returns data about students whose Names begin with the letter ’r’ ? Select one: a. SELECT * FROM Students WHERE Name Like ’r%%’; b. all of the above c. SELECT * FROM Students WHERE Name Like ’r_ ’; d. SELECT * FROM Students WHERE Name Like ’r’;
Orderltem OrderlD item quantity 1 Fahita 1 Menu 1 Pepsi Item type price 1 Shawarma Соса Drink 1.5 1 Water Fahita Sandwich 2 Coca 3 Pepsi Drink 1.5 2 Steak 3 Shawarma Sandwich 3 Fahita Steak Plate 10 Steak 2 Water Drink 1 water 1 The query that gives the price of the Steak' Select one: All the answers are correct Select price from orderitem where item='Steak Select price from menu where item='Steak Select price from menu where item=steak Consider the table called STATION (ID, CITY, STATE, LAT_N, LONG W); few rows are inserted to the table STATION: ID CITY STATE LAT_N LONG W 13 Phoenix AZ 33 112 44 Denver CO 40 105 66 Caribou МЕ 47 68 ID CITY STATE LAT_N LONG_W Which query gives the the following table : 44 Denver CO 40 105 66 Caribou ME 47 68 Select one: O a SELECT * FROM STATION WHERE LAT_N > 39.7; O b. SELECT city,ID WHERE LAT_N > 39.7; SELECT * FROM STATION WHERE LAT_N > 40; O d. None of these
The Home_ column stores a patient's home phone number. Which of the following could be used to filter a query to only patients that have a home phone number listed? A. HOME_PHONE IS NULL B. HOME_PHONE <> NULL C. HOME_PHONE IS NOT NULL D. HOME_PHONE = NULL
6) Which query will output the table contents when the value of C_PRICE is not equal to 777? a. SELECT C_MAKE, C DATE, C_PRICE FROM Cars WHERE V_PRICE = 777; b. SELECT C MAKE, C DATE, C PRICE FROM Cars WHERE C PRICE 777;
a) Which one of the following queries finds sailors who havereserved at least a boat but not a red boat? Query1:SELECT R.sidFROM Boats B, Reserves RWHERE B.bid=R.bid AND B.color<>’red’ Query2:SELECT R.sidFROM Reserves REXCEPTSELECT R.sidFROM Boats B, Reserves RWHERE B.bid=R.bid AND B.color=’red’ b) What are the results of query1 and query2 in part A,considering the following instances of Sailors and Reserves tables? (images attached)
Create a query based on tblEmployee and tblPurchase using the Find Unmatched Query Wizard that lists the EmployeelDFirstName, and LastName of any employee who has not yet made a sale. Save the query as qryEmployeeNoSales and then close the query
SELECT emp_name FROM department WHERE dept_name LIKE ' [A]Computer Science'; In the above-given Query, which of the following can be placed in the Query's blank portion to select the "dept_name" that also contains Computer Science as its ending string?