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.
- Real
- Virtual
- Both A and B
- 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.
- Redundancy
- Dictionary
- Dependency
- 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 ____.
- View
- Virtue
- Variable
- 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?
- CREATE VIEW view_name AS
- CREATE NEW view_name AS
- CREATE AS view_name VIEW
- 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?
- Creates a VIEW with a given name
- Deletes a VIEW with a given name
- Updates a VIEW with a given name
- 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.
- CREATE AND REPLACE VIEW
- CREATE OR REPLACE VIEW
- CREATE NOR REPLACE VIEW
- 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.
- DELETE VIEW
- DROP VIEW
- DROP DELETE VIEW
- 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?
- Yes
- No
Answer: A) Yes
Explanation:
Yes, the views are stored in Databases?
Discuss this Question
9. Views are also called as ____.
- Complex tables
- Simple tables
- Virtual tables
- 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?
- Yes
- No
Answer: A) Yes
Explanation:
Yes, we can update the data in an Oracle VIEW.
Discuss this Question