Please help me as this is in regards to Oracle 12 database Qu estion 7IN SELECT statement you always add SELECT , FROM and WHERE keywords because without WHERE condition you wouldn't know which data you searchQuestion 7 options: True False Question 8What will the following statement return after execution?SELECT employeenumber, lastname, emailFROM productsORDER BY employeenumber DESC and email;Question 8 options: The results are sorted first numerically and then alphabetically. The results are sorted first numerically from high to low and then alphabetically. The results are sorted first alphabetically and then numerically. The query returns an error. Question 9Which clause would you use in a SELECT statement to limit the display to those employees whose salary is greater than 5000?Question 9 options: ORDER BY SALARY > 5000 GROUP BY SALARY > 5000 WITH SALARY > 5000 WHERE SALARY > 5000

Please help me as this is in regards to Oracle 12 database Qu estion 7 IN SELECT statement you always add SELECT , FROM and WHERE keywords because without WHERE condition you wouldn't know which data...

Please help me as this is in regards to Oracle 12 database

Qu
estion 7

IN SELECT statement you always add SELECT , FROM and WHERE keywords because without WHERE condition you wouldn't know which data you search

Question 7 options:

	True
	False

Question 8

What will the following statement return after execution?

SELECT employeenumber, lastname, email

FROM products

ORDER BY employeenumber DESC and email;

Question 8 options:

	The results are sorted first numerically and then alphabetically.
	The results are sorted first numerically from high to low and then alphabetically.
	The results are sorted first alphabetically and then numerically.
	The query returns an error.

Question 9

Which clause would you use in a SELECT statement to limit the display to those employees whose salary is greater than 5000?

Question 9 options:

Jun 11, 2022