POSTGRESQL DATABASE INTERVIEW QUESTIONS
Course:PostgreSQL
Chapter:Chapter 3 - Database Tables, Columns and Rows
Topic:SQL
Questions Count:10
1
What is SQL?
Explanation:
2
Why is SQL important for database management?
Explanation:
3
What are the basic components of an SQL statement?
Explanation:
4
Can you explain the difference between DDL and DML in SQL?
Explanation:
5
What is a primary key in SQL?
Explanation:
6
What are SQL constraints and why are they used?
Explanation:
7
How does the normalization process improve database design?
Explanation:
8
What is a SQL JOIN and what are its types?
Explanation:
9
What are subqueries in SQL and when would you use them?
Explanation:
10
What is the difference between UNION and UNION ALL in SQL?
Explanation:
