SQL Self Flashcards
1
Q
Intro to Dbms & sql
A
If we have any e commerce websits like Amazon we have to store that products details in a database. Every data must be stored in database.
To manage that data we Dbms . This how we interact with database and store, manage and retrieve data effectively.
Dbms is a software. There are many softwares like oracle.
The sql is the language that helps us to speak with Dbms to do process in the database.
2
Q
Dbms
A
It is a interface between database & end user.
Mainly used to store, manage & retrival
Used to CRUD operations.
3
Q
CHAR vS VARCHAR
A
Char will take full length of what is defined but varchar will only how much the user used.
Example: CHAR(5) , VARCHAR (5);
char -“ABC “
Varchar - “ABC”
