SQL Interview Question and Answers
| 1. |
Define SQL? |
| |
Structured query language is the standard command set used to communicate with the relational database management system. |
| |
| Puviya,says |
Feb 10, 2018 |
SQL stands for Structured Query Language
Its single Query and Command Query Execution.
|
| Mohit Sharma,says |
May 10, 2014 |
|
SQL is an Structured Query Language for communication and manipulation with the Database.
|
| Buddh priya,says |
May 06, 2014 |
|
SQL is basically Structured query language for the processing of data in the query format.
|
| Manju,says |
Apr 02, 2014 |
1) SQL is a language that allows you to communicate with databases.
2) SQL is a standard computer language for relational database management and data manipulation.
3) SQL is used to query, insert, update and modify data.
|
| Kamal, said |
July 03,2011 |
|
SQL means Structured Query Language.
|
|
| 2. |
Define Dbms? |
| |
A Database Management system consists of a collection of interrelated data and set of programs to access that data. |
| |
| Jayani Sumudini,says |
August 10, 2017 |
|
DBMS -Data Base Management System is a computer software application.It interacts with users, other applications and database itself, to capture and analyze the data.
|
|
| 3. |
What is the purpose of Database systems? |
| |
A Database Management system provides a secure and survivable medium for the storage and retrieval of data.In the real world, the data is shared among several users and is persistent. |
| |
|
| 4. |
State the different between Security and Integrity? |
| |
Security is a protection from malicious attempts to steal or modify data.
Integrity constraints guard against accidental damage to the database, by ensuribg that authorized changes to the database do not result in a loss of data consistency. |
| |
|
| 5. |
Define Normalisation? |
| |
Normalisation is an essential part of database design. A good understanding of the semantic of data helps the designer to built efficient design using the concept of normalization. |
| |
| Lahari ,says |
Feb 12,2018 |
|
Normalization is a systematic approach of decomposing tables to eliminate data redundancy and undesirable characteristics like Insertion, Update and Deletion Anamolies.
|
|
Gk Questions with Answers