×

Multiple-Choice Questions

Web Technologies MCQs

Computer Science Subjects MCQs

Databases MCQs

Programming MCQs

Testing Software MCQs

Digital Marketing Subjects MCQs

Cloud Computing Softwares MCQs

AI/ML Subjects MCQs

Engineering Subjects MCQs

Office Related Programs MCQs

Management MCQs

More

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





Comments and Discussions!

Load comments ↻





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