SQL Flashcards
What are DML and DDL
Aggregate functions with examples
Primary key vs unique key. Differences.
What are transactions?
What is ACID?
Views, why they are needed?
What is a view/materialized view.
What types of constraints does one know?
Are database Indexes useful? What is the role of them?
What kind of joins do you know?
What is the difference between inner join and outer join?
Why many indexes are not good for performance
What transaction isolation levels do you know?
Which of SELECT, UPDATE, DELETE, ADD’s performance is mostly affected by performance of indexes?
Types of tables (regular, temporary, index-organized etc)
What does it mean database de-normalization?
What are ways to increase performance of database
What is difference between SQL and NoSQL?
Does every relational database implements SQL standard in the same way?
What is a nested subquery?
Types of indices in Oracle
What is a hierarchical query? How to create it?
What is a bitmap index
Partitioning and methods of partitioning