Interview Question

What are rows and columns?

Columns define attributes; rows hold individual records.

💡 Concept ✅ Quick Revision 🗃️ SQL

Answer

A row contains one record, while a column defines one named attribute of every row. • Columns have data types and may have constraints. • Rows provide values for those columns. • A query can select all columns or only the columns it needs.

💡 SQL Example

SELECT product_id, name FROM products;

Result

1 | Keyboard 2 | Mouse

⚡ Quick Revision

Columns define attributes; rows hold individual records.