sql INTERVIEW Q&A.pdf

1. 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