SQL Flashcards
1
Q
What are DML and DDL
A
2
Q
Aggregate functions with examples
A
3
Q
Primary key vs unique key. Differences.
A
4
Q
What are transactions?
A
5
Q
What is ACID?
A
6
Q
Views, why they are needed?
A
7
Q
What is a view/materialized view.
A
8
Q
What types of constraints does one know?
A
9
Q
Are database Indexes useful? What is the role of them?
A
10
Q
What kind of joins do you know?
A
11
Q
What is the difference between inner join and outer join?
A
12
Q
Why many indexes are not good for performance
A
13
Q
What transaction isolation levels do you know?
A
14
Q
Which of SELECT, UPDATE, DELETE, ADD’s performance is mostly affected by performance of indexes?
A
15
Q
Types of tables (regular, temporary, index-organized etc)
A
