DBMS Crossword

1. You can perform DML operations on simple views. (Write Yes or Noo)
3. The _____ operators combine the results of two or more component queries into one result.
7. Eliminate duplicate rows by using the _________ keyword in the SELECT clause.
12. You can logically relate data from multiple tables using __________ keys
13. A __________ is a user created database object that can be shared by multiple users to generate unique integers.
14. Data changes are made permanent in the database using _______.
16. you can remove rows by using the DELETE and ___________ statement.
20. A ____________ column is a collection of columns that are treated as a unit.
21. Use the ______ TABLE statement to add, modify, or drop columns.
23. A __________ Can be accessed and modified by executing structured query language (SQL) statements.
24. A foreign key must reference either a primary key or ________ key column
25. is a logical table based on a table or another view.

2. A function which returns DATE and TIME.
4. Use the _______ clause to restrict groups.
5. ________ functions operate on sets of rows to give one result per group.
6. Each row of data in a table is uniquely identified by a _________ key.
8. The ___________ executes once before the main query.
9. Use the __________ operator to return all rows common to multiple queries.
10. ISO and ___ have accepted SQL as the standard language for relational databases.
11. 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.
15. Primary keys generally cannot be changed. (Write either Truee or False)
17. You can use AVG and ____ for numeric data.
18. Converts a null to an actual value
19. Discard all pending changes by using the _______ statement:
22. The Oracle server executes subqueries ________. (Write First or Lastt)
23. You can remove existing rows from a table by using the ________ statement.