Write SQL commands for each of the following. Also illustrate the usag

Question

Write SQL commands for each of the following. Also illustrate the usage of each command through suitable example.

(i) Creation of views

(ii) Creation of sequences

(iii) Outer join

(iv) To give access permission to any use

28 May 2025

Answer :

Word Count : 205

(i) Creation of Views A view is a virtual table based on the result of a SQL SELECT query. SQL Command: ```sql CREATE VIEW view_name AS SELECT column1, column2 FROM table_name WHERE condition; ``` Example: ```sql CREATE VIEW high_salary_employees AS SELECT __________ _________ ______ _____ ________ _____ __________ _______ _______ _________.
______ __________ _______ _____ __________ __________.
_____ ____ ___ _______ __________.
______ _______ ___ ___ ___ ____ _________ __________ ____.
_____ _____ ______ ___ ___ ____ ________ ________ _________ ___ _____.
_____ __________ ___ ____ __________ __________ __________ __________ _______ _______.
___ _________ _____ _________ ________ ___.
_________ _____ _________ ______ _______ _________ ______ ____ ____.
__________ _____ _____ _________ ___ ______ ____ __________ ______ __________ ________.
__________ ____ __________ _________ ____ __________ __________.
_______ __________ ______ ________ ______ ____ ___ ____ __________ ____.
_________ _____ ___ ______ ____.
_________ _______ ____ _______ __________ ______ _____ ________ ________ _____ ___.
______ ____ ______ _____ ____ ________ ___ ________ _________ _______.
_______ _____ _______ _____ _______.
_________ ______ _____ ______ ________ __________ _____ _________ _______ _______ ____ _________.
_____ ___ __________ ___ ________ ________ ________ ______ _______ ________.
__________ _________ ____ ___ _______ _____ ____.
_________ ________ ___ ______ __________ _____ __________ ___ ___ __________.
Get Full Answer on WhatsApp

IGNOU Solved Assignments Assignments Ignou Projects Project Previous Year Solved Exam Papers Notes Notes Sample Question Papers Sample Question Papers

IGNOU NEWS

Assignment Submission Last Date Extended Till 30 June 2026 Click Here★★★IGNOU June 2026 TEE Date Sheet Released Click Here★★★