ORACLE CROSSWORD

2. Type of trigger in which :OLD and :NEW qualifiers can be referenced
4. Database object used for creating alias names for tables
6. Function used to replace NULL value with any given value provided by the user
7. Used to generate series of unique numbers for a numeric column
8. SQL command used to modify existing data in a database table
10. Keyword used to return unique values in a column
12. ________ clause can be used with aggregate functions like sum, etc in a sql query
13. A stored subprogram that is executed automatically and fired based on some database events
15. Group functions can be nested upto these many levels only
16. Dummy table with one column and one row present by default in oracle
17. Unique physical address for each row in every table
19. A cursor attribute that returns true when cursor is open and returns false when cursor is closed

1. This join displays the cartesian product of records from the tables present in the join
3. Rules enforced on data columns in a table
5. Default parameter mode set for formal parameters in an oracle subprogram
6. Pseudo column used to get the next value generated by a sequence
9. Logical table that can be created based on one or more views or tables
10. Optional part of a plsql block
11. Function that can be used to return a specified portion of a character string
14. Clause that groups a result into subsets that have matching values for one or more columns
18. Keyword used for specifying ALIAS names for columns in an oracle table