Answer:
The correct option is option 4 from the options indicated below:
Explanation:
The options are as given below
1-SELECT customer# FROM customers
UNION
SELECT customer# FROM orders;
2-SELECT customer# FROM orders
MINUS
SELECT customer# FROM customers;
3-SELECT customer# FROM orders
INTERSECT
SELECT customer# FROM customers;
4-SELECT customer# FROM customers
MINUS
SELECT customer# FROM orders;
Option 1 is not correct as it will provide the list of all the customers whether they have placed order or not.
Option 2 is not correct as it will provide the list of customers who have placed order but are not in the customers table. This will return the empty records.
Option 3 is not correct as it will provide the list of customers who have placed the order.
Option 4 is correct as it will provide the list of customers from the CUSTOMERS table which are not in the Orders table. thus the list of customers who have not placed the order yet.
Answer:
True.
Explanation:
Analytical processing uses multi-levelaggregates, instead of record level access.
1. false
2. d
3. b
4. a
5. b
6.c
7. b
8.a
9. d
10. b
11. d
12.a
13. c
14. c
15. a
Answer:
try powering it off the turn it back on
Explanation:
Answer
To find mean of data add all the numbers in the set of data and divide the sum by the number of addends.
To find range, identify the difference between the highest value and lowest value in the set of data.
Explanation
Mean, mode, median and range are the primary measurements used to get the measures of central tendencies. To get the mean and range; first arrange the data in an ascending order, then identify the highest value and the lowest value in the set. The difference between these two data values gives the range of the set of values. For the mean, add all the set of values and then divide their sum with the number of values in the set of data.