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
Answer :
Word Count : 205
__________ _________ ________ _______ ___ ______ _________.
_______ ___ _______ __________ __________ __________ _________ ________.
______ _________ __________ ____ _______ ___ ___ _________ ___ ________ ________ _____.
__________ ____ ___ __________ ____.
_______ _____ __________ ______ ___ ___ ___ ____ __________ _____.
_______ _____ _____ __________ ____ _______ ______ ____ ____ _________ __________.
___ _______ _______ ______ ________ ____.
_____ ___ ___ ____ _____ ____ ______ _____ _________ _____ ____ _________.
_____ _____ ___ ____ ______ __________ _______ _______ ______.
_________ _____ ___ _________ __________ ____ _____ ________ __________ ______.
_______ ____ _____ _____ _____ __________.
_____ ___ __________ ___ _____.
______ _______ ____ ___ _______ ______ __________ _______ ______ _________.
________ ____ __________ __________ ____ _________ ___ __________ ____ _____ _______ ______.
Skip in 10
(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 employee_id, name, salary FROM employees WHERE salary > 50000; ``` (ii) Creation of Sequences A sequence generates a series of unique numbers, often used for primary keys. SQL Command: ```sql CREATE
__________ _______ _____ ____ _______ ___ ____ ____ ____ ____.__________ _________ ________ _______ ___ ______ _________.
_______ ___ _______ __________ __________ __________ _________ ________.
______ _________ __________ ____ _______ ___ ___ _________ ___ ________ ________ _____.
__________ ____ ___ __________ ____.
_______ _____ __________ ______ ___ ___ ___ ____ __________ _____.
_______ _____ _____ __________ ____ _______ ______ ____ ____ _________ __________.
___ _______ _______ ______ ________ ____.
_____ ___ ___ ____ _____ ____ ______ _____ _________ _____ ____ _________.
_____ _____ ___ ____ ______ __________ _______ _______ ______.
_________ _____ ___ _________ __________ ____ _____ ________ __________ ______.
_______ ____ _____ _____ _____ __________.
_____ ___ __________ ___ _____.
______ _______ ____ ___ _______ ______ __________ _______ ______ _________.
________ ____ __________ __________ ____ _________ ___ __________ ____ _____ _______ ______.
IGNOU ACADEMY
Your IGNOU journey, made easier.
- Solved Assignments
- Study Notes
- Guess Papers
- Question Papers
Continue Reading — It's Free
Sign in with Google to unlock more of this answer.
✓ Free access
✓ Unlock up to 60% of the answer
✓ No payment required
✓ Unlock up to 60% of the answer
✓ No payment required
Quick Google sign-in. No separate registration form.