dbms 1

1234567891011121314151617181920212223242526272829
Across
  1. 2. DATABASE TABLES ARE MADE OF DIFFERENT FIELDS
  2. 5. EACH TRANSACTION SHOULD HAPPEN INDEPENDENTLY OF OTHER TRANSACTIONS OCCURRING AT THE SAME TIME.
  3. 7. COMPLETED TRANSACTIONS SHOULD REMAIN STABLE/PERMANENT, EVEN DURING SYSTEM FAILURE.
  4. 8. SQL COMMAND USED TO DELETE RECORD(S) FROM A TABLE IN DATABASE
  5. 10. IS AN OPEN SOURCE RELATIONAL DATABASE MANAGEMENT SYSTEM.
  6. 14. IS THE PROCESS OF ORGANIZING DATA TO MINIMIZE REDUNDANCY AND REMOVE AMBIGUITY.
  7. 17. IS SHORT FOR STRUCTURED QUERY LANGUAGE AND IS AN INDUSTRY STANDARD LANGUAGE USED FOR MANIPULATION OF DATA IN A RDBMS
  8. 18. IS A GROUP OF SQL DATABASE COMMANDS REGARDED AND EXECUTED AS A SINGLE ATOMIC ENTITY.
  9. 19. IS SPECIAL TYPE OF STORED PROCEDURES EXECUTED AUTOMATICALLY WHEN CERTAIN EVENTS TAKE PLACE
  10. 23. IS A SQL COMMAND USED TO EDIT/UPDATE EXISTING RECORDS IN A DATABASE TABLE.
  11. 26. A TRANSACTION SHOULD BE DONE OR UNDONE COMPLETELY. IN THE EVENT OF AN ERROR OR FAILURE, ALL DATA MANIPULATIONS SHOULD BE UNDONE, AND ALL DATA SHOULD ROLLBACK TO ITS PREVIOUS STATE.
  12. 27. IS A RELATIONAL DATABASE MANAGEMENT SYSTEM DEVELOPED BY IBM.
  13. 29. IS A SQL COMMAND, WHICH IS THE PRIMARY MEANS FOR RETRIEVING DATA FROM A RDBMS.
Down
  1. 1. IS AN OBJECT-ORIENTED OPEN SOURCE RELATIONAL DATABASE MANAGEMENT SYSTEM
  2. 3. IS THE MAIN WAY TO MAKE A REQUEST FOR INFORMATION FROM A DATABASE.
  3. 4. IN RDBMS REFERS TO DATA ARRANGED IN ROWS AND COLUMNS, WHICH DEFINES A DATABASE ENTITY.
  4. 6. IS A SQL COMMAND USED TO RETRIEVE DATA FROM 2 OR MORE DATABASE TABLES WITH EXISTING RELATIONSHIP BASED UPON A COMMON ATTRIBUTE.
  5. 8. IS A COLLECTION OF INFORMATION ORGANIZED INTO RELATED TABLES OF DATA AND DEFINITIONS OF DATA OBJECTS
  6. 9. THIS COMMAND IN SQL MARKS THE FINALIZATION OF A DATABASE TRANSACTION.
  7. 11. is a RELATIONAL TABLE HOLDS A UNIQUE VALUE, WHICH IDENTIFIES EACH RECORD IN THE TABLE.
  8. 12. A TRANSACTION SHOULD TRANSFORM A SYSTEM FROM ONE CONSISTENT STATE TO ANOTHER CONSISTENT STATE.
  9. 13. USED TO CROSS-REFERENCE TABLES.
  10. 15. IS A SQL COMMAND USED TO ADD A NEW RECORD TO A TABLE WITHIN A DATABASE.
  11. 16. IS A COMPLETE SET OF INFORMATION PRESENTED WITHIN A RDBMS.
  12. 20. PIECE OF INFORMATION COLLECTED AND FORMATTED IN A SPECIFIC WAY.
  13. 21. SQL KEYWORD IS USED TO REPRESENT A MISSING VALUE
  14. 22. A STANDARD DATABASE ACCESS TECHNOLOGY DEVELOPED BY MICROSOFT CORPORATION
  15. 24. IS A SQL COMMAND WHICH CANCELS/UNDOES THE PROPOSED CHANGES IN A PENDING DATABASE TRANSACTION AND MARKS THE END OF THE TRANSACTION.
  16. 25. IS AN ENTRY-LEVEL DATABASE MANAGEMENT SOFTWARE FROM MICROSOFT.
  17. 28. FILE IS A DATA FILE THAT HAS NO STRUCTURED RELATIONSHIPS BETWEEN ITS RECORDS.