Please help me as this is in regards to Oracle 12 database Question 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
Please help me as this is in regards to Oracle 12
Question 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:
|
ORDER BY SALARY > 5000 |
|
|
GROUP BY SALARY > 5000 |
|
|
WITH SALARY > 5000 |
|
|
WHERE SALARY > 5000 |
Step by step
Solved in 2 steps
