Lecture #5 Flashcards
An index is a data Structure that optimizes security & accessing data.
True.
List the different types of indexes
- Clustered
- Non-Clustered
Clustered indexes occur only once within a given table
True.
Non-clustered indexes access the data using another column also known as a secondary index.
True.
List index Pitfalls
- Regular Maintenance
- Requires additional Storage.
Stored Procedures are a block of SQL that can be written given a name, and stored directly in the database, very similar to creating a function
True.
List Advantages of Stored Procedures.
- Reduces Network Traffic
- Centralizes business logic in the database
- Make database more secure
List disadvantages of Stored Procedure.
- Resources Usages
- Troubleshooting
- Maintenances
- Implementation
An SQL injection is a technique used by malicious users to intentionally inject SQL commands, usually via a webpage.
True.
A Trigger is a Stored program invoked automatically in response to a DML event that occurs within the associated table.
True.
List the different Types of Triggers
- Row-level Triggers
- Statement-level Triggers
List the Advantages of Triggers.
- Provide another way to check data integrity.
- Handle errors from the database layer.
- Provides an alternative way to run scheduled tasks.
List the Disadvantages of Triggers.
- Can only provide extended validations.
- Difficulty Troubleshooting
- May increase overhead of the Mysql Server.
List the Different Types of SQL commands
- Data Definition Language (DDL)
- Data Manipulation language (DML)
- Data Control Language (DCL)
- Transaction Control Languages(TCL)
What is a SQL Transaction?
Logical units of work that consist of one or more database operations.
