IS 311 - Prelim

Edit Answers
12345678910111213
Across
  1. 3. is a rule enforced on data in a table to maintain integrity such as NOT NULL, UNIQUE, and CHECK.
  2. 5. These are SQL commands used to retrieve data from a database such as SELECT.
  3. 6. These are SQL commands used to define and modify database structures such as CREATE, ALTER, and DROP.
  4. 9. It is a DBMS based on the relational model where data is stored in tables.
  5. 11. is a structured collection of data that is stored, managed, and accessed electronically.
  6. 13. is a virtual table based on the result of an SQL query.
Down
  1. 1. is a column in one table that refers to the primary key in another table to establish relationships.
  2. 2. These are SQL commands used to control access to data such as GRANT and REVOKE.
  3. 4. It is a standard language for storing, retrieving, and manipulating data in a database.
  4. 5. These are SQL commands used to insert, update, delete, and retrieve data such as INSERT, UPDATE, and DELETE.
  5. 6. It is software used to create, manage, and manipulate databases.
  6. 7. is the structure that defines how data is organized within a database, including tables, views, and relationships.
  7. 8. is a column or set of columns that uniquely identifies each row in a table.
  8. 10. is a database object used to speed up data retrieval operations.
  9. 12. These are SQL commands used to manage transactions such as COMMIT and ROLLBACK.