SQL INTERVIEW QUESTIONS & ANSWERS
1. |
What does the acronym SQL stand for? |
|
SQL stands for Structured Query Language. |
|
Posted by K.Supravallika. (Mar 21, 2014) |
|
Standard Query Language |
2. |
Define SQL? |
|
Structured query language is the standard command set used to communicate with the relational database management system. |
3. |
What are the advantages of SQL? |
|
- SQL is a high level langauge that provides a greater degree of abstraction than procedural languages.
- The language while being simple and easy to learn can handle complex situations.
- Applications written in SQL can be easily ported across systems.
|
4. |
What are the six main categories of SQL commands? |
|
- Data Definition Language (DDL)
- Data Manipulation Language (DML)
- Data Query Language (DQL)
-
Data Control Language (DCL)
- Data Administration Commands (DAC)
- Transactional Control Commands (TCC)
|
|
Posted by Tamildhasan. (Oct 19, 2013) |
|
View Definition Language (VML); Storage Definition Language (SDL) |
5. |
What is data? |
|
Data is a collection of information stored in a database as one of several different data types. |