SQL Database Fundamentals

To delete duplicate records

To combine rows from two or more tables based on a related column

To sort data in ascending order

To create new tables

Asynchronous, Continuous, Integrated, Distributed

Active, Centralized, Isolated, Durable

Atomicity, Consistency, Isolation, Durability

Automated, Concurrent, Indexed, Dynamic

Adding more data to the tables

Creating appropriate indexes

Converting all data to TEXT type

Removing all foreign keys

HAVING filters grouped data, WHERE filters individual rows

HAVING is faster than WHERE

WHERE can only be used with SELECT statements

HAVING can only filter text data

To remove duplicate columns

To eliminate transitive dependencies

To ensure primary key uniqueness

To remove all NULL values

The entire database is deleted

All changes since the last COMMIT are undone

The database is backed up

All users are disconnected

Views always improve query performance

Views are virtual tables based on SQL statements

Views can only contain data from one table

Views physically store data

They make the database smaller

They provide better security and performance

They automatically backup data

They prevent database crashes