SQL 1. What value will be stored in the lastName field of this record after this

Question

SQL

1. What value will be stored in the lastName field of this record after this query is executed? (be careful)

INSERT INTO personnel (empID, lastName, firstName, jobTitle, hourlyWage) VALUES (67890, 'Michael', 'Peter', 'cleaner', 12.50)

67890

Michael

Peter

cleaner

12.50

2. What value will $connect have after the following statement is executed if the connection fails?


$connect=mysqli($host, 'wbip', 'wbip123', 'test');

false

true

no value

"Connection could not be completed"

3. 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'

'Jons' will be matched but 'Johns' and 'Johnson' will not be matched
      
'Jons' and 'Johns' will be matched but 'Johnson' will not be matched
      
'Jons', 'Johns' and 'Johnson' will all be matched
      
None of these three last names will be matched

67890

Michael

Peter

cleaner

12.50

Explanation / Answer

1. What value will be stored in the lastName field of this record after this query is executed?

A. 67890

B. Michael

C. Peter

D. cleaner

E. 12.50

These values are inserted into personnel table.

Related Questions

Navigate

• Browse (All)
• Browse S
• Subjects

Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.