RDBMS

4. Discard all pending changes by using the _______ statement:
8. The _____ operators combine the results of two or more component queries into one result.
9. Subqueries are used for row-by-row processing. Each subquery is executed once for every row of the outer query.
10. You can logically relate data from multiple tables using __________ keys
11. Use the __________ operator to return all rows common to multiple queries.
12. The default sort order is ___________.
14. ISO and ___ have accepted SQL as the standard language for relational databases.
15. Primary keys generally cannot be changed. (Write either Truee or False)
16. Eliminate duplicate rows by using the _________ keyword in the SELECT clause.
17. The ___________ executes once before the main query.
20. A __________ is a user created database object that can be shared by multiple users to generate unique integers.
24. is a logical table based on a table or another view.
26. A foreign key must reference either a primary key or ________ key column

1. A ____________ column is a collection of columns that are treated as a unit.
2. Use the ______ TABLE statement to add, modify, or drop columns.
3. Each row of data in a table is uniquely identified by a _________ key.
5. A function which returns DATE and TIME.
6. Use the _______ clause to restrict groups.
7. you can remove rows by using the DELETE and ___________ statement.
10. The Oracle server executes subqueries ________. (Write First or Lastt)
13. A __________ Can be accessed and modified by executing structured query language (SQL) statements.
18. You can perform DML operations on simple views. (Write Yes or Noo)
19. You can remove existing rows from a table by using the ________ statement.
21. Data changes are made permanent in the database using _______.
22. Converts a null to an actual value
23. ________ functions operate on sets of rows to give one result per group.
25. You can use AVG and ____ for numeric data.