Home » MCQs » Oracle MCQs

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

---

---