Which SQL statement is used to delete an existing view from the database catalog? MCQ with Answer and Explanation

Which SQL statement is used to delete an existing view from the database catalog?
A. CLEAR VIEW
B. REMOVE VIEW
C. DELETE VIEW
D. DROP VIEW
Answer: Option D
Solution (By JKSSB Mock Tests)
Because a View is a database structural object, it is removed from the database schema using the DDL command 'DROP VIEW'.

Discuss this Question (0)

No comments yet. Be the first to start the discussion!

Practice More Database Management System (DBMS) Questions

Question #1
What is the difference between DELETE and TRUNCATE commands?
A. DELETE removes all rows; TRUNCATE removes structure
B. No difference
C. TRUNCATE can have WHERE; DELETE cannot
D. DELETE can be rolled back; TRUNCATE cannot (in most DBMS)

Correct Answer: Option D


Explanation:
DELETE is a DML command that can be rolled back and can use WHERE; TRUNCATE is a DDL command that removes all rows and cannot be rolled back (in some DBMS) and resets auto-increment counters.

This question belongs to: Computer Database Management System (DBMS)
Question #2
The range of all permissible and valid values that an attribute can hold is formally defined as its what?
A. Tuple
B. Schema
C. Relation
D. Domain

Correct Answer: Option D


Explanation:
A Domain is the pool of legal, atomic values from which an attribute can take its value.

This question belongs to: Computer Database Management System (DBMS)
Question #3
What is a database instance?
A. A query result
B. A backup
C. The schema definition
D. The state of a database at a particular moment in time

Correct Answer: Option D


Explanation:
A database instance refers to the data stored in the database at a specific time, as opposed to the schema (structure).

This question belongs to: Computer Database Management System (DBMS)