Which SQL command is used to create a view in DB2?
- ALTER VIEW
- CREATE VIEW
- DEFINE VIEW
- GENERATE VIEW
The SQL command used to create a view in DB2 is CREATE VIEW. This command allows users to define a virtual table based on the result set of a SELECT statement.
Loading...
Related Quiz
- In DB2, what does a view represent?
- DB2 manages deadlock situations by employing ________.
- XML ________ in DB2 allows for the customization of XML output according to specific requirements.
- DB2 administrators can use ________ to gather real-time information about database activity.
- How does the Health Monitor assist in identifying potential issues within the database?