Home » MCQs » Oracle MCQs

Oracle Subqueries, TRUNCATE TABLE, and WHERE Clause MCQs

Oracle Subqueries, TRUNCATE TABLE, and WHERE Clause MCQs: This section contains multiple-choice questions and answers on Subqueries, TRUNCATE TABLE, and WHERE Clause in Oracle.
Submitted by Anushree Goswami, on June 28, 2022

1. A subquery in Oracle is a query inside another query.

1. Inside
2. Outside
3. On the edge to
4. None

Answer: A) Inside

Explanation:

A subquery in Oracle is a query inside another query.

Discuss this Question

---

2. The ____ clauses can be used to create subqueries.

1. WHERE
2. FROM
3. SELECT
4. All of the above

Answer: D) All of the above

Explanation:

The WHERE, FROM, and SELECT clauses can be used to create subqueries.

Discuss this Question

---

3. To delete all records from a table, use the ____ statement in Oracle.

1. Remove
2. Truncate
3. Drop
4. None

Answer: B) Truncate

Explanation:

To delete all records from a table, use the truncate statement in Oracle.

Discuss this Question

---

4. The delete statement works the same way, except that there is no ___ clause.

1. From
2. Where
3. Group by
4. Order by

Answer: B) Where

Explanation:

The delete statement works the same way, except that there is no where clause.

Discuss this Question

---

5. What is the syntax of Truncate?

1. Truncate table_name;
2. Truncate table table_name;
3. Table table_name;
4. Truncate table;

Answer: B) Truncate table table_name;

Explanation:

The syntax of Truncate is:

Truncate table table_name;

Discuss this Question

---

6. Filtering results in Oracle is done using the ____ clause.

1. From
2. Where
3. Group by
4. Order by

Answer: B) Where

Explanation:

Filtering results in Oracle is done using the where clause.

Discuss this Question

---

7. An ____ or SELECT statement can include a Where clause.

1. INSERT
2. UPDATE
3. DELETE
4. All of the above

Answer: D) All of the above

Explanation:

An INSERT, UPDATE, DELETE, or SELECT statement can include a Where clause.

Discuss this Question

---

8. What is the syntax of Oracle WHERE?

1. WHERE conditions;
2. Conditions WHERE;
3. WHERE conditions condition_name;
4. WHERE clause;

Answer: A) WHERE conditions;

Explanation:

The syntax of Oracle WHERE is:

WHERE conditions;

Discuss this Question

---

9. Which of the following is a parameter in WHERE Clause?

1. Expression
2. Condition
3. Value
4. Pointer

Answer: B) Condition

Explanation:

Condition is the parameter in WHERE Clause.

Discuss this Question

---

10. For determining which records to ____, conditions are used in the WHERE Clause.

1. Add
2. Retrieve
3. Delete
4. None

Answer: B) Retrieve

Explanation:

For determining which records to retrieve, conditions are used in the WHERE Clause.

Discuss this Question

---

---