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: flash drive
Explanation:
Flash drives are refered to as small, portable storage devices which makes use of a USB interface in order to be connected to a laptop.
Flash cards are removable and rewritable. They are mainly used to store data. Flash cards can be found in computers, laptops, digital cameras etc.
The SQL SELECT built-in function COUNT none of the above options.
<h3>What is a SELECT query?</h3>
A select query is known to be a kind of a database object that depicts the information that is shown in Datasheet view.
Note that A query does not save data, it shows data that is saved in tables. The SELECT statement is known to be one that is often used to select data from what we call a database.
Hence, The data returned is said to be saved in a result table, known to be the result-set.
Based on the above, the SQL SELECT built-in function COUNT none of the above options.
Learn more about SQL SELECT from
brainly.com/question/10097523
#SPJ1
