×

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 Views MCQs

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

1. Views are ____ tables that don't exist physically in Oracle.

  1. Real
  2. Virtual
  3. Both A and B
  4. None of the above

Answer: B) Virtual

Explanation:

Views are virtual tables that don't exist physically in Oracle.

Discuss this Question


2. The data ____ is stored in an Oracle database and does not contain any data.

  1. Redundancy
  2. Dictionary
  3. Dependency
  4. None

Answer: B) Dictionary

Explanation:

The data dictionary is stored in an Oracle database and does not contain any data.

Discuss this Question


3. One or more tables are joined to create a ____.

  1. View
  2. Virtue
  3. Variable
  4. None

Answer: A) View

Explanation:

One or more tables are joined to create a view.

Discuss this Question


4. What is the syntax to create view?

  1. CREATE VIEW view_name AS
  2. CREATE NEW view_name AS
  3. CREATE AS view_name VIEW
  4. CREATE AS view_name NEW

Answer: A) CREATE VIEW view_name AS

Explanation:

Syntax to create view CREATE VIEW view_name AS.

Discuss this Question


5. What does view_name specifies?

  1. Creates a VIEW with a given name
  2. Deletes a VIEW with a given name
  3. Updates a VIEW with a given name
  4. Modifies a VIEW with a given name

Answer: A) Creates a VIEW with a given name

Explanation:

view_name creates a VIEW with a given name.

Discuss this Question


6. To modify an Oracle VIEW definition without dropping it, use the ____ statement.

  1. CREATE AND REPLACE VIEW
  2. CREATE OR REPLACE VIEW
  3. CREATE NOR REPLACE VIEW
  4. CREATE XOR REPLACE VIEW

Answer: B) CREATE OR REPLACE VIEW

Explanation:

To modify an Oracle VIEW definition without dropping it, use the CREATE OR REPLACE VIEW statement.

Discuss this Question


7. You can delete a VIEW by using the ____ statement.

  1. DELETE VIEW
  2. DROP VIEW
  3. DROP DELETE VIEW
  4. DELETE DROP VIEW

Answer: B) DROP VIEW

Explanation:

You can delete a VIEW by using the DROP VIEW statement.

Discuss this Question


8. Views are stored in Databases?

  1. Yes
  2. No

Answer: A) Yes

Explanation:

Yes, the views are stored in Databases?

Discuss this Question


9. Views are also called as ____.

  1. Complex tables
  2. Simple tables
  3. Virtual tables
  4. Actual Tables

Answer: C) Virtual tables

Explanation:

Views are also called as virtual tables.

Discuss this Question


10. Can we update the data in an Oracle VIEW?

  1. Yes
  2. No

Answer: A) Yes

Explanation:

Yes, we can update the data in an Oracle VIEW.

Discuss this Question





Comments and Discussions!

Load comments ↻





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