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: