DBMS Crossword Puzzle-1
Across
- 4. when multiple transactions occur independently without interference is called ________
- 9. _________ integrity constraint ensures that key values are consistent across tables
- 10. _________ compute Difference of two union-compatible sets of tuples.
- 11. cursors are of two types: implicit and _________
- 12. The query processor in a database management system receives as input a query request in the form of SQL text, parses it, generates an _________ plan, and completes the processing and returns the results to the client
- 13. change the _________ schema without changing the conceptual schema is called Physical Data independence
- 16. big-table is an example of ________ database model
- 17. In _________ outer join, if there is no matching tuple found in left relation, then the attributes of left relation in the join result are filled with null values
- 18. In relation, each _________ is unique
- 19. Breaking an existing record into two is an example of _________ data independence
Down
- 1. Key that consist of two or more attributes that uniquely identify an entity occurrence is called _________ key
- 2. Entity-Relationship model is used in the ___________ design of a database
- 3. _________ is Transaction Control command
- 5. A cursor is a _________to the context area
- 6. The set of attributes that are functionally dependent on the attribute A is called _______ of A
- 7. Join is _________ relational operator
- 8. Sequence of Cursor actions is Declare, _________, fetch, close, deallocate
- 14. The relation is said to be lossless decomposition if _________ joins of all the decomposition give the original relation.
- 15. A → B has a _________ functional dependency if B is not a subset of A.