Home » SQL » SQL MCQs

MCQ | SQL – EXCEPT Clause

SQL EXCEPT Clause MCQ: This section contains the Multiple-Choice Questions & Answers on SQL EXCEPT Clause.
Submitted by Anushree Goswami, on October 18, 2021

SQL EXCEPT Clause MCQs

1. To get a record from one table, which is not present in another table, we can use the clause –

1. CONCAT
2. COPY
3. EXCEPT
4. ALTER

Answer: C) EXCEPT

Explanation:

To get a record from one table, which is not present in the other table, we can use the clause EXCEPT.

Discuss this Question

---

2. SQL EXCEPT statement behaves similar to _____operator in mathematics.

1. Sum
2. Multiply
3. Minus
4. Divide

Answer: C) Minus

Explanation:

SQL EXCEPT statement behaves similar to Minus operator in mathematics.

Discuss this Question

---

3. Select the correct rule of SQL EXCEPT.

1. There must be the same number of columns in each table and the same order in every select statement.
2. It is desirable that the columns have similar or compatible data types.
3. Both SELECT statements must have the same fields in their respective columns.
4. All of the above

Answer: D) All of the above

Explanation:

Rules of SQL EXCEPT are:

1. There must be the same number of columns in each table and the same order in every select statement.
2. It is desirable that the columns have similar or compatible data types.
3. Both SELECT statements must have the same fields in their respective columns.

Discuss this Question

---

4. Select the correct syntax of SQL EXCEPT.

1. SELECT Column1 FROM Table1
   SELECT Column2 FROM Table2
   EXCEPT;

2. EXCEPT
   SELECT Column1 FROM Table1
   SELECT Column2 FROM Table2;

3. SELECT Column1 FROM Table1
   EXCEPT
   SELECT Column2 FROM Table2;

4. None of the above

Answer: C)

Explanation:

The correct syntax of SQL EXCEPT is,

SELECT Column1 FROM Table1
EXCEPT
SELECT Column2 FROM Table2;

Discuss this Question

---

5. SQL EXCEPT clause is supported in –

1. MySQL
2. PostgreSQL
3. Both A and B
4. None of the above

Answer: B) PostgreSQL

Explanation:

SQL EXCEPT clause is supported in PostgreSQL and not in MySQL.

Discuss this Question

---

6. What is TRUE about SQL EXCEPT clause?

1. The result is purged of duplicates
2. Duplicate records are not removed
3. Only one column can be compared by a clause
4. None of the above

Answer: A) The result is purged of duplicates

Explanation:

In the case of the SQL EXCEPT clause, the result is purged of duplicates.

Discuss this Question

---

7. What is TRUE about NOT IN clause?

1. The result is purged of duplicates
2. Duplicate records are not removed
3. Performs column-by-column comparisons
4. None of the above

Answer: B) Duplicate records are not removed

Explanation:

In the case of the NOT IN clause, Duplicate records are not removed.

Discuss this Question

---

8. ORDER BY clause comes ____ the EXCEPT clause in SQL statement?

1. Before
2. After
3. Flexible to before or after
4. None of the above

Answer: B) After

Explanation:

ORDER BY clauses comes after the EXCEPT clause in SQL statement.

Discuss this Question

---

9. SQL EXCEPT returns the record from -

1. First SELECT Query
2. Second SELECT Query
3. Third SELECT Query
4. None of the above

Answer: A) First SELECT Query

Explanation:

SQL EXCEPT returns the record from the first SELECT Query which is not present in the second SELECT Query.

Discuss this Question

---

10. Using which clause, can SQL EXCEPT be used in single table?

1. TO
2. AS
3. WHERE
4. IN

Answer: C) WHERE

Explanation:

Using WHERE clause, SQL EXCEPT can be used in single table.

Discuss this Question

---

---