From employees e, departments d

Where e.department_id=d.department_id

75.Queries that return more than one row from the inner select statement are calledMultiple-row subqueries

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

Select deparment_id, MIN(salary) FROM employees GROUP BY department_id HAVING MIN(salary)>5000

77. ____clause can be used and is required in the subquery to perform Top-N analysisORDER BY

78.Which statement discards all pending data changes ROLLBACK

79.if there are chemas named USERA and USERB, and both have an EMPLOYEES table, then if USERA wants to access EMPLOYEES table that belongs to USERA must write select statement as follows

Select * from userb.employees

78.A SELECT statement that is embedded in a clause of another SELECT statement is called Subquery

79.Which of the following statements is not true? The CROSS JOIN clause produces the CARTESIAN product of the tables

80.Consider the EMPLOYEES table. Which of the following SQL statements return the number of departments that exist in the organization ?Select count(distinct department_id) From employees

82.Consider the following SQL statement. What will be result?Select e.last_name, e.salary, d.department_name From employees e Natural JOIN departments d Using (department_id) An error will occur since NATURAL JOIN and USING clauses cannon be used togethrer

83.Write an UPDATE statement to update the data in the STUDENT table.Update the colums