What are the different types of joins?
What is the difference between CHAR and VARCHAR2 datatype in SQL?
Char has a fixed length, while Varchar uses variable lengths.
What is ACID property in a database?
ACID stands for Atomicity, Consistency, Isolation, Durability. It is used to ensure that the data transactions are processed reliably in a database system.
Atomicity: Atomicity means that you guarantee that either all of the transaction succeeds or none of it does.
Consistency: This ensures that you guarantee that all data will be consistent. All data will be valid according to all defined rules.
Isolation: Guarantees that all transactions will occur in isolation. No transaction will be affected by any other transaction.
Durability: Durability means that, once a transaction is committed, it will remain in the system, even if there’s a system crash immediately following the transaction.
What is Normalization?
Normalization is the process of reorganizing data in a database to avoid redundancy of data.
What is Denormalization?
Denormalization is the process of reorganizing data in a database to add redundancy of data.
What are Constraints?
Constraints are rules used to limit the type of data that can go into a table. A few examples are:
- NOT NULL
- CHECK
- DEFAULT
- UNIQUE
- PRIMARY KEY
- FOREIGN KEY
More Info:
https://database.guide/what-is-acid-in-databases/
Code Universe 