DBMS Crossword

3. You can logically relate data from multiple tables using __________ keys
4. You can use AVG and ____ for numeric data.
7. Use the _______ clause to restrict groups.
9. ________ functions operate on sets of rows to give one result per group.
10. The _____ operators combine the results of two or more component queries into one result.
12. A __________ Can be accessed and modified by executing structured query language (SQL) statements.
15. The ___________ executes once before the main query.
17. A ____________ column is a collection of columns that are treated as a unit.
18. A foreign key must reference either a primary key or ________ key column
20. ISO and ___ have accepted SQL as the standard language for relational databases.
22. Discard all pending changes by using the _______ statement:
24. You can remove existing rows from a table by using the ________ statement.
25. You can perform DML operations on simple views. (Write Yes or Noo)

1. Data changes are made permanent in the database using _______.
2. A __________ is a user created database object that can be shared by multiple users to generate unique integers.
4. A function which returns DATE and TIME.
5. Use the __________ operator to return all rows common to multiple queries.
6. Each row of data in a table is uniquely identified by a _________ key.
8. is a logical table based on a table or another view.
11. you can remove rows by using the DELETE and ___________ statement.
12. Eliminate duplicate rows by using the _________ keyword in the SELECT clause.
13. The default sort order is ___________.
14. Subqueries are used for row-by-row processing. Each subquery is executed once for every row of the outer query.
16. Primary keys generally cannot be changed. (Write either Truee or False)
19. The Oracle server executes subqueries ________. (Write First or Lastt)
21. Converts a null to an actual value
23. Use the ______ TABLE statement to add, modify, or drop columns.