sql INTERVIEW Q&A.pdf
- what is a data
- raw facts or information stored inside a database table.
what is database
- database is a organized collection of data that is stored electronically and can be easily accessed managed and updated using software like sql
what is dbms
- DBMS (Database Management System) is software that is used to create, store, manage, and retrieve data from a database.
Types of dbms
- Types of DBMS (in short):
- 1️⃣ Hierarchical DBMS – data in tree structure
- 2️⃣ Network DBMS – data in graph structure
- 3️⃣ Relational DBMS (RDBMS) – data in tables (most used)
- 4️⃣ Object-Oriented DBMS – data stored as objects
what is an sql
- SQL is a structured query language used to access and manage data stored in relational databases.
- SQL → Language (used to interact with databases)
what are datatypes in sql
- Datatype type of value allowed in a column
