Database & MySql

Complete the following SQL statement that lists all employees in the departments of 'Sal' and 'Mkt' (each employee can only belong to one department). SELECT * FROM Employee WHERE dept_code='Sal' _______ dept_code='Mkt' OR NOT WHERE AND

OR

Which of the following SQL statements lists the full details of those employees who were hired in 1997? SELECT * FROM Employee SELECT * FROM Employee WHERE emp_hiredate>='1997-01-01' AND emp_hiredate<='1997-12-31' SELECT * FROM Employee WHERE emp_hiredate > '1997-01-01' SELECT * FROM Employee WHERE emp_hiredate IN 1997

SELECT * FROM Employee WHERE emp_hiredate>='1997-01-01' AND emp_hiredate<='1997-12-31'

Which of the following SQL statements lists the employees whose last name is four letters long and ends in 'e'? SELECT * FROM Employee WHERE emp_lastname='%e' SELECT * FROM Employee WHERE emp_lastname='???e' SELECT * FROM Employee WHERE emp_lastname='*e' SELECT * FROM Employee WHERE emp_lastname = '_ _ _e'

SELECT * FROM Employee WHERE emp_lastname = '_ _ _e'

What the Structural Query Language cannot do? Specifying how the data is stored at the database Querying the database Creating database and table structures Manipulating database records

Specifying how the data is stored at the database

Which PHP method can get a row from the resultset of a SELECT statement and turn it into an array? mysqli_query mysqli_fetch_array mysqli_close mysqli_connect

mysqli_fetch_array

MySQL is a _________________________. database query language client-side scripting language server-side scripting language relational database management system

relational database management system

Complete the following SQL statement that lists unique manager IDs. SELECT __________ emp_mgrid FROM Employee * SINGLE DISTINCT UNIQUE

DISTINCT

Complete the following DELETE SQL statement. DELETE __________ lunch WHERE lunchid=10 INTO <blank> AT FROM

FROM

Complete the following INSERT SQL statement. INSERT _______ lunch(lunchid, lunch_date) VALUES(10, '2016-08-01') INTO AT FROM TO

INTO

Complete the following UPDATE SQL statement. UPDATE lunch __________ lunch_date='2016-09-02' WHERE lunchid=13 FROM INTO WHERE SET

SET