IncludeHelp_logo
Skip Navigation Links

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

Oracle Views Multiple-Choice Questions
Oracle Clauses Multiple-Choice Questions


Comments and Discussions!

Load comments ↻



Top MCQs
Top Programs/Examples
Top Tutorials
About
Student's Section
Subscribe

Copyright © 2024 www.includehelp.com. All rights reserved.