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 Question 10 What SQL keyword would you use to remove duplications within the result set. Question 10 options: DISTINCTION DISTINCT REMOVE DUPLICTAE NO DUPLICATE Question 11 Which clause would you add in the following SELECT statement to limit the rows to those customers whose credit is in the range 400 to 600 (We want to include 400 and 600 in the result)? SELECT customer_id, customer_name FROM customers; Question 11 options: WHERE credit_limit >= 600 and credit_limit <= 400 WHERE credit_limit <= 600 and credit_limit >= 400 WHERE credit_limit >= 600 or credit_limit <= 400 WHERE credit_limit <= 600 or credit_limit >= 400
Please help me for Oracle 12 database, thank you.
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 |
Question 10
What SQL keyword would you use to remove duplications within the result set.
Question 10 options:
|
DISTINCTION |
|
|
DISTINCT |
|
|
REMOVE DUPLICTAE |
|
|
NO DUPLICATE |
Question 11
Which clause would you add in the following SELECT statement to limit the rows to those customers whose credit is in the range 400 to 600 (We want to include 400 and 600 in the result)?
SELECT customer_id, customer_name
FROM customers;
Question 11 options:
|
WHERE credit_limit >= 600 and credit_limit <= 400 |
|
|
WHERE credit_limit <= 600 and credit_limit >= 400 |
|
|
WHERE credit_limit >= 600 or credit_limit <= 400 |
|
|
WHERE credit_limit <= 600 or credit_limit >= 400 |
Question 12
Which one is NOT TRUE about views
Question 12 options:
|
Views can be used for security purposes |
|
|
Views are same as tables hence they keep same records physically in the database and clone the underlined table data. |
|
|
Views are similar to table's two dimentional ros and columns look but they do not keep the data physically |
|
|
Views are named SQL objects meaning they are saved objects in the database based on given name to your query |
Trending now
This is a popular solution!
Step by step
Solved in 4 steps
