Uta insy 3304 chapter 10 - Study guides, Class notes & Summaries

UTA INSY 3304 – CHAPTER 10 EXAM...

UTA INSY 3304 - Chapter 10 Study Guide with Complete Solutions Transaction - Answer-A logical unit of work that must be entirely completed or aborted Atomicity - Answer-All operations of a transaction must be completed; if not the transaction is aborted Consistency - Answer-Permanence of database's consistent state Isolation - Answer-Data used during transaction cannot be used by second transaction until the first is completed Durability - Answer-Ensures that once transactions are com...

UTA INSY 3304 - Exam 2 - Chapter 7&9 Study Guide with Complete Solutions Data definition language - Answer-DDL Data manipulation language - Answer-DML CREAT SCHEMA AUTHORIZATION - Answer-Creates a database schema CREATE TABLE - Answer-Creates a new table in the user's databse schema NOT NULL - Answer-Ensures that a column will not have null values UNIQUE - Answer-Ensures that a column will not have duplicate values PRIMARY KEY - Answer-Defines a primary key for a table FOREIGN KEY - ...