Which statement will display those employees who have a job title that contains the string 'JEF' and earn $10,000 or more?
A) SELECT employee_id, last_name, job_id, salary FROM employees WHERE salary >= 10000 AND job_id LIKE '%JEF%';
B) SELECT employee_id, last_name, job_id, salary FROM employees WHERE salary >= 10000 OR job_id LIKE '%JEF%';
C) Either statement displays the desired output.
D) Neither statement displays the desired output.
A (SELECT employee_id, last_name, job_id, salary FROM employees WHERE salary >= 10000 AND job_id LIKE '%JEF%';)
You might also like to view...
Which of the following default services uses TCP/UDP port 88?
A. LDAP B. IGMP C. HTTP D. Kerberos
Colors are represented by three color values and the alpha value, specifying .
a) brightness b) opacity c) a blending constant d) None of the above.
Most operating systems create a significant number of temporary files in the course of operation. Which one of the following might leave behind "footprints" if the computer is not shut down gracefully?
a. Autosave files b. Print spooler files c. Undo files d. All of the above
Joe's data-entry job with his brother-in-law's accounting firm becomes more demanding during tax season. He deals with numerous Word and Excel files daily as new clients bring in business, and as information is either added or updated.Joe wants to move client files into folders classified alphabetically by last name, which function of his pointing device should he use?
A. right-clicking B. double-clicking C. clicking D. dragging