Please put approve to your answer so i can understand why you chose that answer

Question

Please put approve to your answer so i can understand why you chose that answer

Please put approve to your answer so i can understand why you chose that answer

You are trying to create a query that will show those customers who have not placed orders. You have formulated the below listed query. Which of the set operators should you use? select lastname firstname customer ID from customer select lastname firstname C. customer ID from customer c join order o customerID; on c. Customer ID o union O except union all O intersect

Explanation / Answer

1.Option B: Except

We use the Outer Join to identify the customers who have not placed their order.The Operator Except can be used instead of using Outer Join to obtain the same result.

The Except operator returns the unique rows of the left query that are not present in the right query....

2. Option B: DDL,DML

The statements like CREATE,ALTER,DROP etc., defines the structure or schema of the database.These are known as Data Definition Language(DDL).

Similarly Data Manipulation language(DML) includes the statements like UPDATE,SELECT,DELETE..that are used to managing data in the database schema..

Related Questions

Navigate

• Browse (All)
• Browse P
• Subjects

---

---

Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.