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.
Your Name Your Email-ID
Your Answer
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.
Your Name Your Email-ID
Your Answer
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.
 
Your Name Your Email-ID
Your Answer
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.
 
Your Name Your Email-ID
Your Answer
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.
Your Name Your Email-ID
Your Answer