UPDATE student

SET salutation = ‘Ms.’,

Street_address = ’60 Winter S ’

Phone =’617-236’,

Employer =’Raytone’

Where student_id=900

Commit

84.Consider the EMPLOYEES table. Which of the following statements calculate the minimum salary within each department, displaying only those rows where minimum salary is greater than 5000?

Select department_id, MIN(salary) FROM employees GROUP BY department_id Having Min(salary)>5000

85.When using LIKE conditions which symbol is used to denote one character __

SELECT….FROM….WHERE….GROUP BY…. ORDER BY

88.which of the following clauses is used to sort the rows that are retrieved by the query? ORDER BY

89.Constraint always have a name Верно

90.Thesubquery generally executes _____, and its output is used to complete the query condition for the main(for___)query first, outer

91. Transaction control determines when data manipulation becomes permanent in database ВЕРНО

92. Any user can grant or revoke any type of system privilege to or form another user NEVERNO

93.Consider the EMPLOYEE table. Which of the following SQL statements is correct to provide the sentence in the format “King has been working since 01.01.1987” with “Employee Information” alias?

Select last_name || ‘has been working since’ || hire_date “Employee Information” from employees

94.Consider the EMPLOYEES table. Which of the following statements displays the maximum average salary for each department? Select max(avg(salary)) from employees group by department_id

95.What will be the results of the following SQL statement?Select e.last_nameemp, m.last_namemgr

From employees e JOIN employees m

On (e.manager_id=m.employee_id)

And (e.employee_id=101) the last name for the employee within id 101 will be displayed along with its manager

96.Consider the following SQL statements. What will be output?Select last_name|| ‘were hired on’||hire_dateFrom employees;

Select CONCAT(last_name,’were hired on’, hire_date)FROM employees