Which SQL technique(s) is(are) used in the following commands?   With Activity_PPP_CTE As( Select Type, ActID, Hours, PPP, rank() over (partition by Type order by PPP) as RankNo  from Activity) Select Type, ActID, PPP as ‘Lowest PPP’from Activity_PPP_CTEwhere RankNo = 1  

Which of the following characteristic describe(s) the result set produced by this query?   SELECT TOP 2 with ties EmpID, Department, SalaryFROM EMPLOYEEWhere salary > 0ORDER BY Salary  DESC;

The query optimizer parses and compiles a brand new query to create a query plan for execution. The query plan is cached and can be reused only if the query stays the same.

The following statement will return the employee with the 2nd highest salary in the Employee table.   Select EmpID, Department, SalaryFrom  EmployeeOrder by Salary DescOffset 2 rowsFetch next 1 row only;

Complete the query below to produce a command that will return a unique list of the activities, and their descriptions, that have no participants in in July 2021.   Select a.ActID, a.DescriptionFrom ACTIVITY a JOIN ___(1)___         on a.ActID = r.ActIDWhere a.ActID ___(2)___         (Select a.ActID        From ACTIVITY a JOIN RESERVATION r            on a.ActID = r.ActID        Where r.RDate ___(3)___ ’07-01-2021′ ___(4)___ ’07-31-2021′)___(5)___ a.ActID, a.Description;

The steps of the systems development life cycle can only be viewed as a non-iterative, linear process.

Whenever possible, use a mouth-to-barrier device to prevent disease transmission.

SQL is a ‘procedure’ language in that developers need to specify the process flow and the execution sequence.  

A person is responsive and shows signs of complete airway obstruction you should….

If you are alone with an unresponsive adult and no one responds to a call for help you should….