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.
|