SQL INTERVIEW QUESTION & ANSWERS
| 6. |
What is a database? |
| |
Database is a collection of data. It contains information about one particular enterprise. A database management system (DBMS) consists of a collection of interrelated data and a set of programs to access that data. |
| 7. |
What are the advantages of database? |
| |
The advantages of having a centralized control of data are :- Redundancy can be reduced
- The data can be shared
- Inconsistency can be avoided
- Standards can be enforced
- Security can be enforced
- Integrity can be maintaned
|
| 8. |
Define DDL? |
| |
DDL stands for Data Definition Language. Data Definition Language is used to create, alter, drop, replace and truncate database objects. |
| 9. |
Define DML? |
| |
- DML stands for Data Manipulation Language.
- Data Manipulation Language commands let users insert, modify and delete the data in the database.
- Sql provides three data manipulation statements insert, update and delete
|
| 10. |
Define DCL? |
| |
DCL stands for Data Control Language. It consists of commands that control the user access to the database objects. |
