Home » MCQs » Oracle MCQs

Oracle Queries MCQs

Oracle Queries MCQs: This section contains multiple-choice questions and answers on Queries in Oracle.
Submitted by Anushree Goswami, on June 06, 2022

1. Oracle database supports ____.

1. Inserting, Updating
2. Deleting, Altering Tables
3. Dropping, Creating and Selecting
4. All of the above

Answer: D) All of the above

Explanation:

Oracle database supports inserting, updating, deleting, altering tables, dropping, creating, and selecting.

Discuss this Question

---

2. To ___ records from a database, Oracle select queries are used.

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

Answer: B) Retrieve

Explanation:

To retrieve records from a database, Oracle select queries are used.

Discuss this Question

---

3. A record is inserted into a table using an Oracle ____ query.

1. Add
2. Insert
3. Alter
4. None

Answer: B) Insert

Explanation:

A record is inserted into a table using an Oracle insert query.

Discuss this Question

---

4. To update records within a table, Oracle ____ queries are used.

1. Update
2. Alter
3. Delete
4. Rename

Answer: A) Update

Explanation:

To update records within a table, Oracle update queries are used.

Discuss this Question

---

5. To ____ a row from a table, you use the Oracle delete query.

1. Delete
2. Update
3. Drop
4. None

Answer: A) Delete

Explanation:

To delete a row from a table, you use the Oracle delete query.

Discuss this Question

---

6. A table can be truncated or removed via Oracle truncate queries.

1. Truncated
2. Removed
3. Both A and B
4. None of the above

Answer: C) Both A and B

Explanation:

A table can be truncated or removed via Oracle truncate queries.

Discuss this Question

---

7. Dropping a table or view is done using an Oracle ____ query.

1. Drop
2. Delete
3. Read
4. Write

Answer: A) Drop

Explanation:

Dropping a table or view is done using an Oracle DROP query.

Discuss this Question

---

8. ____ are missing from Oracle drop queries.

1. Data
2. Structure
3. Both A and B
4. None of the above

Answer: C) Both A and B

Explanation:

Data and structure are missing from Oracle drop queries.

Discuss this Question

---

9. You can create tables, views, sequences, procedures, and functions using Oracle _____ queries.

1. Create
2. Update
3. Alter
4. Delete

Answer: A) Create

Explanation:

You can create tables, views, sequences, procedures, and functions using Oracle create queries.

Discuss this Question

---

10. A table can be altered through an _____ query to add, delete, modify, or drop columns.

1. Drop
2. Delete
3. Modify
4. Alter

Answer: D) Alter

Explanation:

A table can be altered through an alter query to add, delete, modify, or drop columns.

Discuss this Question

---

11. The Oracle _____ statement retrieves data from a table, an object table, a view, an object view, etc.

1. SELECT
2. CREATE
3. UPDATE
4. DELETE

Answer: A) SELECT

Explanation:

The Oracle SELECT statement retrieves data from a table, an object table, a view, an object view, etc.

Discuss this Question

---

12. What is/are the parameter(s) in SELECT statement?

1. Expressions
2. Tables
3. Conditions
4. All of the above

Answer: D) All of the above

Explanation:

The parameters in SELECT statement are,

1. Expressions
2. Tables
3. Conditions

Discuss this Question

---

13. The expression specifies the ____ you wish to retrieve.

1. Columns
2. Calculations
3. Both A and B
4. None of the above

Answer: C) Both A and B

Explanation:

The expression specifies the columns or calculations you wish to retrieve.

Discuss this Question

---

14. You specify the tables from which you want records to be retrieved by the ____ parameter.

1. Expressions
2. Tables
3. Conditions
4. None

Answer: B) Tables

Explanation:

You specify the tables from which you want records to be retrieved by the tables parameter.

Discuss this Question

---

15. The FROM clause must contain at least ____ table.

1. One
2. Two
3. Three
4. Four

Answer: A) One

Explanation:

The FROM clause must contain at least one table.

Discuss this Question

---

16. _____ statements are used to insert a single record into a table or to insert multiple records at once.

1. SELECT
2. UPDATE
3. ADD
4. INSERT

Answer: D) INSERT

Explanation:

The INSERT statements are used to insert a single record into a table or to insert multiple records at once.

Discuss this Question

---

17. By putting the ____ keyword in a database, you can insert an element into a database in the simplest way.

1. VALVE
2. VAULE
3. VALUE
4. VULEA

Answer: C) VALUE

Explanation:

By putting the VALUE keyword in a database, you can insert an element into a database in the simplest way.

Discuss this Question

---

18. Multiple rows can be inserted using the Oracle ____ statement.

1. INSERT
2. INSERT ALL
3. INSERT FEW
4. INSERT MULTIPLE

Answer: C) INSERT FEW

Explanation:

Multiple rows can be inserted using the Oracle INSERT ALL statement.

Discuss this Question

---

19. The rows can be inserted into one table or multiple tables through only ____ SQL statement.

1. One
2. Two
3. Three
4. Four

Answer: A) One

Explanation:

The rows can be inserted into one table or multiple tables through only one SQL statement.

Discuss this Question

---

20. By using the INSERT ALL statement, multiple rows can be inserted into more than one table by a ____ command.

1. Single
2. Double
3. Triple
4. Multiple

Answer: A) Single

Explanation:

By using the INSERT ALL statement, multiple rows can be inserted into more than one table by a single command.

Discuss this Question

---

21. UPDATE information in an Oracle table is updated using the ____ statement.

1. UPDATE
2. ALTER
3. RENEW
4. RENAME

Answer: A) UPDATE

Explanation:

UPDATE information in an Oracle table is updated using the UPDATE statement.

Discuss this Question

---

22. Oracle has a _____ statement that is used to delete a record from a table or multiple records from a table.

1. DELETE
2. DROP
3. DELT
4. DROPOUT

Answer: A) DELETE

Explanation:

Oracle has a DELETE statement that is used to delete a record from a table or multiple records from a table.

Discuss this Question

---

23. You can delete all records in an Oracle table using the ____ TABLE statement.

1. DELETE
2. DROP
3. TRUNCATE
4. None

Answer: C) TRUNCATE

Explanation:

You can delete all records in an Oracle table using the TRUNCATE TABLE statement.

Discuss this Question

---

24. In the TRUNCATE statement, the ____ clause is omitted, as with the DELETE statement.

1. FROM
2. WHERE
3. FOR
4. WHAT

Answer: B) WHERE

Explanation:

In the TRUNCATE statement, the WHERE clause is omitted, as with the DELETE statement.

Discuss this Question

---

25. The TRUNCATE method is usually used when _____ is not necessary.

1. Adding
2. Restoring
3. Reversing
4. Deleting

Answer: C) Reversing

Explanation:

The TRUNCATE method is usually used when reversing is not necessary.

Discuss this Question

---

26. There is no effect on the _____ of the table with the TRUNCATE TABLE statement.

1. Indexes
2. Triggers
3. Dependencies
4. All of the above

Answer: D) All of the above

Explanation:

There is no effect on the indexes, triggers, or dependencies of the table with the TRUNCATE TABLE statement.

Discuss this Question

---

---