Database Reference
In-Depth Information
Example: Use of Commit Statement
Sol:
DELETE OrderItem WHERE Order_no = 132; DELETE Order WHERE order_no = 132;
COMMIT;
Example: undone performed DELETE operation. Sol:
DELETE FROM Staff; ROLLBACK;
Short Answer type Question
1. SQL stands for………………
2. ……………….. statement is used to form a new table.
3. ……………..statement is used to change the name of a table
4. To add record(s) to a table ……………. statement is used.
5. DDL stands for…………..
6. DML stands for……………..
7. NULL operator tests for value for…………..
8. A table may have multiple primary keys
9. DROP COLUMN statement is used to create a new column
10. ALTER TABLE and CREATE TABLE are same statements
11. The SELECT statement is a way to view the data
12. SQL is a procedural language.
13. Self-join joins a table to itself.
