alert('Oh shit !!!! Javascript is disabled!!!! ');


Blog Archive

SQL Interview Questions


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.
2. Define Dbms?
A Database Management system consists of a collection of interrelated data and set of programs to access that 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.
6. What are the purpose of Normalisation?
  • Minimize redundancy in data.
  • Remove insert, delete and update anamoly during the database activities.
  • Reduce the need to reorganize data it is modified or enhanced.
7. Define Primary Key?
 
  • The primary key is the columns used to uniquely identify each row of a table.
  • A table can have only one primary key.
  • No primary key value can appear in more than one row in the table.
8. Define Unique Key?
  Unique key is a one or more column that must be unique for each row of the table.
It is similar to primary key. Primary key column will not accept a null. Whereas the unique key column will accept a null values.
9. Define Foreign Key?
  A foreign Key is a combination of columns with value is based on the primary key values from another table. A foreign key constraint also known as Referential Integrity Constraint.
10. Define View?
 
  • A View is a database object that is a logical representation of a table.
  • It is derived from a table but has no longer of its own and often may be used in the same manner as a table.
  • A view is a virtual table that has columns similar to a table.
  • A view does not represent any physical data.