RDBMS

4. You can use AVG and ____ for numeric data.
5. A ____________ column is a collection of columns that are treated as a unit.
6. Discard all pending changes by using the _______ statement:
7. You can remove existing rows from a table by using the ________ statement.
8. ISO and ___ have accepted SQL as the standard language for relational databases.
9. The default sort order is ___________.
13. Use the __________ operator to return all rows common to multiple queries.
15. you can remove rows by using the DELETE and ___________ statement.
18. 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.
21. is a logical table based on a table or another view.
23. Use the _______ clause to restrict groups.
24. Primary keys generally cannot be changed. (Write either Truee or False)
25. Use the ______ TABLE statement to add, modify, or drop columns.

1. Data changes are made permanent in the database using _______.
2. ________ functions operate on sets of rows to give one result per group.
3. You can perform DML operations on simple views. (Write Yes or Noo)
5. Subqueries are used for row-by-row processing. Each subquery is executed once for every row of the outer query.
7. Eliminate duplicate rows by using the _________ keyword in the SELECT clause.
10. A __________ Can be accessed and modified by executing structured query language (SQL) statements.
11. A function which returns DATE and TIME.
12. Each row of data in a table is uniquely identified by a _________ key.
14. You can logically relate data from multiple tables using __________ keys
16. Converts a null to an actual value
17. The _____ operators combine the results of two or more component queries into one result.
19. A foreign key must reference either a primary key or ________ key column
22. The Oracle server executes subqueries ________. (Write First or Lastt)